[Qt-interest] [Qt5-feedback] Qt5 and SQL

[charles.yin at nokia.com]

I agree with most of your ideas. Now days we need to make our applications talk to a lot of different type data stores: 

RDBMS (SQL), 
RDF(SPARL),
XML(XPath, XQuery...),
JSON,
Key-Value stores (NoSQL...)....

They can be accessed locally or remotely, they have different capabilities (transactions, queries, schemas, etc), but we do need an elegant, simple, easy to use unified data framework to manage the details.  For GUI world, Qt always did, does and will do a fantastic  cross platform job, for the underlying data managing world, Qt should play as the same role with the same great level.

I think we can discuss and discover what the good data framework should contain in the summit and what are the most feasible parts and what we can do for the Qt 5.x of course.

Cheers
Charles
-----Original Message-----
From: qt5-feedback-bounces+charles.yin=nokia.com at qt.nokia.com [mailto:qt5-feedback-bounces+charles.yin=nokia.com at qt.nokia.com] On Behalf Of ext Andre Somers
Sent: Wednesday, May 18, 2011 5:15 PM
To: qt-interest at qt.nokia.com
Cc: qt5-feedback at qt.nokia.com
Subject: Re: [Qt5-feedback] [Qt-interest] Qt5 and SQL

Op 17-5-2011 23:24, Jason H schreef:
> Can you clarify what love you would like QtSQL to get?
* Support for DDL
* Easier to use and way better documented way of creating db-independent queries (QSqlDriver::sqlStatement is the key, but it is not documented properly, nor is it recommended to use QSqlDriver in end-user code)
* Support for more types of query parts (limit vs. top, sort, grouping)
* QSql*model classes need to be asynchronous
* Actually apply the fixes that are available already as merge requests or attached to bug reports
* Fix some of the other issues, like that table names are not escaped properly
* A way to represent database settings in a database independent way

Most of the above, I managed to build myself on top of the existing QtSql code, but it could have been so much easier to get my application to work properly independent of the database type...

But, I could imagine that QtSql could become part of a broader Qt data framework. Relational database are, after all, only one way to store and manage data. It would be very nice if there would be framework that would allow easy interaction with these different types of backends with a single interface.

André

_______________________________________________
Qt5-feedback mailing list
Qt5-feedback at qt.nokia.com
http://lists.qt.nokia.com/mailman/listinfo/qt5-feedback