Re: [Kbooks-devel] SQL backend
Status: Inactive
Brought to you by:
duhprey
From: John H. <jo...@se...> - 2002-05-14 14:25:24
|
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. :) |