|
SQLite is a programming library which contains a relational database system, which in turn fulfil the ACID properties.
Among other things, SQLite supports transactions, subselects, views, triggers and user-defined functions.
The database was designed primarily for use in embedded systems. Appropriate bindings exists for all important programming languages.
This means that the database can be directly integrated into relevant applications, so that other server software such as PHP is not needed.
SQLite has some particularities when compare to other databases:
The library is only a few hundred kilobytes in size. The databases can be saved in a single file, or can be split accross multiple files. This simplifies the exchange of data between different systems, even between systems with different byte orders. Each column can contain arbitrary types - conversion only takes place during run-time.
Some features available in other databases are not offered by SQLite:
When data is being edited, the complete database is write-locked. Foreign keys are not supported. The command "ALTER TABLE" exists with limited functionality. Other than the access permissions of the file system, there are no user or access permissions for the database. |
