[Interest] Semi-OT: Pre-Compiled SQLite vs. building from source

[K. Frank]

Hello List!

I'm fixing to use SQLite with Qt (and will surely have more questions in the
future).  My first question:  What should I be downloading to get started?

I am currently using Qt 4.8.0-rc1 compiled with 64-bit mingw-w64 on 64-bit
windows 7.  The SQLite site offers pre-compiled windows binaries, but I
can't tell what they're built with or what they should be compatible with.

The core windows binary appears to be:

  sqlite-dll-win32-x86-3071200.zip

Am I right that the "x86" in the name means that it's 32-bit, and therefore,
regardless of what compiler it was built with, will be incompatible with my
64-bit Qt installation?  If so, am I right that my most practical option will
be to compile by own dll from source using the same 64-bit mingw-w64
compiler I used to build Qt?

Separately, the SQLite site offers sqlite-shell-win32-x86-3071200.zip and
sqlite-analyzer-win32-x86-3071200.zip.  Am I right that these are free-standing
programs that read (and write) the SQLite database files, and as such, will
be compatible with my Qt installation, regardless of how they were compiled?
(Although if I have to build the SQLite dll anyway, it would presumably be no
big deal to build these two free-standing programs, as well.)

And, of course, any other pointers for using SQLite with Qt would be welcome.

Thanks.


K. Frank