Description

SQLite Data Access Components (LiteDAC) is a wide set of components that provides direct access to SQLite from Embarcadero RAD Studio 10.2 Tokyo, RAD Studio 10.3, RAD Studio 2010-10 Seattle, CodeGear RAD Studio 2009/2007, Borland Developer Studio 2006, Turbo Delphi Professional, Turbo Delphi for .NET Professional, Turbo C++ Professional, Borland Delphi 7/6, Borland C++Builder 6, Lazarus 1.8.4 and Free Pascal 2.6.4 for Windows, Mac OS X, iOS, Linux, FreeBSD, for 32-bit and 64-bit platforms.

LiteDAC is a high-performance and feature-rich SQLite connectivity solution that provides both connection to SQLite by means of native SQLite client library and direct access to SQLite by static linking of the SQLite client library into an application. The capability to develop applications using the cutting-edge IDE for all the supported target-platforms: Win32, Win64, Mac OS, iOS, and now - Android. LiteDAC gives its users an opportunity to establish Direct Connection and get the fastest data access to databases.

Key features:

• Android application development support
• iOS development support
• NEXTGEN compiler support
• Mac OS X development support
• Win64 development support
• Interface compatible with standard data access methods, such as BDE and ADO
• SQLite database encryption
• VCL, FMX, LCL development platforms are available
• Concurrent access - User-defined functions
• In Direct mode does not require the SQLite client software and works with a database directly
• Compatible with all IDE versions starting from Delphi 6, C++Builder 6, except Delphi 8, and with Free Pascal
• Includes provider for UniDAC Standard Edition
• Unicode and national charset support
• Support of all standard and third-party visual data-aware controls
• Allows users to use Professional Edition of Delphi and C++Builder to develop client/server applications
• Support for using macros in SQL
• SQL Execution monitoring

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $149.95
• Source price: $399.95
• Size: 3 691kB

Platforms: C2k6, D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8, C10, D10, C10.1, D10.1, C10.2, D10.2, C10.3, D10.3, D6, D7, CB6, FM

Description

An object to query Sqlite3 database and get the result In Xml stream. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The source code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed SQL database engine in the world.

Informations

• Status: Fully functional
• Source: Included
• Size: 51 703kB

Platforms: D2005, D2006, D2007, D2009, D2010, D7, DXE, DXE2, DXE3, DXE4, DXE64

Description

DISQLite3 implements a self-contained, embeddable, zero-configuration SQL database engine.

Features include:

• Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
• Zero-configuration - no setup or administration needed.
• Implements most of SQL92.
• A complete database is stored in a single disk file.
• Supports databases up to 2 terabytes in size.
• No limits to strings and BLOBs sizes except for available memory.
• Self-contained: no external dependencies, no DLLs.
• Small footprint: about 200 KB code space only.
• Full Text Search.
• Database AES encryption with SHA256 key generator.
• Db.pas is Database files created with DISQLite3 can also be accessed by Linux and MacOS using the SQLite3 libraries.

Informations

• Status: Fully functional
• Source: On purchase/registration
• price: $200
• Source price: $400
• Size: 8 627kB

Platforms: CB6, D10, D2005, D2006, D2007, D2009, D2010, D4, D5, D6, D7, DXE, DXE2, DXE3, DXE4, DXE5, DXE6, DXE64, DXE7, DXE8

Description

"This is a small class wrapper for SQLite3. It is structured similar to an ADODB class wrapper that I'm using, so I can easily switch between an embedded database and a client/server database."

Informations

• Status: Fully functional
• Source: Included
• Size: 852kB

Platforms: D7

Description

SQLite is a small footprint fast sql database engine designed for single user computers. The DbExpress driver is still work in progress. Although most of it works by using a simpleTSqlClientDataSet, no guarantees are made for proper working.

Informations

• Status: Fully functional
• Source: N/A
• Size: 236kB

Platforms: D6, D7

Description

• Supports multiple platforms (currently supports Windows, Mac OSX)
• Full Unicode support
• Takes advantage of the new Delphi language features (Generics, closures, etc.)
• Fast
• Simple to use
• Lightweight
• Supports adding custom user functions
• Can fetch data into your own data structure
• Unit tested (Unit test coverage is 76% overall)
• Have TDataset descendant (TSQLiteDataset) for using it in DB aware VCL projects
• Database encryption support (for encryption to work you must use different sqlite3 library file because default one does not support it. You can get it from here or here
• Prepared statements and SQLite uni-directional tables can be retrieved from database as interfaces so you don't need to free them.
• Database authorization support.

Informations

• Status: Fully functional
• Source: Included
• Size: 2 320kB

Platforms: D2009, D2010, DXE, DXE2

Description

Contains:

• TSivak3Database - database connection, published to component palette
• TSivak3SimpleTable - not a TDataset descendant, published to component palette, very fast, usable to fill some string list, string grid, list view, etc... see GetValues procedure(s)
• TSivak3Exec - not a TDataset descendant, published to component palette, usable for executing SQL, one or more SQL commands, separated by semicolon if the SQL command(s) returns a cursor, individual records are taken by "OnFetchRecord" event
• TSivak3Command - base TDataset descendant, not published to component palette, fully usable, no abstract or empty methods you can use in runtime as a simplified query ( TSivak3Command.Create... ) ancestor for standard dataset objects (TSivak3Query, TSivak3Table)
• TSivak3Query - TDataset (TSivak3Command) descendant, published to component palette
• TSivak3Table - TDataset (TSivak3Command) descendant, published to component palette.

Informations

• Status: Fully functional
• Source: On purchase/registration
• Source price: $58.80
• Size: 1 591kB

Platforms: D2007, D2010, D7

Description

TSQLite is a wrapper class for SQLite which is an SQL engine in a single 150K .dll. Ideally suited for web servers, kiosk applications, standalone applets etc. where not the complete DB GUI stuff is needed.
Required psqlite.dll from here.

New features:

• Added String conversion routines from SQL String <-> Pascal String.
• Added Conversion TStrings -> Name-Value Pairs.
• Improved Demo.

Informations

• Status: Fully functional
• Source: Included
• Size: 10kB

Platforms: D3, D4, D5, D6

Description

SQLite is a small C library that implements a self contained, embeddable, high performance, zero-configuration SQL database engine. TSQLite is a simple wrapper that makes the capabilities of SQLite easily accessible from within your Delphi application. The source code demonstrates how TSQLite can be used to create, query and modify a SQLite database.

Informations

• Status: Fully functional
• Source: None
• Size: 442kB

Platforms: D2005, D2006, D2007, D6, D7

Description

TSQLiteDB is class wrapper for TSQLite.

Informations

• Status: Fully functional
• Source: Included
• Size: 10kB

Platforms: D3, D4, D5, D6

Description

Descedant of TDataSet for connection with SQlite database library.

Informations

• Status: Fully functional
• Source: Included
• Size: 128kB

Platforms: D5, D6