products:sqlite3:index
Delphi 12 Athens Updates Available!
To download, click your product: DIContainers, DIConverters, DICreole, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIHtmlParser, DIMime, DIRegEx, DISQLite3, DITidy, DIUcl, DIUnicode, DIXml, YuBrotli, YuImage, YuNetSurf, YuOpenSSL, YuPcre2, YuPdf, YuStemmer, YuXmlSec, YuZip.
To download, click your product: DIContainers, DIConverters, DICreole, DIFileFinder, DIGoogleReader, DIHtmlLabel, DIHtmlParser, DIMime, DIRegEx, DISQLite3, DITidy, DIUcl, DIUnicode, DIXml, YuBrotli, YuImage, YuNetSurf, YuOpenSSL, YuPcre2, YuPdf, YuStemmer, YuXmlSec, YuZip.
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> | ||
+ | |||
+ | ===== Overview ===== | ||
+ | |||
+ | * ACID transactions, | ||
+ | * 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: | ||
+ | * 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 [[..: | ||
+ | * Database AES encryption with SHA256 key generator. | ||
+ | * '' | ||
+ | * 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? | ||
+ | |||
+ | * 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? | ||
+ | * 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? | ||
+ | |||
+ | * 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, | ||
+ | |||
+ | **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> |
products/sqlite3/index.txt · Last modified: 2023/08/26 16:48 by 127.0.0.1