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 am not even sure SQLite3 system supports Views. but if it does, I wish kexi's queries would in fact be real SQLite views, which can later be use as standard tables in other queries. in the same way, views created from sqlite, should be seen by kexi as queries. thanks
SQLite support views: http://sqlite.org/lang_createview.html The problem with handling foreign SQL variants is that we need to parse the statements to fully support them - I wanted to avoid this (SQLite has no good schema introspection as e.g. pgsql). I could suppose that server engines handle views in a special way, e.g. by optimizing them. This is not the case in SQLite - the view is just an SQL string, i.e. it contain less information than Kexi query definition. Moreover - as planned for Kexi - queries will not only be DQL but also: - DDL (DROP, TRUNCATE, CREATE, ALTER) - DML ( DELETE, INSERT, UPDATE) These cannot be mapped to views. That said, I agree DQL->View mapping will be valuable.
Planned for 2.0 version or later.
still planned?
On my system with Kexi and KDE 4 installed, Kexi is set as the default application to open sqlite3 files even though it apparently cannot. This was preset, not a user setting. I'm hoping that the planned fix will stop adding association of non-Kexi databases. Unfortunately, removing the association once established is something that must be fixed by the user. I cannot determine the version of Kexi due to the lack of Help > About dialog, but it says 2.4.0 under the Calligra image and was installed as part of the whole Calligra package.
@Thomas I guess your system is Kubuntu. Association should be set to .kexi extension only as this is the only way to say the difference between non-Kexi and Kexi file in SQLite format. I wonder if this could be reported to Kubuntu. The definition perhaps can be found at /usr/share/mime/application/x-kexiproject-sqlite3.xml and I am attaching one from my system (openSUSE) below. The help menu is in under the drop down button: http://wstaw.org/m/2013/05/10/plasma-desktopNc2761.png
Created attachment 79820 [details] x-kexiproject-sqlite3.xml
@Thomas I also think this bug #123974 is not about supporting whole SQLite3 files. This bug is better: https://bugs.kde.org/show_bug.cgi?id=125843 though it is about support via importing. Support via direct opening should be reported as a separate wish if needed.
looking forward better sqlite support in kexi
my dreams of using kexi one day has all vanished good luck