Jump to content
  • Advertisement
  • entries
    205
  • comments
    228
  • views
    113469

SQLite

Sign in to follow this  
Mike Bossy

507 views

In a totally non-game related research project for work today I checked out SQLite. I've done a bunch of DB stuff in the past including some game work so I was checking it out since I heard it was a great lightweight solution that could replace things like ugly MDB files.

All in all I am impressed. Getting it to compile as a static lib was a breeze and I quickly had it integrated into a C++ app opening a DB and doing various queries. Performance seemed good and more importantly it just worked. The only annoying thing is the total lack of any kind of data binding. You really have to do your own data parsing on your queries. This obviously is by design as the whole idea is to get a thin layer on top of a DB so I'm not complaining.

For those who haven't looking into using databases in games they really are great if you're doing anything data driven. Just having a single location for your data that can be easily and quickly accessed is great. Up until now I've hated a lot of the solutions out there like Access just because it feels like so much overhead getting them integrated. SQLite gets rid of that problem. I will definitely be trying it out more in my next project that needs heavy data.
Sign in to follow this  


0 Comments


Recommended Comments

There are no comments to display.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!