WxWidgets 3.1, Windows, codeblocks and MySQL Topic is solved
-
- Experienced Solver
- Posts: 71
- Joined: Sat Jul 27, 2019 3:45 pm
WxWidgets 3.1, Windows, codeblocks and MySQL
Hi to all,
I'm having lot of problems in finding a way to connect to a MySQl database by using WxWdigets on Windows.
On Linux, I use mysql++ library and everything works fine, but I can't figure out how to do it under Windows.
I don't need to use exactly the same library, I just need to be able to run queries like SELECT and INSERT in order to manipulate data.
I already installed phpmyadmin, MySQL under Windows and they work fine.
I've found some posts in this forum about Wxsqlite3 and wxdatabase, but they are all too old compared to my version and they doesn't work.
I'm having lot of problems in finding a way to connect to a MySQl database by using WxWdigets on Windows.
On Linux, I use mysql++ library and everything works fine, but I can't figure out how to do it under Windows.
I don't need to use exactly the same library, I just need to be able to run queries like SELECT and INSERT in order to manipulate data.
I already installed phpmyadmin, MySQL under Windows and they work fine.
I've found some posts in this forum about Wxsqlite3 and wxdatabase, but they are all too old compared to my version and they doesn't work.
-
- Experienced Solver
- Posts: 71
- Joined: Sat Jul 27, 2019 3:45 pm
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
I'm still looking on google, but it's very hard to find a good document/tutorial.
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
Do you need to connect to an existing MySQL DB or do you just need any SQL database embedded in your application? In the latter case wxSQLite3 is probably the best option. It doesn't use MySQL though.
Otherwise, check wxDatabase. https://github.com/mtangoo/wxDatabase
Its last commit is from November 2019, so i'd expect it to run with the latest wxWidgets version.
Otherwise, check wxDatabase. https://github.com/mtangoo/wxDatabase
Its last commit is from November 2019, so i'd expect it to run with the latest wxWidgets version.
Use the source, Luke!
-
- Experienced Solver
- Posts: 71
- Joined: Sat Jul 27, 2019 3:45 pm
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
I'm creating the database from scratch so I can choose the architecture. I usually use Mysql with phpmyadmin but it's ok to use any other solution.
I checked wxSQLite3 but I wasnt able to use it correctly.
Is there any tutorial that can explain me how to install and use the wxdatabase?
I checked wxSQLite3 but I wasnt able to use it correctly.
Is there any tutorial that can explain me how to install and use the wxdatabase?
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
In that case i highly recommend wxSQLite3. It's well documented and its author (utelle) is regularly here on this forum.I'm creating the database from scratch so I can choose the architecture. I usually use Mysql with phpmyadmin but it's ok to use any other solution.
https://github.com/utelle/wxsqlite3
Sorry, i've never used it myself.Is there any tutorial that can explain me how to install and use the wxdatabase?
Use the source, Luke!
-
- Experienced Solver
- Posts: 71
- Joined: Sat Jul 27, 2019 3:45 pm
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
I will try to check again wxsqlite3 and how to install it on windows. I see that it uses databases in .db format: I never used it so I do not know how to populate the tables, is there an utility like phpmyadmin to manage the database?
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
https://sqlitebrowser.org/marcusbarnet wrote: ↑Sun Feb 16, 2020 9:59 pm I will try to check again wxsqlite3 and how to install it on windows. I see that it uses databases in .db format: I never used it so I do not know how to populate the tables, is there an utility like phpmyadmin to manage the database?
Use the source, Luke!
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
Which database architecture should be chosen heavily depends on the needs of your application. If a central database is required for all users of your application, choose a client-server database like MySQL. If an embedded database is all what your application needs, choose SQLite3 (and optionally wxSQLite3 for accessing it from your wxWidgets application).marcusbarnet wrote: ↑Sun Feb 16, 2020 9:59 pm I'm creating the database from scratch so I can choose the architecture. I usually use Mysql with phpmyadmin but it's ok to use any other solution.
If you have difficulties in using wxSQLite3, then ask here on the forum or on GitHub.marcusbarnet wrote: ↑Sun Feb 16, 2020 9:59 pm I checked wxSQLite3 but I wasnt able to use it correctly.
wxSQLite3 provides build files for VC++ and gcc/Mingw64 under Windows.marcusbarnet wrote: ↑Sun Feb 16, 2020 9:59 pm I will try to check again wxsqlite3 and how to install it on windows.
SQLite databases usually consist of a single database file, which can be named with any file extension. That is, .db does not mean dBase file format. wxSQLite3 provides a precompiled SQLite3 command line shell. If you prefer a GUI tool for database administration, use SQliteBrowser or SQLite Studio.marcusbarnet wrote: ↑Sun Feb 16, 2020 9:59 pm I see that it uses databases in .db format: I never used it so I do not know how to populate the tables, is there an utility like phpmyadmin to manage the database?
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
https://youtu.be/3v_lA1Gg1Q4marcusbarnet wrote: ↑Sun Feb 16, 2020 7:26 pm Hi to all,
I'm having lot of problems in finding a way to connect to a MySQl database by using WxWdigets on Windows.
On Linux, I use mysql++ library and everything works fine, but I can't figure out how to do it under Windows.
I don't need to use exactly the same library, I just need to be able to run queries like SELECT and INSERT in order to manipulate data.
I already installed phpmyadmin, MySQL under Windows and they work fine.
I've found some posts in this forum about Wxsqlite3 and wxdatabase, but they are all too old compared to my version and they doesn't work.
https://youtu.be/siQCWPxDtMo
-
- Experienced Solver
- Posts: 71
- Joined: Sat Jul 27, 2019 3:45 pm
Re: WxWidgets 3.1, Windows, codeblocks and MySQL
Very useful!
Honestly, I was going to use SQLite3 even if I didn't like to have an embedded database, but the MySQL integration on Windows seemed to hard for me.
Thanks to that Youtube video, I was able to successfully integrate it in my code, so now I'm using it without problems!
Honestly, I was going to use SQLite3 even if I didn't like to have an embedded database, but the MySQL integration on Windows seemed to hard for me.
Thanks to that Youtube video, I was able to successfully integrate it in my code, so now I'm using it without problems!