Getting started with SQLite and C++?

Question

For an online game I'm making, I need to be able to add users and their stats to a database, an example table:

Username, Password, Email, Wins, Loses

The username will be the unique key, and from there I need to retrieve the other information.

I also need to do other things such as find all the usernames with a given e-mail.

I have been searching for a few hours for an SQLite tutorial that shows C or C++ on how to do these sorts of simple tasks.

Could anyone recommend a tutorial like this or possibly some insight on performing some of the above tasks with the SQLite library?

Thanks

For an online game you most likely have a high load once it becomes successful. So you might want to look into a "proper" database server. At least you should think about an architecture where you can switch the data layer out. SQLite can be problematic with many concurrent writes ... — johannes
– johannes, Commented Sep 28, 2011 at 0:25
I assume by "password" you mean "securely hashed password". Because you wouldn't want to transmit someone's password in clear-text, right? — Nicol Bolas
– Nicol Bolas, Commented Sep 28, 2011 at 0:26
Also, I'm personally against these sorts of task-oriented tutorials that encourage someone to copy&paste a solution into their codebase without having any understanding of how SQLite works. Maintaining such a database is simple if you understand how SQL works, so focus on using the material that's out there to understand SQL. From there, what you have to do is pretty obvious. — Nicol Bolas
– Nicol Bolas, Commented Sep 28, 2011 at 0:28

orlp · Accepted Answer · 2011-09-28 00:20:40Z

6

The SQLite documentation is quite good:

answered Sep 28, 2011 at 0:20

orlp

119k39 gold badges226 silver badges324 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1