Re: [QSQLite-users] Introduction and information request

[Andreas S. <sc...@we...>]

Hi

I have just started to help out on a photo management application called iota. 
The first task I am look at is moving the current Berkely database backen to 
a more 'full featured' database. Sqlite is looking like a good fit. 

My current dilemma is whether to interface directly with sqlite or instead to 
use the Qt database interface and use qsqlite. This would provide for adding 
support for other, larger, databases later but raises some concerns in my 
mind.

I would use the Qt database sheme beacause sqlite would be included int the upcoming 3.3 release.


I am not new to programming or to databases but I am new to Qt and sqlite, so 
bear with me if I sound a little nieve.

On with the questions...

1) How mature / stable is qsqlite? I don't mind helping to stablise it, I just 
want to get a feel for what I am letting myself in for.
-- For normal use i would say its stable. For myself i never had problems with it.


2) qsqlite is not currently part of the main distros (at least not Gentoo 
which is my development platform). What would our app need to do at install 
time to make qsqlite available? Is it possible to install qsqlite just for 
use with one app or is there a separate 'system wide' install that the user 
would need to perform? Is it possible to package qsqlite along with the app 
if needed? I am concerned that the install process should remain as simple as 
possible or at least as simple as it is with the existing Berkeley database.
-- You could do it with shiping the needed sqlite files with your package or 
wait until qt3.3 or let the user do the work and link to sqlite ...

3) From what I understand about sqlite, the user does not need to perform any 
initialisation steps prior to an app making use of the database and there are 
no 'username, password' issues for the user to deal with. Is this true for 
qsqlite as well? 
-- You could so all that thing inside you app and the user didn't know what happens ...


I hope these questions make sense. Deciding on a database interface approach 
is a tricky decision and will have long lasting implications for the internal 
architecture of the app, so I hope you don't mind me asking these questions. 
-- I hope this answers make sense ;-)

If you need an example look at
http://krunning.sourceforge.net 
i'm using sqlite there ...



Many thanks.

Richard

No Problem
Andreas


- -- 
Jabber: Ric...@ja...
PGPKey: http://search.keyserver.net:11371/pks/lookup?op=get&search=0xA7DA9FD9
Key fingerprint = D051 A121 E7C3 485F 3C0E  1593 ED9E D868 A7DA 9FD9
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFABQAo7Z7YaKfan9kRAjHwAJ41ZdOjcEIGcJPUtHKh8ivBQ9RqvQCZAWPo
lBPdtRtdwfN3YB8x9ymVfXw=
=1sIR
-----END PGP SIGNATURE-----



-------------------------------------------------------
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fast Software Configuration Management System offering
advanced branching capabilities and atomic changes on 50+ platforms.
Free Eval! http://www.perforce.com/perforce/loadprog.html
_______________________________________________
QSQLite-users mailing list
QSQ...@li...
https://lists.sourceforge.net/lists/listinfo/qsqlite-users


______________________________________________________________________________
Nachrichten, Musik und Spiele schnell und einfach per Quickstart im 
WEB.DE Screensaver - Gratis downloaden: http://screensaver.web.de/?mc=021110