Re: [Kbooks-devel] SQL backend

[John H. <jo...@se...>]

On Mon, 13 May 2002 17:44:32 -0700, Andrew Nelson wrote:

>We can also make the program perform an autodetection on startup and create 
>the necisary databases.  However that might be .5.  :-)  There might be the 
>need for a perl script... however I'd like to avoid it.

I know that table creation should be easy in Qt... there's a QSqlQuery
class that allows you to do raw SQL, so we can do that easy enough.
Autodetection might be a little less easy to do through Qt, but it may
be possible... such as attempting to open a local postgresql, mysql or
ODBC connection... or, can the major SQL servers (including commercial
servers) be detected through a net broadcast? If so, that would make
things even easier... autodetect all available SQL servers and give the
user a choice at install... otherwise we may have to stick to localhost
server autodetection, which would probably be adequate for most small
scale users, and if not, they can enter their own damn IP address :)

>I was also thinking of having a table in the database store site wide and 
>user settings.  However it should not store security related settings.  This 
>way a user "hopefuly" does not have to be tied to a machine, and their 
>settings can "follow" them.  Any thoughts??

I agree, the database is a powerful tool that we'll know we have
available. We should use it. :)