Anyone have done serious database project?

This forum can be used to talk about general design strategies, new ideas and questions in general related to wxWidgets. If you feel your questions doesn't fit anywhere, put it here.
Post Reply
User avatar
evstevemd
Part Of The Furniture
Part Of The Furniture
Posts: 2255
Joined: Wed Jan 28, 2009 11:57 am
Location: United Republic of Tanzania
Contact:

Anyone have done serious database project?

Post by evstevemd » Thu Sep 13, 2012 12:09 pm

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!
Chief Justice: We have trouble dear citizens!
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?
[Ubuntu 19.04/Windows 10 Pro/MacOS 10.13 - GCC/MinGW/Clang, CodeLite IDE]

User avatar
bishop.gis
Earned a small fee
Earned a small fee
Posts: 20
Joined: Fri May 25, 2012 6:47 pm

Re: Anyone have done serious database project?

Post by bishop.gis » Thu Sep 13, 2012 4:15 pm

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

ouch67
Earned some good credits
Earned some good credits
Posts: 134
Joined: Sun Mar 23, 2008 12:09 am

Re: Anyone have done serious database project?

Post by ouch67 » Fri Sep 14, 2012 5:39 pm

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.

User avatar
evstevemd
Part Of The Furniture
Part Of The Furniture
Posts: 2255
Joined: Wed Jan 28, 2009 11:57 am
Location: United Republic of Tanzania
Contact:

Re: Anyone have done serious database project?

Post by evstevemd » Tue Sep 18, 2012 9:24 am

It is supposed to be integrated to my app!
Chief Justice: We have trouble dear citizens!
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?
[Ubuntu 19.04/Windows 10 Pro/MacOS 10.13 - GCC/MinGW/Clang, CodeLite IDE]

Feneck91
Knows some wx things
Knows some wx things
Posts: 32
Joined: Tue Feb 28, 2006 7:47 am

Re: Anyone have done serious database project?

Post by Feneck91 » Fri Oct 12, 2012 8:19 pm

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...

User avatar
evstevemd
Part Of The Furniture
Part Of The Furniture
Posts: 2255
Joined: Wed Jan 28, 2009 11:57 am
Location: United Republic of Tanzania
Contact:

Re: Anyone have done serious database project?

Post by evstevemd » Tue Oct 16, 2012 4:47 am

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 ;)
Chief Justice: We have trouble dear citizens!
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?
[Ubuntu 19.04/Windows 10 Pro/MacOS 10.13 - GCC/MinGW/Clang, CodeLite IDE]

Post Reply