sqlite in kdelibs

[ian geiser]

This is insane.  Why the heck do we need SQLite in KDE libs when its built in 
to Qt SQL?  If anything we should be adding Qt sql config classes into KDE 
libs.  I have such a lib that has a stock config gui for managing Qt sql 
database connections and providing the correct Qt sql classes.  You basicly 
call the method sxDBHandle(const QString &profile) and it hands you back the 
setup database connection.   Very similar to the ODBC config guis of ye old 
days but for Qt sql drivers.  There is absolutely no good reason under any 
circumstances that we should even propose duplicating Qt sql in KDE libs.  
Its not worth the extra bug reports.  In the last 4 years of commercial Qt 
development with Qt sql I have only run into one instance where it had 
problems, and that was because the idiot client wanted to store 1+MB blobs in 
the database.  Let the trolls maintain it and fix the bugs.  If people want 
to re-invent the wheel let them do it in their own modules and bug databases.

If anyone wants to play with my config stuff I can lgpl it and put in in 
nonbeta.  Basicly its a QWidget that stores to a QSettings object, but 
conversion to a control panel and kconfig would be trivial.  There are some 
simple db managment methods for adding and dropping a database, but those 
should be replaced with something more complete, or removed all together.

Cheers
 -ian reinhart geiser 

On Wednesday 19 January 2005 08:41 am, Jaroslaw Staniek wrote:
>  >Besides, wouldn't databases be something pluggable.  E.g. using ODBC.
>  >That way data from many applications can be combined at database level.
>  >This would be quite simple if SQL strings was externalized into config
>  > files. If no other database was specified,  one could fall back on SQL
>  > lite.
>
> Since 2003, KexiDB is a candidate for being exactly such a solution for
> kdelibs. KexiDB module uses SQLite almost from the begging and provides
> library and set of widgets (table grid, and recently - forms). Database
> drivers are provided as plugins (MySQL, PostgreSQL drivers also available).
>
> Please notice that KexiDB is also (except in Kexi) used by ShowImg (digiKam
> competitor) for image catalogs, thus it's so far, application which is
> doing things properly without rewriting KexiDB functionality.
> Btw, it's also planned to develop optional Qt-only KexiDB version.
>
> see
> http://www.kexi-project.org
> http://koffice.org/developer/apidocs/kexi/html/
> for more info, or meet us at #kexi irc channel.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/kde-core-devel/attachments/20050119/a775306e/attachment.sig>