SQLite as data store in C++

General game programming discussions about theory and applications.

SQLite as data store in C++

Postby FyreWolfe » Thu Jul 22, 2010 12:48 pm

There are various advantages in a using a SQLite as a database with the best being that it’s small, fast and reliable.

The best way to use SQLite is to embed it in the game using the recommended amalgamation source code available on sqlite.org, but it is also available as a library for Windows (DLL) or Linux (shared-library .so ) .

From a licensing point of view, using SQLite in any commercial game is also VERY safe since SQLite’s source has been released into the public domain.

The following steps should allow C++ programmers to embed SQLite into their games.


>>> Read more here <<<
http://fyrewolfe.sagamedev.com
User avatar
FyreWolfe
 
Posts: 333
Joined: Fri Apr 23, 2004 4:35 pm
Location: The Great Thirstland

Re: SQLite as data store in C++

Postby Nitrogen » Thu Jul 22, 2010 9:58 pm

Hehe, nice blog Wolfe!

I like it!
I heard that Oblivion is actually vulnerable to SQL injection (little Bobby Tables anyone?)... The game uses SQLlite and savegames are part sql queries... Put the wrong characters into your name and blam! :D
User avatar
Nitrogen
 
Posts: 2054
Joined: Fri Feb 01, 2002 1:34 pm

Re: SQLite as data store in C++

Postby xyber » Fri Jul 23, 2010 10:22 am

Been using sqlite to save data in apps and games for a while now, when working on PC format.
It is just so easy to do that it is normally the first "save file solution" I think of using.
The more time you spend playing video games, the longer it will take to make one.
User avatar
xyber
 
Posts: 1073
Joined: Mon Feb 04, 2002 11:25 am
Location: Gauteng, South Africa

Re: SQLite as data store in C++

Postby FyreWolfe » Fri Jul 23, 2010 10:39 am

Nitrogen wrote:I heard that Oblivion is actually vulnerable to SQL injection (little Bobby Tables anyone?)... The game uses SQLlite and savegames are part sql queries... Put the wrong characters into your name and blam! :D

LOL yep. Very important point that.

There is actually a website on how to prevent sql injection called .... Bobby Tables :lol:
http://fyrewolfe.sagamedev.com
User avatar
FyreWolfe
 
Posts: 333
Joined: Fri Apr 23, 2004 4:35 pm
Location: The Great Thirstland


Return to Programming

Who is online

Users browsing this forum: No registered users and 2 guests