Category "SQLite"

on in SQLite

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. Unlike client–server database management systems, installing and running of SQLite database is pretty straightforward in most cases — just make......

[ Click to Continue ]
on in C++ SQLite

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 different story to you. In this tutorial, I’m going to show you how we can achieve that in using of......

[ Click to Continue ]
on in C++ SQLite

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 your C++ code by modifying my previous C++ Sqlite example. My previous C++ Sqlite tutorials can be found at the......

[ Click to Continue ]
on in C++ G++ Linux SQLite Ubuntu

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++ & SQLite in Ubuntu, it is advisable that you read the following article so that you have better understanding what......

[ Click to Continue ]
on in C++ SQLite

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 ]
on in C++ SQLite

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 ]