Soft82.com » Windows » Developer Tools » Database » Database Applications » SQLite3 3.7.12.1

SQLite3 Description

A command-line access program for SQLite databases

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.

Features:

Zero-Configuration

SQLite does not need to be "installed" before it is used. There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured. There is no need for an administrator to create a new database instance or assign access permissions to users. SQLite uses no configuration files. Nothing needs to be done to tell the system that SQLite is running. No actions are required to recover after a system crash or power failure. There is nothing to troubleshoot.

SQLite just works.

Other more familiar database engines run great once you get them going. But doing the initial installation and configuration can be intimidatingly complex.

Serverless

Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the process that wants to access the database reads and writes directly from the database files on disk. There is no intermediary server process.

There are advantages and disadvantages to being serverless. The main advantage is that there is no separate server process to install, setup, configure, initialize, manage, and troubleshoot. This is one reason why SQLite is a "zero-configuration" database engine. Programs that use SQLite require no administrative support for setting up the database engine before they are run. Any program that is able to access the disk is able to use an SQLite database.

On the other hand, a database engine that uses a server can provide better protection from bugs in the client application - stray pointers in a client cannot corrupt memory on the server. And because a server is a single persistent process, it is able control database access with more precision, allowing for finer grain locking and better concurrency.

Most SQL database engines are client/server based. Of those that are serverless, SQLite is the only one that this author knows of that allows multiple applications to access the same database at the same time.

Single Database File

An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. If SQLite can read the disk file then it can read anything in the database. If the disk file and its directory are writable, then SQLite can change anything in the database. Database files can easily be copied onto a USB memory stick or emailed for sharing.

Other SQL database engines tend to store data as a large collection of files. Often these files are in a standard location that only the database engine itself can access. This makes the data more secure, but also makes it harder to access. Some SQL database engines provide the option of writing directly to disk and bypassing the filesystem all together. This provides added performance, but at the cost of considerable setup and maintenance complexity.

Stable Cross-Platform Database File

The SQLite file format is cross-platform. A database file written on one machine can be copied to and used on a different machine with a different architecture. Big-endian or little-endian, 32-bit or 64-bit does not matter. All machines use the same file format. Furthermore, the developers have pledged to keep the file format stable and backwards compatible, so newer versions of SQLite can read and write older database files.

Most other SQL database engines require you to dump and restore the database when moving from one platform to another and often when upgrading to a newer version of the software.

Compact

When optimized for size, the whole SQLite library with everything enabled is less than 275KiB in size (as measured on an ix86 using the "size" utility from the GNU compiler suite.) Unneeded features can be disabled at compile-time to further reduce the size of the library to under 190KiB if desired.

Most other SQL database engines are much larger than this. IBM boasts that its recently released CloudScape database engine is "only" a 2MiB jar file - an order of magnitude larger than SQLite even after it is compressed! Firebird boasts that its client-side library is only 350KiB. That's 50% larger than SQLite and does not even contain the database engine. The Berkeley DB library from Oracle is 450KiB and it omits SQL support, providing the programmer with only simple key/value pairs.

Manifest typing

Most SQL database engines use static typing. A datatype is associated with each column in a table and only values of that particular datatype are allowed to be stored in that column. SQLite relaxes this restriction by using manifest typing. In manifest typing, the datatype is a property of the value itself, not of the column in which the value is stored. SQLite thus allows the user to store any value of any datatype into any column regardless of the declared type of that column. (There are some exceptions to this rule: An INTEGER PRIMARY KEY column may only store integers. And SQLite attempts to coerce values into the declared datatype of the column when it can.)

As far as we can tell, the SQL language specification allows the use of manifest typing. Nevertheless, most other SQL database engines are statically typed and so some people feel that the use of manifest typing is a bug in SQLite. But the authors of SQLite feel very strongly that this is a feature. The use of manifest typing in SQLite is a deliberate design decision which has proven in practice to make SQLite more reliable and easier to use, especially when used in combination with dynamically typed programming languages such as Tcl and Python.

Variable-length records

Most other SQL database engines allocated a fixed amount of disk space for each row in most tables. They play special tricks for handling BLOBs and CLOBs which can be of wildly varying length. But for most tables, if you declare a column to be a VARCHAR(100) then the database engine will allocate 100 bytes of disk space regardless of how much information you actually store in that column.

