Projects and Stuff

Software And Hardware For All

Lazarus SQLite3 Database Encryption and Pragma Demonstration

I put together a very simple demonstration for creating a SQLite3 Database and using a few of its features.

This application very simply demonstrates the following capabilities:
- Creation of a SQLite3 Database
- Encrypting the database using a key
- Changing (or setting if not initially set) the encryption key for the database after it has been created
- Creation of a database table
- Creating an Index
- Adding a row of data to the table
- Performing a very basic query
- Setting and reading various database metadata (Pragma)

The code is below and is heavily commented with notes and resources, and I've attached the demo as well. Please be sure to read the Readme.txt file for plenty of useful information.

Read more: Lazarus SQLite3 Database Encryption and Pragma Demonstration

Login Form