Bug 123974

Summary: Add support for real SQLite views as Kexi queries
Product: [Applications] KEXI Reporter: Mathieu Jobin <opensource>
Component: QueriesAssignee: Kexi Bugs <kexi-bugs>
Status: RESOLVED WORKSFORME    
Severity: wishlist CC: thomas.sisson.1
Priority: NOR    
Version: unspecified   
Target Milestone: ---   
Platform: unspecified   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: x-kexiproject-sqlite3.xml

Description Mathieu Jobin 2006-03-20 10:58:35 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 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
Comment 1 Jarosław Staniek 2006-03-20 11:23:23 UTC 
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.
Comment 2 Jarosław Staniek 2006-05-25 21:01:58 UTC 
Planned for 2.0 version or later.
Comment 3 Mathieu Jobin 2013-01-23 01:41:28 UTC 
still planned?
Comment 4 Thomas Sisson 2013-05-10 21:43:55 UTC 
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.
Comment 5 Jarosław Staniek 2013-05-10 22:00:02 UTC 
@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
Comment 6 Jarosław Staniek 2013-05-10 22:00:56 UTC 
Created attachment 79820 [details]
x-kexiproject-sqlite3.xml
Comment 7 Jarosław Staniek 2013-05-10 22:04:21 UTC 
@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.
Comment 8 Mathieu Jobin 2013-07-08 22:30:56 UTC 
looking forward better sqlite support in kexi
Comment 9 Mathieu Jobin 2020-12-07 09:12:56 UTC 
my dreams of using kexi one day has all vanished
good luck