Local DB Topic is solved

In this forum you can discuss database related issues which can be wxWidgets related, but also generic in nature.
Post Reply
wxProgrammer
Experienced Solver
Experienced Solver
Posts: 96
Joined: Thu Apr 17, 2014 10:10 am

Local DB

Post by wxProgrammer » Thu Apr 17, 2014 10:52 am

Hello! I'm searching a library for create a local database (simple folder and file). the library must be wx-compatible. If the library don't use mysql or similar but simple functions like "getRow("row", "table", "db") is better for me.
What library can I use? (the data of rows are simple wxString).

i'm Italian so sorry for My English :)

thank you!

utelle
Moderator
Moderator
Posts: 880
Joined: Tue Jul 05, 2005 10:00 pm
Location: Cologne, Germany
Contact:

Re: Local DB

Post by utelle » Thu Apr 17, 2014 11:55 am

wxProgrammer wrote:I'm searching a library for create a local database (simple folder and file).
For a local database SQLite is a popular choice. SQLite has a full blown SQL database engine, so you are not restricted in any way.
wxProgrammer wrote:the library must be wx-compatible.
SQLite itself is a pure C library. However, you can use wxSQLite3, providing a thin SQLite wrapper for use in wxWidgets based applications.
wxProgrammer wrote:If the library don't use mysql or similar but simple functions like "getRow("row", "table", "db") is better for me.
What library can I use? (the data of rows are simple wxString).
wxSQLite3 comes with a small sample application showing how to access a database. It should be fairly easy to use, if you inspect the code of the sample application and look at the wxSQLite3 API documentation.

Regards,

Ulrich

wxProgrammer
Experienced Solver
Experienced Solver
Posts: 96
Joined: Thu Apr 17, 2014 10:10 am

Re: Local DB

Post by wxProgrammer » Thu Apr 17, 2014 1:03 pm

I have used SQL with PHP, anyhow it will not be difficult to use it :) thank you, I'll use it :)
I'm Italian but we can speak C++ :)

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: Local DB

Post by evstevemd » Fri Apr 18, 2014 4:32 pm

wxProgrammer wrote:Hello! I'm searching a library for create a local database (simple folder and file). the library must be wx-compatible. If the library don't use mysql or similar but simple functions like "getRow("row", "table", "db") is better for me.
What library can I use? (the data of rows are simple wxString).

i'm Italian so sorry for My English :)

thank you!
wxSQlite3 is what you need!
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