SQLite
SQLite (/ˌɛsˌkjuːˌɛlˈaɪt/, /ˈsiːkwəˌlaɪt/) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it is used by several of the top web browsers, operating systems, mobile phones, and other embedded systems.
Screenshot of sqlite3 command-line shell program | |
| Developer(s) | D. Richard Hipp |
|---|---|
| Initial release | 17 August 2000 |
| Stable release | 3.45.1 (30 January 2024) [±] |
| Repository | |
| Written in | C |
| Operating system | Cross-platform |
| Size | 699 KiB |
| Type | RDBMS (embedded) |
| License | Public domain |
| Website | sqlite |
| Filename extension |
.sqlite, .sqlite3, .db, .db3, .s3db, .sl3 |
|---|---|
| Internet media type | application/vnd.sqlite3 |
| Magic number | 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 (zero-terminated ASCII "SQLite format 3") |
| Initial release | 2004-06-18 |
| Open format? | yes (Public Domain) |
| Website | www |
Many programming languages have bindings to the SQLite library. It generally follows PostgreSQL syntax, but does not enforce type checking by default. This means that one can, for example, insert a string into a column defined as an integer.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.