[Qt-interest] Suggestions for Qt-compatible database software

[K. Frank]

Hello List!

I'm sketching out a project where I think that I will
want to store some static data in a database, and I am
considering writing a simple database viewer / editor
using Qt.

What database software "plays nice" with Qt?  (I am
using windows.)

My probable use case is that I will have a smallish
handful of tables.  It would be reasonably practical
to manage the data using command-line select, insert,
and update statements.  But it's a lot more convenient
to build a Qt gui application to help with that task.
(A separate application -- possibly, but not necessarily
Qt -- would be a read-only consumer of the data.)

I would like the database software to be free.  It
doesn't matter to me one way or the other if it's
open source.  It does not need to be transactional,
support large data sets, or be particularly high
performance.  I would want it to support a reasonably
standard version of sql, and offer the typical
command-line utilities (including an sql "shell" for
lack of a better term).

I do not mind if the database runs as a separate
server process, but -- to keep things lightweight
and simple -- I have would have a modest preference
for a scheme where the database functionality is
compiled into the client applications that access
the data files.

If possible -- not essential -- it would be nice to
have a reasonably convenient migration path to an
"industrial-strength" database, should I want to do
that in the future.

I haven't been paying close attention, but from some
of the postings I have seen on this list it seems that
people sometimes hit snags when using databases with Qt,
something I would like to avoid.  Since I'll be doing
simple, low-performance sorts of things, I would like
whatever approach I take to "just work."

Any advice and suggestions would be very welcome.

Thanks.


K. Frank