Kexi/Links: Difference between revisions
< Kexi
Line 53: | Line 53: | ||
*[http://books.google.com/ngrams/datasets datasets used by the Google Books Ngram Viewer] (free as beer) | *[http://books.google.com/ngrams/datasets datasets used by the Google Books Ngram Viewer] (free as beer) | ||
*Wiktionary database. It exists in MySQL format but can be [http://code.google.com/p/wikokit/wiki/SQLite converted into SQLite file]. | *Wiktionary database. It exists in MySQL format but can be [http://code.google.com/p/wikokit/wiki/SQLite converted into SQLite file]. | ||
===Optimizing=== | |||
*Options for [http://componavt.livejournal.com/3393.html SQLite speedup], could be offered via Kexi Tuning Tools | |||
==Competition== | ==Competition== |
Revision as of 21:47, 18 December 2011
- Linq++
- A simple experimental implementation of a LINQ-like query language for C++ containers.
- What users hate and what like about MSA 2k7
- LoXiM
- An experimental, an object oriented, semistructured Database Management System.
- JotForm
- web-based forms, compare to kexi web forms...
- Quick Reference Guides to Popular Software
- good idea for koffice apps
- Kexi commit RSS
- Customize here
- Qt Property Browser
- Qt Solution similar to our KoProperty2. But at the time of writing the former we did not have access to LGPLed Qt Property Browser.
- Grantlee
- Open Source string template system based on the Django template system from the Django project
- uSQLite
- A network wrapper for SQLite
- Tanit
- A set of Oracle to Kopi (a Java based framework) migration tools providing automatic translation of your Oracle PL/SQL, Forms and Reports applications.
- TOra
- An open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, Postgres, and ODBC.
- SchemaSpy
- A Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format.
- MDB Tools
- A library for accessing Microsoft Access .mdb files
- qooxdoo
- (pronounced ['ku:ksdu:]) is a framework for creating desktop-style web applications (rich internet applications, RIAs) for desktop and mobile clients; idea: use it for the next generation Kexi WebForms.
- Saint
- A suite of tools to assist in the workflow for doing bibliometric/ scientometric research, that is, research into the workings of the science system itself based on data on publications, patents and so on. Qt Ambassador link, by André Somers, adds DDL and more on top of QtSQL, connects with MySQL and MSA (the latter with MS ADO); jstaniek met André at QtCS 2011; see also QtSQL discussions at Qt5-feedback
Ideas
- Enable searching actions by name like on Mac [1] [2] (or Plasma)
- Menu ideas [3]:
- Pontoon - interesting approach to localization
- Use Open Database License (ODbL) for example Kexi databases
- Idea for Improvement of Tabbed Toolbars
- Opera visual tabs
- OData, the Open Data Protocol, is a Web protocol for querying and updating data. Even MSA can support it.
- Finally add support for themes/color palettes like in MSO
- Google Labs
- Google Labs data wiki - wiki for structured data; our old idea was similar, to implement wiki-like database creator on top of KexiDB/Predicate
- Google Labs sets - have you ever wanted to larger test set of items from give category? E.g. animals? Google sets uses the big database and categories to discover matching set and return its items. Can be useful as a plugin for Kexi.
- Google Fusion Tables - storage for Kexi?
- Forms, Reports
- Reuse Spatialite, Sqlite GIS extension
- BOND uses database comments to store information about casual relationships
- it's good idea to have some use/reuse of db comments in Kexi but it's not clear if it's safe to use them for metadata since users would already depend on comments for other purposes; so BOND usage of comments is a bit hacky
- it's good idea to have casual (weak) relationships, it's compatible with how KexiDB/Predicate is going to deliver relationships (i.e. both strong and casual)
- KoolGrid - web grids
- Explore topic of Faceted search, related to "Query by example".
- Google Cloud SQL is web service that allows you to create, configure, and use relational databases with your App Engine applications.
- Kexi could propose to disable or uninsatll the least used plugins, see how Thunderbird does this [12].
Kexi-based bugzilla client
Make Kexi useful as GUI for KDE Bugzilla. Reason: to eat our own dog food in Calligra. Use bugzilla's webservices for this. Probably separate plugin could be developed. Online/offline operations with synchronization. (discussed with Inge who likes the idea)
Use Fossil DVCS to handle versioning in Kexi file db
Fossil SQLite-based DVCS, so fits nicely to Kexi needs. It lacks crazy ideas of git, stability is the goal.
Free test Data for Kexi
- datasets used by the Google Books Ngram Viewer (free as beer)
- Wiktionary database. It exists in MySQL format but can be converted into SQLite file.
Optimizing
- Options for SQLite speedup, could be offered via Kexi Tuning Tools
Competition
- Ribbon Designer
- what's new in 'the other' GUI impl.
- Theme Builder
- It would be far easier to implement ODF replacement, since unlike MSOOXML, ODF shares more styles with the same XML markup across apps. For Kexi Forms and Reports themes is a TODO as well.
- Developing Access 2007 Solutions with Native C or C++
- MSA 2k10 gets a kind of triggers
- Netbeans GUI looks similar to Kexi 2 GUI in some aspects
- Total Access Statistics 2010 for MSA 2010
- Beyond generic databases...
- Qtitan DataGrid
- Ideas for grouping
- Genero Report Writer
- Reporting tool, TODO: perform research :)
- Zoho Creator
- Like MSA Online: https://www.zoho.com/creator, https://www.zoho.com/creator/migrate-msaccess-database.html
- Office 2010 menu to ribbon reference workbooks
- (xlsx files)
- Ways to use Access data in Excel
- FileMaker's docs
- Lotus Approach
- Alpha Five
- OnlineGlom
- Simple Visual Database Creator
- Let's look at its simplicity
- Ways to use Access data in Excel
- Similar to plans of Kexi/Tables integration
- MSO 2k10 branding - the modern menu is close already
Misc
- A book mentioning Kexi
- kexi-project.org links:
- "Open Source Databases" presentation: "No proprietary options on Linux – OpenOffice.org Base or Kexi are your best bets."
- MS strongly recommends not to use MSA on Web Server. It says that when multiple, concurrent users make requests of a Microsoft Access database, unpredictable results may occur.
- Adaptive Coloring for Syntax Highlighting