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!
Anyone have done serious database project?
- evstevemd
- Part Of The Furniture
- Posts: 2409
- Joined: Wed Jan 28, 2009 11:57 am
- Location: United Republic of Tanzania
Anyone have done serious database project?
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?
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?
- bishop.gis
- Earned a small fee
- Posts: 20
- Joined: Fri May 25, 2012 6:47 pm
Re: Anyone have done serious database project?
That DB paln to use?
Do you see pgAdmin III?
Do you see pgAdmin III?
Re: Anyone have done serious database project?
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.
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.
- evstevemd
- Part Of The Furniture
- Posts: 2409
- Joined: Wed Jan 28, 2009 11:57 am
- Location: United Republic of Tanzania
Re: Anyone have done serious database project?
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?
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?
Re: Anyone have done serious database project?
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 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...
- evstevemd
- Part Of The Furniture
- Posts: 2409
- Joined: Wed Jan 28, 2009 11:57 am
- Location: United Republic of Tanzania
Re: Anyone have done serious database project?
I decided to go with Databaselayer after few disappointments with SOCI.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...
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?
Citizens: What it is his honor?
Chief Justice:Our president is an atheist, who will he swear to?