SQLite
 | |
| Original author(s) | D. Richard Hipp |
|---|---|
| Developer(s) | D. Richard Hipp |
| Initial release | August 17, 2000 |
| Stable release | 3.39.2
/ August1, 2022 |
| Repository |
|
| Written in | C |
| Engine | |
| Operating system | Cross-platform |
| Type | Embedded database |
| License | Public domain |
| Website | www.sqlite.org |
SQLite is a C language library that implements a SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. It 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, allowing the same database file to be copied between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
Features[edit | edit source]
SQLite is a popular choice as an embedded database for local/client storage in application software such as web browsers, operating systems, and embedded systems. It is used by several high-profile projects including Mozilla Firefox, Google Chrome, and Android.
Some of the key features of SQLite include:
- Zero-configuration: No setup or administration required.
- Serverless: SQLite does not require a separate server process.
- Cross-platform: The database file format is cross-platform.
- Compact: The library size is less than 600KiB.
- Reliable: SQLite is highly reliable and used in many applications.
Architecture[edit | edit source]
SQLite is designed to be embedded into an application, providing a lightweight, disk-based database that doesn’t require a separate server process. The entire database is stored in a single file on disk, which simplifies the process of backing up and transferring the database.
Use Cases[edit | edit source]
SQLite is widely used in various scenarios, including:
- Web browsers: For storing user data and preferences.
- Mobile applications: As a local database for mobile apps.
- Embedded systems: Due to its small footprint and simplicity.
- Desktop applications: For applications that need a simple, reliable database.
History[edit | edit source]
SQLite was created by D. Richard Hipp in 2000. It was designed to provide a lightweight, serverless, self-contained, transactional SQL database engine. Since its inception, it has grown in popularity and is now used in a wide range of applications and devices.
See also[edit | edit source]
- SQL
- Database management system
- Embedded database
- D. Richard Hipp
- Mozilla Firefox
- Google Chrome
- Android (operating system)
Related pages[edit | edit source]
- SQL
- Database management system
- Embedded database
- D. Richard Hipp
- Mozilla Firefox
- Google Chrome
- Android (operating system)
Navigation: Wellness - Encyclopedia - Health topics - Disease Index - Drugs - World Directory - Gray's Anatomy - Keto diet - Recipes
Search WikiMD
Ad.Tired of being Overweight? Try W8MD's physician weight loss program.
Semaglutide (Ozempic / Wegovy and Tirzepatide (Mounjaro / Zepbound) available.
Advertise on WikiMD
WikiMD is not a substitute for professional medical advice. See full disclaimer.
Credits:Most images are courtesy of Wikimedia commons, and templates Wikipedia, licensed under CC BY SA or similar.
Translate this page: - East Asian
中文,
日本,
한국어,
South Asian
हिन्दी,
தமிழ்,
తెలుగు,
Urdu,
ಕನ್ನಡ,
Southeast Asian
Indonesian,
Vietnamese,
Thai,
မြန်မာဘာသာ,
বাংলা
European
español,
Deutsch,
français,
Greek,
português do Brasil,
polski,
română,
русский,
Nederlands,
norsk,
svenska,
suomi,
Italian
Middle Eastern & African
عربى,
Turkish,
Persian,
Hebrew,
Afrikaans,
isiZulu,
Kiswahili,
Other
Bulgarian,
Hungarian,
Czech,
Swedish,
മലയാളം,
मराठी,
ਪੰਜਾਬੀ,
ગુજરાતી,
Portuguese,
Ukrainian
Contributors: Prab R. Tumpati, MD
