Yunqa • The Delphi Inspiration

Delphi Components and Applications

User Tools

Site Tools


products:sqlite3:index
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


products:sqlite3:index [2023/08/26 16:48] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== DISQLite3 ======
  
 +{{page>header}}
 +
 +===== Overview =====
 +
 +  * ACID transactions, even after system crashes and power failures.
 +  * Zero-configuration -- no setup or administration needed.
 +  * Implements most of SQL-92.
 +  * A complete database is stored in a single disk file.
 +  * Supports terabyte-sized databases and gigabyte-sized strings and blobs. Self-contained: no external dependencies, no DLLs.
 +  * Small footprint and smart linking: Only required code is compiled in, adding as little as 300 KB code space only.
 +  * Full Text Search (FTS) with customizable tokenizer, prefix matching, and [[..:stemmer:|optional word stemming]] for 30 languages.
 +  * Database AES encryption with SHA256 key generator.
 +  * ''Db.pas'' is not required, which allows DISQLite3 to compile with all flavours of Delphi, including Delphi Standard and Delphi Personal.
 +  * Faster than popular database engines for most common operations.
 +  * Simple, easy to use API.
 +  * Database files created with DISQLite3 can also be accessed by Linux and MacOS using the SQLite3 libraries.
 +
 +===== SQL-92 Support =====
 +
 +{{ disqlite3_drive_catalog_demo.png?250|DISQLite3 Drive Catalog Demo Application}}DISQLite3 understands most of the SQL-92 language standard:
 +
 +  * ALTER TABLE
 +  * ANALYZE
 +  * ATTACH DATABASE
 +  * BEGIN TRANSACTION
 +  * Comments
 +  * COMMIT TRANSACTION
 +  * CREATE INDEX
 +  * CREATE TABLE
 +  * CREATE TRIGGER
 +  * CREATE VIEW
 +  * DELETE
 +  * DETACH DATABASE
 +  * DROP INDEX
 +  * {{ disqlite3_math_expr_eval_demo.png?250|DISQLite3 Mathematical Expression Evaluator Demo Application}}DROP TABLE
 +  * DROP TRIGGER
 +  * DROP VIEW
 +  * END TRANSACTION
 +  * EXPLAIN
 +  * Expressions
 +  * INSERT
 +  * ON CONFLICT clause
 +  * PRAGMA
 +  * REINDEX
 +  * REPLACE
 +  * ROLLBACK TRANSACTION
 +  * SELECT
 +  * UPDATE
 +  * VACUUM
 +
 +The complete SQL syntax is described in full length in the DISQLite3 HTML Help, part of the installation package.
 +
 +===== Simple Programming Interface =====
 +
 +{{ disqlite3_database_encryption_demo.png?250|DISQLite3 Database Encryption Demo Application}}DISQLite3 provides a comprehensive list of functions and procedures to manage database records with ease and efficiency. It includes the full SQLite3 functionality, plus a number of Delphi specific extras:
 +
 +  * AnsiString, UnicodeString / WideString, and Variant support.
 +  * Database and Statement wrapper classes.
 +  * TDataSet support.
 +  * TStream support for BLOBs.
 +  * Growing number of Delphi example projects.
 +
 +Despite of its rich set of features, a DISQLite3 database application can be realized with just three different function calls.
 +
 +===== Pro and Personal Editions =====
 +
 +DISQLite3 comes in two editions: DISQLite3 Personal and DISQLite3 Pro.
 +
 +**DISQLite3 Personal** is free for personal, educational, and non-commercial use. It omits some functionality of DISQLite3 Pro, but does not compromize on essential features like ACID transactions, virtually unlimited database size, full text search, and others.
 +
 +**DISQLite3 Pro** is required for commercial use and may be purchased online. It adds functionality usually desired by advanced users. This includes SQL triggers and views, arbitrary encryption passwords, user-defined SQL functions, and more. Since DISQLite3 Pro is fully compatible to the Personal edition, it is possible to upgrade existing projects without any code changes.
 +
 +The [[feature_chart|feature chart]] is available for a side-by-side comparison of the two editions.
 +
 +{{tag>database sqlite sqlite3 unicode}}
products/sqlite3/index.txt · Last modified: 2023/08/26 16:48 by 127.0.0.1