wxDatabase Library

Do you like to promote your wxWidgets based application or component!? Post it here and let's see what the critics have to say. Also, if you found that ONE wx component the world needs to know about, put it here for future reference.
Post Reply
User avatar
evstevemd
Part Of The Furniture
Part Of The Furniture
Posts: 2104
Joined: Wed Jan 28, 2009 11:57 am
Location: United Republic of Tanzania
Contact:

wxDatabase Library

Post by evstevemd » Wed Oct 28, 2015 4:46 pm

wxDatabase is database library built on top of wxWidgets that provide a database independent interface similar to JDBC.The library supports SQLite3, MySQL, PostGreSQL, ODBC, and TDS. There is no yet any release but the library is currently working with no major issue.

We need people who will test the library for any issue before we plan for release.
We welcome suggestions and criticism aimed at making database access with wxWidgets better.

The library is found on GitHub -- https://github.com/mtangoo/wxDatabase

Cheers,
Stefano (for the wxDB team)
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 15.04/Windows 10 Pro - GCC/MinGW, CodeLite IDE et al]

User avatar
doublemax
Moderator
Moderator
Posts: 13132
Joined: Fri Apr 21, 2006 8:03 pm
Location: $FCE2

Re: wxDatabase Library

Post by doublemax » Wed Oct 28, 2015 5:07 pm

God, how i hate exceptions. Why does everyone else love them so much... ? :wink:
Use the source, Luke!

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

Re: wxDatabase Library

Post by evstevemd » Wed Oct 28, 2015 5:35 pm

doublemax wrote:God, how i hate exceptions. Why does everyone else love them so much... ? :wink:
I do too. Its in my to do list to remove exceptions. These are leftovers from databaselayer library.

However, I will appreciate pull request fixing that or an issue with better way of fixing the issue.
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 15.04/Windows 10 Pro - GCC/MinGW, CodeLite IDE et al]

User avatar
doublemax
Moderator
Moderator
Posts: 13132
Joined: Fri Apr 21, 2006 8:03 pm
Location: $FCE2

Re: wxDatabase Library

Post by doublemax » Wed Oct 28, 2015 6:01 pm

I do too. Its in my to do list to remove exceptions. These are leftovers from databaselayer library.
That's good to hear :)
Use the source, Luke!

dlutlzs
In need of some credit
In need of some credit
Posts: 5
Joined: Tue Jul 22, 2008 6:27 am

Re: wxDatabase Library

Post by dlutlzs » Wed Dec 23, 2015 9:09 am

Dear Sir,
I want to use "wxDataBase" to connect to MySql, but I encounter problem of compile it. I am working on win10 + vs2010, I have download your source code and also installed mysql-connector which you mentioned. Then I add your source files about MySql to my project, compiled without problem but has link error of the construct API of wxMysqlDatabase. Then I found the macro "wxUSE_DATABASE_MYSQL" and "WXMAKINGLIB_DATABASE" are not defined, I get the following errors after defined these two maro:

1>C:\Program Files\MySQL\MySQL Connector C 6.1\include\mysql_com.h(345): error C2146: syntax error : missing ';' before identifier 'fd'
1>C:\Program Files\MySQL\MySQL Connector C 6.1\include\mysql_com.h(345): error C4430: missing type specifier - int assumed. Note: C++ does not support default-int
1>C:\Program Files\MySQL\MySQL Connector C 6.1\include\mysql_com.h(345): error C4430: missing type specifier - int assumed. Note: C++ does not support default-int

What I missed? Or can you tell me how to compile it correctly?

Thanks & Best Regards
Li

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

Re: wxDatabase Library

Post by evstevemd » Sun Jan 03, 2016 4:18 am

Did you use CMake to generate the files?
Can you provide steps you went through to generate VS file?

I do not use Visual Studio but you can just add the two in preprocessor option (I don't know what VS calls it). But the best way would be generating build files with CMake.

if you follow steps and still does not work consider opening an issue in github for close followup!
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 15.04/Windows 10 Pro - GCC/MinGW, CodeLite IDE et al]

airc
Knows some wx things
Knows some wx things
Posts: 25
Joined: Mon Jan 06, 2014 7:35 am

Re: wxDatabase Library

Post by airc » Mon Jan 11, 2016 4:05 pm

there is no firebird backend ! .

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

Re: wxDatabase Library

Post by evstevemd » Mon Jan 11, 2016 4:43 pm

airc wrote:there is no firebird backend ! .
Sure. There's no one for now and am not having enough resources to maintain it. But I will accept pull request for that. If you go through issues in github you can see there is a promise from a contributor to add and maintain it. May be you need to comment there to encourage him to go ahead and do it
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 15.04/Windows 10 Pro - GCC/MinGW, CodeLite IDE et al]

airc
Knows some wx things
Knows some wx things
Posts: 25
Joined: Mon Jan 06, 2014 7:35 am

Re: wxDatabase Library

Post by airc » Tue Jan 12, 2016 8:17 am

the guy who said that he will add firebird he mentioned that he will use ibpp , i think is heavy , instead ..
databaselayer already has firebird backend ,( i never used it ) , why not grabing fb backend from databaselayaer and add it to wxDataBase .
its is just my opinion , i am not using wxwidget for database , i am using other development tools for that task .

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

Re: wxDatabase Library

Post by evstevemd » Tue Jan 12, 2016 2:24 pm

airc wrote:the guy who said that he will add firebird he mentioned that he will use ibpp , i think is heavy , instead ..
databaselayer already has firebird backend ,( i never used it ) , why not grabing fb backend from databaselayaer and add it to wxDataBase .
its is just my opinion , i am not using wxwidget for database , i am using other development tools for that task .
I will appreciate a maintainer. As i said I don't have resources to maintain it so if you can take the task, I have no problem at all.
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 15.04/Windows 10 Pro - GCC/MinGW, CodeLite IDE et al]

iwbnwif
Super wx Problem Solver
Super wx Problem Solver
Posts: 265
Joined: Tue Mar 19, 2013 8:52 pm

Re: wxDatabase Library

Post by iwbnwif » Tue Jan 12, 2016 10:33 pm

the guy who said that he will add firebird he mentioned that he will use ibpp , i think is heavy , instead ..
databaselayer already has firebird backend ,( i never used it ) , why not grabing fb backend from databaselayaer and add it to wxDataBase .
its is just my opinion , i am not using wxwidget for database , i am using other development tools for that task .
Hi, it was me who talked about adding a Firebird backend using IBPP.

The reason I suggested using IBPP is because the way wxDatabase exposes the database to the 'user' and the way IBPP works is somewhat similar.

I think IBPP is used in Flamerobin (i.e. quite heavily tested and stable), but I am not sure that the wxDatabaseLayer Firebird backend has had the same use.

Also, as you probably know the Firebird C-language API is not particularly friendly, so using IBPP removes some of the pain :D

Anyway, it was just a suggestion and so far I haven't really had chance to follow it through.
wxWidgets 3.10, TDM MinGW64 5.1.0, g++ 4.8.2, Ubuntu 16.04LTS, Windows 10, CodeLite + wxCrafter
Some people, when confronted with a GUI problem, think "I know, I'll use Eclipse RCP". Now they have two problems.

Post Reply