SQLite, in contrast, use only the amount of disk space actually needed to store the information in a row. If you store a single character in a VARCHAR(100) column, then only a single byte of disk space is consumed. (Actually two bytes - there is some overhead at the beginning of each column to record its datatype and length.)

The use of variable-length records by SQLite has a number of advantages. It results in smaller database files, obviously. It also makes the database run faster, since there is less information to move to and from disk. And, the use of variable-length records makes it possible for SQLite to employ manifest typing instead of static typing.

Readable source code

The source code to SQLite is designed to be readable and accessible to the average programmer. All procedures and data structures and many automatic variables are carefully commented with useful information about what they do. Boilerplate commenting is omitted.

SQLite3 Version History

SQLite3 Download Button For Your Site

If you want to place a Download Button for SQLite3 on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

SQLite3 User Reviews

New Database Applications Software

MyDbExplorer Team Edition May 23, 2012 Connect to virtually any relational database backend				SQL Client May 23, 2012 Connect to your database with this tool
Nevron SSRS Vision May 22, 2012 Professional Data Visualization Component Suite for SSRS				DbWrench May 18, 2012 Our goal with DbWrench is to make database design cycles quicker and easier
Sfairadora May 17, 2012 Flexible tool for small databases with functions of spreadsheet and text output				Reportizer May 17, 2012 Database reporting tool
dbForge Schema Compare for Oracle May 16, 2012 Compare and synchronize Oracle databases with ease				DTM DB Stress Professional May 16, 2012 A utility for stress testing the server parts of information systems and applications
LinqConnect May 16, 2012 A fast and easy to use ORM solution				SQL Vehicle Database Download + ASP.Net May 16, 2012 Get the 1904-2013 vehicle data in MSSQL and MySQL formats
Association Manager May 15, 2012 ALL-IN-ONE, Easy to Use and Membership and Event Management Solution for Associations				DataCleaner May 14, 2012 An Open Source application for analyzing, profiling, transforming and cleansing data
SQL 2 Excel May 14, 2012 Import SQL queries in Excel tables				dbForge Schema Compare for MySQL May 14, 2012 Tool to compare and synchronize structures of MySQL databases
ERD Concepts May 14, 2012 Database software for professionals				dbForge Data Studio for SQL Server May 14, 2012 Chief query tool for SQL Server data analysts and developers
ETL-Tools QlikView Connector May 10, 2012 An ideal tool for customers who are working with complex and bad quality data				Log Table Viewer May 10, 2012 Provides a unified logging interface for your SQL code
DbVisualizer Personal May 10, 2012 Helps you with both the development and maintenance of your databases

Last 7 Days Most Downloaded Database Applications Products

DB Load Generator 41 downloads The easy way to test your database setup, server performance or sql query effectiveness				SQLDumper 17 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT
TOra 16 downloads Database management GUI that supports accessing most of the common database platforms				EMS SQL Manager for MySQL 14 downloads State-of-the-art GUI tool for MySQL Server administration and development
DbVisualizer Personal 13 downloads Helps you with both the development and maintenance of your databases				NGen NHibernate Code Generator 12 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
SQLite3 9 downloads A command-line access program for SQLite databases				MySQL Automatic Backup & Restore Software 8 downloads Backup entire MySQL databases
Pdxrbld 4 downloads Utility for checking and repairing Paradox tables				Firebird 4 downloads Firebird is a relational database offering many ANSI SQL-92 features

All Time Most Downloaded Database Applications Products

DB Load Generator 3,354 downloads The easy way to test your database setup, server performance or sql query effectiveness				SQLDumper 6,389 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT
TOra 805 downloads Database management GUI that supports accessing most of the common database platforms				EMS SQL Manager for MySQL 2,068 downloads State-of-the-art GUI tool for MySQL Server administration and development
DbVisualizer Personal 1,076 downloads Helps you with both the development and maintenance of your databases				NGen NHibernate Code Generator 492 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
SQLite3 256 downloads A command-line access program for SQLite databases				MySQL Automatic Backup & Restore Software 312 downloads Backup entire MySQL databases
Pdxrbld 129 downloads Utility for checking and repairing Paradox tables				Firebird 3,332 downloads Firebird is a relational database offering many ANSI SQL-92 features