Bug 123956 - Add support for regular sqlite database files and connections to existing MySQL databases
Summary: Add support for regular sqlite database files and connections to existing MyS...
Status: CLOSED LATER
Alias: None
Product: KEXI
Classification: Applications
Component: KexiDB (other bugs)
Version First Reported In: unspecified
Platform: unspecified Linux
: NOR wishlist
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-03-20 03:19 UTC by Mathieu Jobin
Modified: 2016-01-29 19:57 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mathieu Jobin 2006-03-20 03:19:38 UTC
Version:           1.0 beta 2 (KOffice 1.5-beta2) (using KDE 3.5.1, Gentoo)
Compiler:          gcc version 3.3.6 (Gentoo 3.3.6, ssp-3.3.6-1.0, pie-8.7.8)
OS:                Linux (i686) release 2.6.15-suspend2-r6-justbudget

I wish kexi would be able to list tables not listen in system-hidden-tables.
and also that system-hidden-tables would only be created when required.

if I want to create a database with some other software and use kexi with it later, without importing/exporting, it should be possible.

I can't ask the other software to support the kexi format. but kexi could not required those system table to be created.

thanks
Comment 1 Jarosław Staniek 2006-03-20 10:12:35 UTC
Agreed. This is called linking to external data. Planned for Kexi 1.1 but due to KDE4-related tasks it's more realistically to expect it in 2.0.
Comment 2 Mathieu Jobin 2006-03-20 10:55:25 UTC
well, .kexis file already link to mysql database, but won't scan for tables.
kexi will only know about table created within kexi.

as for sqlite, since .kexi file are native sqlite file, i wish linking would not be necessary here. but kexi would simple understand .kexi, .sqlite, .sqlite3 files as the same thing. but instead of creating empty system tables upon database creation, it would only be created once required. Like, when you create a form, a query, or something like that.

and at that point, I suppose table and field list would not need to be stored in system table anymore.

they could be cached i guess, but primary info would be taken from the core. well, I'm just speculating how I would like things to be.

thanks, kexi is coming along very well, and I'm happy its part of the official koffice 1.5 release.

thanks
Comment 3 Jarosław Staniek 2006-05-25 21:01:21 UTC
Planned for 2.0 version.