I really love sqlite3 databases. They are small, scalable and just do the job. The only thing they need is a file, so they are also much easier to configure, maintain and backup than heavy database solutions like MariaDB, MySQL or PostgreSQL. For bigger class applications they do a very good job, for most of my personal projects I prefer sqlite3, because they are just slim and easy-to-use.
Due to my affinity to Python I wrote a small C++ Wrapper Class, that should make it easier to handle Sqlite3 database connections in C++. In just 200 lines C++ code. It's really easy, no Voodoo involved.
But have a look yourself at this 13 lines C++ code, that create a table, insert values and read them out.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQLite3 db(":memory:"); db.execute("CREATE TABLE IF NOT EXISTS `test` (`id` INT PRIMARY KEY, `value` REAL);"); SQLite3Cursor cursor = db.cursor(); for(int i=0;i<;10;i++) { cursor.execute("INSERT OR REPLACE INTO `test` (`id`,`value`) VALUES (?, ?);"); cursor.bind(1, i); cursor.bind(2, i*i); cursor.next(); } cursor.execute("SELECT `id`,`value` FROM `test`"); while(cursor.next()) { cout << cursor.fetchInt(0) << " = " << cursor.fetchFloat(1) << endl; } |
Tested under Ubuntu 16.04 and Arch Linux. I suppose it also runs on other platforms, but I've not tested it. Use at own risk 😉
