SQLitetietokantaan

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform. You can freely copy a database file from one machine to another, or from Windows to Unix, and SQLite will read it without problems. SQLite database files can be reliably accessed by multiple processes at once, with full ACID (atomicity, consistency, isolation, durability) compliance. SQLite supports most of the SQL standard, including transactions, prepared statements, and user-defined functions. SQLite is used by many small to medium-sized projects and applications that use a database. SQLite is also used in embedded systems where a small footprint is required. SQLite is not intended to replace client/server databases in large or high-volume environments, but rather to provide a lightweight database solution for applications that need to store data locally. SQLite is open source and is in the public domain.