wxWidgets Discussion Forum

I need to code a SQL browser where I can view results of SQL Select statements as well as list available databases and tables.
I tried soci and I find difficult to work with it (may be I have not just got it well).
I need assistance of opinions on database library from people who have actually coded project that includes working with databases in C++/wxWidgets

Thanks!

That DB paln to use?
Do you see pgAdmin III?

Yeah it largely depends on what database your using as to what to library to recommend...

But from your description just a database browser will suffice. I use the free one here:
http://www.etl-tools.com/database-edito ... rview.html

You can enter in sql statements and see the results. You can also export those results to a CSV file. Which you can then open that up with spreadsheet software and do some fancier things with the data.

Their ETL tools are also quite good if you need such a thing.

It is supposed to be integrated to my app!

I have a serious project with database managment.
I use sqlite3 + wxSqlite3 + my own librairie (wxETKSQLite3) based on wxWidgets + wxSQlite3.
All is open source. My last work was to make a workaroud wxSqlite3 to make my lib compatible with QT.
With this lib I don't have to make my ow SQL request, the binding is automatically done with my C++ class.
Just need to describe you table and a lua script (called when compiling) generate all files needs (c++ classes binding). Hope I'll published into wxCode one day...
I don't know what's your real needs but if you want to try I can give you a copy...

Feneck91 wrote:I have a serious project with database managment.
I use sqlite3 + wxSqlite3 + my own librairie (wxETKSQLite3) based on wxWidgets + wxSQlite3.
All is open source. My last work was to make a workaroud wxSqlite3 to make my lib compatible with QT.
With this lib I don't have to make my ow SQL request, the binding is automatically done with my C++ class.
Just need to describe you table and a lua script (called when compiling) generate all files needs (c++ classes binding). Hope I'll published into wxCode one day...
I don't know what's your real needs but if you want to try I can give you a copy...

I decided to go with Databaselayer after few disappointments with SOCI.

But sharing your code here is nice since people learn alot from other