From kde-core-devel  Fri Mar 30 16:01:01 2001
From: Reginald Stadlbauer <reggie () trolltech ! com>
Date: Fri, 30 Mar 2001 16:01:01 +0000
To: kde-core-devel
Subject: Re: KDEDB (Re: Oracle support in kdedb)
X-MARC-Message: https://marc.info/?l=kde-core-devel&m=98596816606325

On Friday 30 March 2001 01:35, Henrik Johnson wrote:
> > On Thursday 29 March 2001 17:14, David Faure wrote:
> > > On Wednesday 28 March 2001 23:49, Dan Williams wrote:
> > > > I was just starting to look at doing a DB/2 module myself.  I have it
> > > > installed on my system.
> > > >
> > > > I agree that having support for DB/2 & Oracle would be a big plus.
> > > >
> > > > On Wednesday 28 March 2001 08:15 am, Shawn Gordon wrote:
> > > > > If anyone is interested, a DB2 module would also be very cool. 
> > > > > I've got a copy of DB2 here, but we haven't had a chance to do
> > > > > anything.  I think having 2 or 3 of these high end commercial
> > > > > databases accessible via konqueror and KDE-DB would be totally
> > > > > cool.
> > >
> > > Hmm, I think that before anyone spends too much time writing
> > > kdedb plugins, it would be a good idea to reach a decision about kdedb.
> > >
> > > This discussion has started privately, but should rather be held here
>
> IMHO.
>
> > > On one hand, Qt 3 is arriving with DB support.
> > > On the other hand, we have kdedb now, but the author (Alessandro),
> > > and theKompany in general, seem to indicate that they don't intend
> > > to maintain it in the future.
> >
> > That's not completely true. ATM I have little time to do it, but I don't
>
> want
>
> > to drop it at all.
> > The question then should be the following:
> > will the forthcoming qt3 database library cover all the needs we have?
>
> Maybe
>
> > we can drop the library, but what about the ioslave and the kcontrol
>
> modules?
>
> > they can (and will, if we choose to rely on qt3 sql access) be ported to
>
> the
>
> > new architecture.
> >
> > Can someone knowing what qt3 db library will look like tell us something
> > about it?
>
> I've downloaded it and had a look at it and it seems like the Qt DB
> interface is a subset of KDE DB. You have no builtin functionality to
> browse databases and/or modify/create database objects in Qt SQL. 

That is incorrect.  It is very simple to browse the database, and 
create/modify objects or even entire databases.  For example:

         QStringList t = mydb->tables(); // get a list of all tables

         mydb->exec( "CREATE TABLE tmp (id int);" ); // create a temp table

         QSqlCursor tmp( "tmp" ); // use the temp table
         QSqlRecord* buf = tmp.primeInsert();
         buf->setValue( "id", 72 )
         tmp.insert(); // insert into the temp table

        mydb->exec( "DROP DATABASE foo;" ); // drop an entire database
         
The SQL language provides most, if not all, of the functionality required to 
manipulate a relational database.  The Qt SQL module provides  a 
database-independant API to use SQL -- with some additional classes 
(QSqlCursor, QSqlIndex, etc) which offer some convenience and standard 
behavior and algorithms.

Please have a look at the sql.html file in the documentation of the snapshots 
for an overview, examples, etc. to find out what you can do.

-- 
Reggie (reggie@trolltech.com)