About the Library
wxDatabase is built on the excellent work of Joseph Blough called DatabaseLayer. You can read its story on history file.
The wxDatabase classes provide a database independent interface similar to JDBC (but only VERY basic functionality). So far, the only database backends supported are SQLite3, MySQL, PostGreSQL, ODBC, and TDS. Other Backends may be supported but they are not tested. We welcome you to help us testing them.
Of course the no brainer part: Have a database server running ;)
Although the C++ interface can be common between database, it should be noted that the SQL understood by the different database backends may vary.
The main interfaces of the component are:
Prerequites: wxDatabase is a library that add database support to wxWidgets. So you will need wxWidgets build. wxDatabases works with any wx29 series but you will save yourself a lot of pain by using 3.x instead as we test against that version.
BUILDING To build wxDatabase, you need to have the database development files for the database you want to connect (that is headers and library).
To succesfully compile with ODBC you need header and libs for your ODBC driver installed. Here are some places to download the files necessary for ODBC
To succesfully compile with TDS you need header and libs for FreeTDS driver installed. wxDatabase has been tested with freetds-1.00.24. Download the files from http://www.freetds.org/ and use CMake to build them.
Since Linux have so many distros, I will use Ubuntu (on which I do my development works) as example. It should not be too hard to make your favorite distro work.
First install the ODBC Manager. The Library is tested again UnixODBC but any other manager should work fine. To install UnixODBC in Ubuntu run
sudo apt-get install unixodbc-dev
Then install the driver of your choice
sudo apt-get install odbc-postgresql
sudo apt-get install libmyodbc
sudo apt-get install libsqliteodbc
sudo apt-get install freetds
In Windows, you just need to get development libraries and headers to compile wxDatabase. Here are places you can download the development files:
sudo apt-get install postgresql-server-dev-9.4
sudo apt-get install libmysqlclient-dev(check MySQL and MariaDB articles on how to setup repositories)
sudo apt-get install libsqlite3-dev
sudo apt-get install freetds-dev
A NOTE ON SQLite3
SQLite3 comes with wxDatabase distribution. This is the recommended way of bundling the library. However you can use installed SQLite3 library and it should work just fine. However its currently untested and would like to hear from those using the alternative.
- Install your compiler tool-set (Library is tested against GCC/MinGW. So reports on other compilers are welcome). Make sure your tool-set bin paths are added to system path.
- Install CMake and make sure its added to system path
- Change CMakeList.txt to enable/disable libraries as you want
- Compile wxWidgets and add the WXWIN environment variable pointing to root folder of wxWidgets to your System environment variables
- CD to wxDatabase/build on your terminal/CMD window
- Run CMake command to generate your Makefiles (e.g.
cmake Verbose=1 -G "MinGW Makefiles" ..).
- Run compiler (e.g.
mingw32-make). If the build finishes successfully the library and samples should be in build directory
- Run (Optional) install command (e.g.
mingw32-make install) to install the headers and library to prefix.
See the samples folder for demonstration on how to use wxDatabase library.
wxDatabase documentation is built with Doxygen. Download the latest version and follow the procedure in the next paragraph to build API documentation. You can view documentation on line at mtangoo.github.io.
To build documentation, change your directory to docs subdirectory. Then Issue
doxygen DoxyFile command fro terminal/CMD. if successful, it will generate the "html" subdirectory that contains html files for documentation.
The wxDatabase Team
wxDatabase is community driven and have a number of contributors. The following list includes only collaborators. Once we have a list of contributors, we will have special file for acknowledging them.
- Stefano Mtangoo (@mtangoo)
- Andrew (@manyleaves)
- Patrick Geltinger (@patlkli)
wxDatabase Library is released under wxWidgets License. If you want to give us credit, point URL to http://hosannahighertech.co.tz but its not mandatory. If you have any question that cannot be asked in wxWidgets forum or mailing list or its personal, contact me at support<(a.t)>hosannahighertech.co.tz