Thread: C++ and SQL

Hey,

I was curious if there was a way to use SQL in C++. I'm trying to make a program, but using the windows registry is just a pain to manage things. I was curious if there was a way to download some sql source and use that.

For example

Code:

#include <iostream>
#include "sql-essential.h"

using namespace std;

int main ( void )
{
     SQLDB sdb; //the db (which would be defined in sql-essential, if something like this exists
     sdb.sqlFile ( "sqldata.sql" ); //connects to a file (this program doesn't need to run a SQL server)
     int result = sdb.query("SELECT * FROM `table` WHERE a='value'" ); //does query
     cout << result << endl; //shows result
     return 0;
}

Is there any sort of code like this out there? I know Call of Duty 4 uses some sort of database without having to worry about connecting to a server (I think).

If there is any way of doing SQL in C++ without having to have MySQL running as a service or process in the background I'd be very appreciative.

Thanks in advance,

Guitarist809

If you are only looking to store configuration settings then embedding cyberfish's suggestion of SQLite would be good.

SQLite is C, though, so you cannot work with it as in your example. However, there are C++ wrappers around it, I believe, that should make you happy.

Awesome.

SQLite looks like it'll work. I found it pretty funny when I was looking at the source - I think the code has more comments than actual code.

Thanks for the help guys. Much appreciated.

I'm sorry for posting again, but I'm having a ton of trouble finding a C++ wrapper. They either need BOOST or they only work with MFC. This has been giving me a headache all day.

Does anyone know of a good C++ wrapper for SQLite that does not need BOOST or MFC?

Thanks,

Guitarist809

I've spent hours trying to get it to work. No matter what I do, Visual Studio 2008 keeps giving me linker errors (I followed the BOOST tutorials, doing exactly what they told me to do). I gave up

Did you check out the SQLite wiki on wrappers?

That said, I never did find one that I liked, so I ended up writing my own wrapper that mainly provided RAII. Unfortunately, I kind of abandoned it as an open source project to be released because I could not figure out how to provide a good interface to define user defined SQL functions.

Still, I'd say that it is quite easy to write your own wrapper if RAII is mainly want you want. It is even easier now that new functions were introduced to the SQLite C interface.

Man, I'm about to give up on this.

I've tried almost every one of the C++ wrappers offered, half of them don't work off the bat (even onces with examples, missing include files or other stuff), and if I'm lucky enough to get one working (which I did), it doesn't work in MFC.

This is a total nightmare. Never in my wildest dreams would I have ever figured that getting SQLite to work with C++/MFC would be this hard.

This is probably more of a windows question, but I keep getting .def/.lib/.dll files with some examples, I'm having difficulty figuring out what do do with these files. Google isn't being much help for this sort of stuff.

Has anybody actually had any success with SQLite and C++ and unicode?

Thanks,

Guitarist809

The .lib files ship with dll files which are libraries. Include the .lib files dependencies as tabstop mentions. Include the header file you ought to be getting and then you can use the functions/classes/stuff from the header file (the code is in the dll file).

Thank you so much. (+1 if I could)

I can't believe how simple it was to get this working. I thought for sure I was doomed

Thanks again for the help.