1. Introduction SQLite is an open source, embedded relational database which implements a self-contained, serverless, zero-configuration,transactional SQL database engine. SQLite has a well-deserved reputation for being highly portable, easy to use, compact, efficient, and reliable....
Read More
You might know the benefits of using parameterized query (e.g boost query performance in term of speed, avoid SQL injection attack, etc) but how it can be done in programming way might sound like a...
Read More
Wonder how you can implement an automic transaction in SQLite so that your queries will either completely occurs, or completely fails to occur? In this tutorial, i will demonstrate how you can do that in...
Read More
This example will demonstrate how you can write a C++ program to utilize SQLite as your program database file in Linux environment. I am using Ubuntu in this demonstration. If you are new to C++...
Read More
Installing SQLite in Ubuntu is pretty simple and all you have to do is using the following command to download and install the package....
[ Click to Continue ]
This example will demonstrate how you could use the C/C++ interface to execute SQL statement in SQLite. If you are new to C/C++ & SQLite, it is advisable that you read my previous article on Establish a connection to SQLite database using C++, so that you have a better understanding what how and what to......
[ Click to Continue ]
The following steps will guide you through how you can connect to SQLite databases using C++. 1. Download and extract the following files into a single folder C:\SQLite. SQLite Source Code: sqlite-amalgamation-3071100.zip SQLite DLL for Windows: sqlite-dll-win32-x86-3071100.zip SQLite Shell for Windows: sqlite-shell-win32-x86-3071100.zip 2. Let’s create a SQLite database named “test.db” with a single table named......
[ Click to Continue ]
Installing SQLite in Ubuntu