[Qt-interest] Database agnostic programming

[André Somers]

Hi,

I am not using PyQt, but it is a very interesting project nontheless! It may 
be a serious contender for the future, that might be integrated using Kross 
in the future. Currently Kross does not work with Python on windows, but 
that may change in the future of course. If it does, then maybe it would be 
possible to build some nice interface for use from Qt/C++.

André


"Thomas Dähling" <t.daehling at googlemail.com> schreef in bericht 
news:49C975A9.8060707 at googlemail.com...
> Hi,
>
> in case you are using PyQt you might want to take a look at SQLAlchemy 
> (http://www.sqlalchemy.org). I don't know of any such interface for C++, 
> even though I'd be highly interested in such a thing as well.
>
> /Thomas
>
> André Somers schrieb:
>> Hi,
>>
>> I have build some Qt based software that interfaces with a database. Now, 
>> we would like to make the program database agnostic. That is: we want to 
>> make it possible to choose a different database as the backend to store 
>> the data. While Qt gives me a good way to connect with the different 
>> databases, there is no solution for the different SQL dialects that are 
>> used, especially for slightly more advanced select queries and for table 
>> creation and modification queries. Issues range from different names for 
>> data types, different date notations, different characters around table 
>> names and values to differences in things like TOP version LIMIT 
>> keywords.
>>
>> How do other people solve this issue? Is there some library available 
>> somewhere that can "translate" SQL dialects? One option I am looking into 
>> is KexiDB, but the page seems a bit outdated so I am not sure what the 
>> current status is. Meanwhile, other suggestions are very welcome!
>>
>> André _______________________________________________
>> Qt-interest mailing list
>> Qt-interest at trolltech.com
>> http://lists.trolltech.com/mailman/listinfo/qt-interest
>>