Add Resources      Login      Logout

SQLite Corner: tools, articles, tips and more.

SQLite

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

Advertisements
 

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. (Features not supported)
  • A complete database is stored in a single disk file.
  • Database files can be freely shared between machines with different byte orders.
  • Supports databases up to 2 terabytes (241 bytes) in size.
  • Sizes of strings and BLOBs limited only by available memory.
  • Small code footprint: less than 250KiB fully configured or less than 150KiB with optional features omitted.
  • Faster than popular client/server database engines for most common operations.
  • Simple, easy to use API.
  • TCL bindings included. Bindings for many other languages available separately.
  • Well-commented source code with over 95% test coverage.
  • Self-contained: no external dependencies.
  • Sources are in the public domain. Use for any purpose.

The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

Discussion

Latest News about SQLite
Latest entries about SQLite
  • dotConnect for SQLite

    An enhanced data provider for SQLite that builds on ADO.NET technology to present a complete solution for developing SQLite-based database applications. As part of the Core Lab database application development framework, MyDirect .NET offers both high performance native connectivity to the MySQL database and a number of innovative development tools and technologies.

  • dotConnect for SQLite Final Released

    April 8, 2008 - Core Lab Software Development proudly presents the final release of the new member of ADO.NET data providers family: dotConnect for SQLite. From now on you can access the popular SQLite database engine with the standard ADO.NET interface you are used to. This reveals new capabilities to your applications, because the same code you wrote for SQL servers now works for local data storages!

  • SQLite Maestro 7.9 released. Cancellation of query execution and SQL Formatter

    SQL Maestro Group announced the release of SQLite Maestro 7.9, a powerful Windows GUI solution for SQLite administration and database development.

  • New version of Data Wizard product family released. ASP.NET Generator wizard and a new Shell Application with the Ribbon toolbar.

    SQL Maestro Group announced the release of a new version of Data Wizard product family, a toolset of powerful utilities for managing your data. There are versions for MySQL, Oracle, SQL Server, PostgreSQL, SQLite, Firebird and MaxDB.

  • Free PHP Generators for MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite, Firebird and MaxDB released

    SQL Maestro Group announces the release of freeware PHP Generators for MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite, Firebird and MaxDB database servers.

  • SQLite Maestro 6.12 released

    The main feature of the new version is the tabbed MDI interface implementation.

  • SQLite Maestro 6.11

    We are happy to present the new product of SQLite Administration Tools Family - SQLite Maestro, a powerful solution for the SQLite server administration and development.

  • SQLite Maestro 6.11

    SQLite Maestro is a powerful Windows database management solution for SQLite administration and development.

  • PHP script generators for SQL Server, PostgreSQL, MySQL, Firebird and SQLite

    The information represented in this article describes the usage of Data Wizard PHP Generators for MySQL, PostgreSQL, SQL Server, Firebird and SQLite. Here you will find the methods that allow you to use the power of PHP even without detailed knowledge of PHP syntax. Examination of the article can be useful not only for beginners, professionals may also find a lot of interesting. A number of detailed examples that should exclude any misunderstanding will guide you through all steps of PHP script generation from your database.

  • SQLite Data Wizard 6.6

    Our company is pleased to present a new product which has underlain the SQLite Administration tools family - SQLite Data Wizard, a powerful utility for managing your SQLite data.

All content Copyright© 2004-2006. databasecorner.com . All Rights Reserved.

Reproduction in whole or in part in any form or medium without express written permission is prohibited.

Use of this site, content or service of databasecorner.com constitutes acceptance of our Terms of Use and Privacy Policy

All product names and designated trademarks and brands are the property of their respective owners.

databasecorner.com is not affiliated with or endorsed by any company listed at this site.

Sistemax, LLC
1920 South Main Street, Suite 530
McAllen, TX 78503
USA
(210) 787-3505

Page rendered on:11/21/2008 3:32:37 PM