next »

[aldo]

I have lately been interested in integrating SQLite with something like C++

Now first I was wondering, is this even possible? If so, does anyone have a tutorial they know of that shows you how you do it?

Another thing, I have also been messing with the command-line program for accessing and modifing SQLite databases, however, I don't get how I make a new database and everything.

I look at the Docs for it (http://sqlite.org/sqlite.html) but I type sqlite3 ex1; into the command-line, and I get SQL Error: near "sqlite3", and I don't see anywhere else to type that to make a new database =|

[inp o҉rtb]

Absolutely; just link your program against SQLite? http://www.sqlite.org/capi3.html

I've never tried the "official" C++ interface, but when I worked with SQLite/C++, I had to wrap the C interface into my own C++ classes (there was no C++ wrapper at the time, and it looks like there's no C++ interface now as well). Then again, there's nothing wrong with just using the C functions straight in C++.

[aldo]

How do I link it? The thing is, these things never make sense. When I make tutorials, I just say how you do it, and show an example code, lol...

[inp o҉rtb]

Well... the GCC/G++ process is pretty straightforward. First it compiles C/C++ to assembly language, then it assembles the assembly source into object code, and finally it links object code into executables or libraries. Basically, when you link, tell the linker to add the SQLite library. (of course, you also have to #include the SQLite headers during compilation).

If you run GCC/C++ in a single command, I believe you specify libraries that you want to link against using the -L parameter, and include files using the -I parameter.

[aldo]

The SQLite Library is the dll right?

[inp o҉rtb]

Oh, then that's a bit different, if you're using a shared library instead of a static library.

Actually, the shared library should still come with a tiny static library stub, which you link your application against. The stub is basically a redirector that calls functions in the shared library. Of course, you don't have to use the static stub, but then you'd have to dig into the Win32 API for LoadLibrary() and so on.

(While I've done that before, you really should not be asking me for details on the Win32 API. Check the MSDN for more information ;p )

[aldo]

Ok, *goes to Google*

[inp o҉rtb]

btw, have you checked out gamedev.net? It's an awesome community of developers and you might find some SQLite-integration tutorials there (I think I learned about the SQLite/C interface there).

http://www.gamedev.net/reference/

[Primefalcon]

yes gamedev is great a great resource