which database to a program ? Topic is solved
which database to a program ?
Hi
I would like to do a program which contains a database but I don't wan't the user to need to install a supplementary program. In fact, the database must be integrated in the program.
I think wxsqlite is the good system, am I right ?
thx
I would like to do a program which contains a database but I don't wan't the user to need to install a supplementary program. In fact, the database must be integrated in the program.
I think wxsqlite is the good system, am I right ?
thx
Last edited by arno03 on Mon Aug 22, 2005 6:14 pm, edited 1 time in total.
also FireBird.
Nothing to install as "embeded" (at least in FB1.5), multi-platform native support, and good performances.
http://firebird.sourceforge.net/
Nothing to install as "embeded" (at least in FB1.5), multi-platform native support, and good performances.
http://firebird.sourceforge.net/
-
- Earned some good credits
- Posts: 109
- Joined: Fri Sep 03, 2004 9:30 am
- Location: Brescia, Italy
Re: which database to a program ?
SQLite is simply excellent for embedding:arno03 wrote:Hi
I would like to do a programme which contains a database but I don't wan't the user to need to install a supplementary program. In fact, the database must be integrated in the program.
I think wxsqlite is the good system, am I right ?
thx
* small
* fast
* enough features for most applications
Sandro Sigala - Kynosoft, Brescia
Hi!
Starting with version 3 SQLite can handle BLOBs and triggers. In fact most SQL features are covered now. You will have to use wxSQLite3 in order to use these features (http://wxcode.sourceforge.net/components/wxsqlite3/). Another option is this wrapper http://www.codeproject.com/database/CppSQLite.asp.
Starting with version 3 SQLite can handle BLOBs and triggers. In fact most SQL features are covered now. You will have to use wxSQLite3 in order to use these features (http://wxcode.sourceforge.net/components/wxsqlite3/). Another option is this wrapper http://www.codeproject.com/database/CppSQLite.asp.
OS: OpenSuSE, Ubuntu, Win XP Pro
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
thx all
I download wxsqlite3 on http://wxcode.sourceforge.net/components/wxsqlite3,
and I did somes transfers:
-----------------------------------------------------------------------------------
wxsqlite3/include/sqlite3.h -> C:/DevCpp/include/
wxsqlite3/include/lib/sqlite3.dll -> C:/DevCpp/lib/
wxsqlite3/include/lib/sqlite3.exp -> C:/DevCpp/lib/
wxsqlite3/include/lib/sqlite3.lib -> C:/DevCpp/lib/
wxsqlite3/include/wx/wxsqlite3.h -> C:/DevCpp/include/wx/
wxsqlite3/include/wx/wxsqlite3def.h -> C:/DevCpp/include/wx/
------------------------------------------------------------------------------------
After I try to compil minimal.cpp but i receive somes errors :
http://lmdf.free.fr/log.txt
why plz ?
I download wxsqlite3 on http://wxcode.sourceforge.net/components/wxsqlite3,
and I did somes transfers:
-----------------------------------------------------------------------------------
wxsqlite3/include/sqlite3.h -> C:/DevCpp/include/
wxsqlite3/include/lib/sqlite3.dll -> C:/DevCpp/lib/
wxsqlite3/include/lib/sqlite3.exp -> C:/DevCpp/lib/
wxsqlite3/include/lib/sqlite3.lib -> C:/DevCpp/lib/
wxsqlite3/include/wx/wxsqlite3.h -> C:/DevCpp/include/wx/
wxsqlite3/include/wx/wxsqlite3def.h -> C:/DevCpp/include/wx/
------------------------------------------------------------------------------------
After I try to compil minimal.cpp but i receive somes errors :
http://lmdf.free.fr/log.txt
why plz ?
ArNo
You will have to compile wxSqlite3 as a static lib itself. Set up a static lib project and compile the file in /src. Then link the minimal app with the lib and sqlite3.lib. Works perfectly here.
OS: OpenSuSE, Ubuntu, Win XP Pro
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
i follow your instructions and now, i received:
minimal.cpp: In function `int main(int, char**)':
minimal.cpp:238: warning: comparison between signed and unsigned integer expressions
minimal.cpp:258: warning: comparison between signed and unsigned integer expressions
minimal.cpp:298: error: `e' undeclared (first use this function)
minimal.cpp:298: error: (Each undeclared identifier is reported only once for each function it appears in.)
minimal.cpp: In function `int main(int, char**)':
minimal.cpp:238: warning: comparison between signed and unsigned integer expressions
minimal.cpp:258: warning: comparison between signed and unsigned integer expressions
minimal.cpp:298: error: `e' undeclared (first use this function)
minimal.cpp:298: error: (Each undeclared identifier is reported only once for each function it appears in.)
ArNo
-
- Earned some good credits
- Posts: 109
- Joined: Fri Sep 03, 2004 9:30 am
- Location: Brescia, Italy
arno03 wrote: After I try to compil minimal.cpp but i receive somes errors :
http://lmdf.free.fr/log.txt
Code: Select all
... -lwsock32 -lodbc32 -lopengl32 -sqlite3.lib ...
^
| typo here
Sandro Sigala - Kynosoft, Brescia
-lwsock32 -lodbc32 -lopengl32 -sqlite3.lib
should read
-lwsock32 -lodbc32 -lopengl32 -lsqlite3
You added the lib path to your project settings, right?
Just ignore the warnings, they won't do harm...
The error might be comming from the exeption handling. Did you compile the lib and the app to support execptions?? If not -> delete the whole try{}catch() block. Note that don't recommend this, as exceptions are usefull.
should read
-lwsock32 -lodbc32 -lopengl32 -lsqlite3
You added the lib path to your project settings, right?
Just ignore the warnings, they won't do harm...
The error might be comming from the exeption handling. Did you compile the lib and the app to support execptions?? If not -> delete the whole try{}catch() block. Note that don't recommend this, as exceptions are usefull.
OS: OpenSuSE, Ubuntu, Win XP Pro
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
wx: svn
Compiler: gcc 4.5.1, VC 2008, eVC 4
"If it was hard to write it should be hard to read..." - the unknown coder
"Try not! Do. Or do not. There is no try." - Yoda
-
- Earned some good credits
- Posts: 109
- Joined: Fri Sep 03, 2004 9:30 am
- Location: Brescia, Italy
If you want to link against a certain lib called "libfoo.a", you should specify "-lfoo" as parameter.
In your screenshot, you specify "-Projet1" witch is wrong.
First of all, rename the library from "Projet1.a" to "libProjet1.a"
Then specify "-lProjet1" instead of "-Projet1".
In your screenshot, you specify "-Projet1" witch is wrong.
First of all, rename the library from "Projet1.a" to "libProjet1.a"
Then specify "-lProjet1" instead of "-Projet1".
Sandro Sigala - Kynosoft, Brescia