SQLite
Serverless relational database management system (RDBMS) / From Wikipedia, the free encyclopedia
Dear Wikiwand AI, let's keep it short by simply answering these key questions:
Can you list the top facts and stats about SQLite?
Summarize this article for a 10 year old
SQLite (/ˌɛsˌkjuːˌɛlˈaɪt/,[4][5] /ˈsiːkwəˌlaɪt/[6]) 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.[7]
Developer(s) | D. Richard Hipp |
---|---|
Initial release | 17 August 2000; 23 years ago (2000-08-17) |
Stable release | 3.45.3[1] (15 April 2024; 20 days ago (15 April 2024)) [±] |
Repository | |
Written in | C |
Operating system | Cross-platform |
Size | 699 KiB |
Type | RDBMS (embedded) |
License | Public domain[2] |
Website | sqlite |
Filename extension |
.sqlite, .sqlite3, .db, .db3, .s3db, .sl3 |
---|---|
Internet media type | application/vnd.sqlite3 [3] |
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.[8][9] This means that one can, for example, insert a string into a column defined as an integer.