I started a project to build and manipulate a SQLite database with C++. Right now, it generates a SQLite file and then it creates a table called "HWMessages" where each row contains a primary integer key and the string message "Hello World." This script uses the SQLite3 library and the C Style API. It uses the UTF-8 functions and it also uses the sqlite3_exec()
wrapper to execute queries. Currently, the main script just selects all of these "Hello World" messages and writes them to a text file called output_file.txt
.
Below are two screenshots that show the output database:
- Modularize with OOP
- Build more tables and structure
- Run more complex queries
- Load raw input data