Rapid Database Application Development
"Microsoft Access for Linux"
started: April 2005, mart
1. KSpread data integration ^ toc
Currently, KSpread can import data from databases using the QtSQL framework. There are some problems with the current implementation (although these are certainly not the fault of the author of this feature).
It may be possible to maintain existing QtSQL functionality for DBs unsupported by Kexi, my implementing a QtSQL driver for Kexi, or a QtSQL migration driver. Obviously, the actual implementation used to import the data should be transparent to the user.
It should also be possible to use password stored in the user's KWallet, if Kexi has stored it there.^ toc
Step 1: Choose a database
Step 2: Provide a query
Either: (2a) Use data from a table stored in the database (or query if source is a Kexi DB) We can use the same dialog that we will use for selecting a table/query for reports. Ideally, something like the following, without the radio buttons. If the source is a Kexi database, we should show all tables and queries in the same list (perhaps with icons to distinguish between them). If not, just the list of tables.
Or: (2b) Allow the user to provide their own query
It might be interesting to allow the user to modify an existing query within the database.^ toc
The current Migration Framework only imports to Kexi DBs. There are two ways we could reuse these drivers:
The first method has the advantage that we can easily use the query editor to define queries on the imported data. However, the new database would need to be copied into a temporary database first, and will be less efficient.
The second method is more efficient, but limits the ability to query the database.^ toc
2. Reusing KSpread's expressions
Following things can be reused: