sqlite in kdelibs
geiseri at sourcextreme.com
Wed Jan 19 15:00:48 GMT 2005
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.
-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.
> for more info, or meet us at #kexi irc channel.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: not available
More information about the kde-core-devel