DISQLite3 Pro 5.22.0 D4-XE10.2
DISQLite3 Pro 5.22.0 D4-XE10.2: A powerful and fast SQLite library for Delphi
SQLite is a compact and simple database that is easy to configure and use for both programmers and program users. Because of the importance of this database, its engines have been developed for many languages, and DISQLite3 is a successful implementation of this database in Delphi.
DISQLite3 Pro 5.22.0 D4-XE10.2
DISQLite3 Pro 5.22.0 D4-XE10.2 is the latest version of this library, which supports Delphi 4 to Delphi 10.2 Tokyo. This library is completely and independently developed for Delphi and can be used in various Embarcadero / CodeGear / Borland environments.
One of the advantages of this database is that program users, unlike heavy databases such as SQL Server, do not need complicated steps to install and set up the database and connect to the program. The database is stored in a single portable file, without the need for servers and software prerequisites.
DISQLite3 Pro 5.22.0 D4-XE10.2 offers many features and benefits for Delphi developers, such as:
ACID transactions even after the system crashes
No need to configure, no need for an admin account
Almost complete implementation of SQL-92
Support for large terabytes of databases and gigabytes of strings as well as blobs
No dependence on foreign libraries
The small size of the library adds about 300 KB to the final code
Full text search (FTS) with the ability to customize tokens for 15 different languages
Ability to encrypt AES with SHA256 keys
No need for Db.pas to be compatible with all Delphi versions, both standard and personal
High speed in performing data retrieval operations compared to other databases
Simple, tidy and documented API
Ability to access DISQLite3 databases on Linux, Mac operating systems using SQLite libraries
If you are looking for a reliable, fast and easy-to-use SQLite solution for your Delphi projects, you should definitely try DISQLite3 Pro 5.22.0 D4-XE10.2.
You can download it from here[^1^] or here[^2^].
DISQLite3 Pro 5.22.0 D4-XE10.2 is easy to install and use in your Delphi project. You just need to copy the DISQLite3.dll file to your application folder and add the DISQLite3 unit to your uses clause. Then you can create and manipulate SQLite databases using the TDISQLite3Database and TDISQLite3Statement classes.
For example, you can create a database with a table and insert some data using the following code:
var
DB: TDISQLite3Database;
Stmt: TDISQLite3Statement;
begin
// Create a database object
DB := TDISQLite3Database.Create;
try
// Open or create a database file
DB.Open('test.db');
// Execute a SQL statement
DB.Execute('CREATE TABLE IF NOT EXISTS person (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)');
// Prepare a SQL statement with parameters
Stmt := DB.Prepare('INSERT INTO person (name, age) VALUES (?, ?)');
try
// Bind values to parameters
Stmt.BindText(1, 'Alice');
Stmt.BindInt(2, 25);
// Execute the statement
Stmt.Step;
// Reset the statement for reuse
Stmt.Reset;
// Bind another set of values
Stmt.BindText(1, 'Bob');
Stmt.BindInt(2, 30);
// Execute the statement again
Stmt.Step;
finally
// Free the statement object
Stmt.Free;
end;
finally
// Free the database object
DB.Free;
end;
end;
You can also query data from the database using the TDISQLite3Statement class. For example, you can retrieve all the records from the person table using the following code:
var
DB: TDISQLite3Database;
Stmt: TDISQLite3Statement;
begin
// Create a database object
DB := TDISQLite3Database.Create;
try
// Open an existing database file
DB.Open('test.db');
// Prepare a SQL statement for querying data
Stmt := DB.Prepare('SELECT * FROM person');
try
// Loop through the result set
while Stmt.Step = SQLITE_ROW do
begin
// Get the values of each column
Writeln('ID: ', Stmt.ColumnInt(0));
Writeln('Name: ', Stmt.ColumnText(1));
Writeln('Age: ', Stmt.ColumnInt(2));
Writeln;
end;
finally
// Free the statement object
Stmt.Free;
end;
finally
// Free the database object
DB.Free;
end;
end;
c481cea774