Please consider doing a build with mysql,psql,odbc,oracle support

[GoogleCodeExporter]

For the TOra project (tora.sf.net) windows binary build, we're having to
maintain our own build of Qt libs to enable the DB plugins and MSVC
support. Ran across your project which looks like exactly what we need, but
alas, no DB plugins other than SQLite appear to be enabled.

Would you consider doing a build with support for the various DB platforms
that QT will support? Since they are plugins, I would assume that there
should not be any direct dependency issues unless someone chooses to use
those plugins - at which point, the DB-specific libraries would need to
have been installed.

Original issue reported on code.google.com by nathan.n...@gmail.com on 16 Aug 2009 at 6:38

[GoogleCodeExporter]

Hmm, I think I would need the DB-specific developer libraries to be able to 
*build* DB-
specific libraries but I would not be opposed to setting up the build to 
include as 
many plug-ins as possible.

If you have familiarity with what extra developer libraries I would need to 
support 
building the mysql,psql,odbc and orcacle plug-ins let me know and I'll try 
including 
them in the next build.

Original comment by gaber...@gmail.com on 24 Aug 2009 at 1:04

[GoogleCodeExporter]

In the case of oracle, just need to have a copy of oracle express edition or 
instant
client installed. For postgres + mysql, should just have to have the 
development libs
installed. Here's the notes from the tora build document:

----------
  0. All related steps are done in the "Visual Studio Command Prompt"
     I have MS Visual Studio 2008 Express (aka version 9). It contains
     all basic tools propably so there is no more stuff from Microsoft
     required.

  1. Downaload Qt4 source version for Windows - Trolltech doesn't provide
     MSVC binaries at all. I didn't find a nice download link for this, but
     it was available from the FTP server:

        URL: ftp://ftp.qtsoftware.com/qt/source/qt-all-opensource-src-4.5.2.zip

  2. Install Oracle client - instant or standard one.

  3. Download and install Postgresql development packages. It's a part
     of default installer - just check its component.
     NOTE: Install it to the path *without* space in its name - Qt has
           problems with compilation in the case of space.

        URL: http://www.enterprisedb.com/products/pgdownload.do#windows
        Testing with version 8.4.0
        Seems that this installer doesn't prompt for any paths/etc.
        Be sure and disable postgres service after install if you won't be running
the server itself

  4. Download and install Mysql development packages. It's a part
     of default installer - just check its component.
     NOTE: Install it to the path *without* space in its name - Qt has
           problems with compilation in the case of space.

        URL: http://dev.mysql.com/downloads/mysql/5.1.html#win32
        I am testing with the 5.1.37 MSI installer, not the 'Essentials' one

  5. Update system environment paths in variables: INCLUDE and LIB to
     fit Postgresql and Mysql includes and libraries.
     Note: Mysql uses subdirectories in its lib directory.
     Example:
set INCLUDE=%INCLUDE%;d:\Qt\sqlite\;D:\Qt\pgsql\include\;d:\Qt\mysql\include\
set LIB=%LIB%;d:\Qt\sqlite\;d:\Qt\pgsql\lib\;d:\Qt\mysql\lib\opt\

  6. Compile Qt4 with MSVC. Don't forget to specify -qt-sql-mysql
     -qt-sql-psql -qt-sql-odbc -plugin-sql-mysql -plugin-sql-psql
     -plugin-sql-odbc parameters for configure script.
     Example:
configure.exe -plugin-sql-sqlite -system-sqlite -plugin-sql-mysql 
-plugin-sql-psql
-plugin-sql-odbc
     but it dependes on your system mood. I mean it's not deterministic.
     Sometimes you will need to hack more paths etc. But building DB
     plugins is described in the Qt documentation.
------------------

Original comment by nathan.n...@gmail.com on 27 Aug 2009 at 4:35

[GoogleCodeExporter]

Alright, thanks.

I plan on doing the next build with the next Qt release but I'll see about 
supporting 
as many of these as I can.

Original comment by gaber...@gmail.com on 27 Aug 2009 at 4:42

• Changed state: Accepted

[GoogleCodeExporter]

Check out the 4.5.3 build! It contains MySQL Postgresql and OCI plugins 
compiled in. 
(Postgresql does not have 64-bit developer libraries so no go on that plugin 
for the 
64-bit builds).

Original comment by gaber...@gmail.com on 23 Dec 2009 at 5:21

• Changed state: Fixed