SQLite
C language library that implements a SQL database engine
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)
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's Wellness Encyclopedia |
| Let Food Be Thy Medicine Medicine Thy Food - Hippocrates |
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
Medical Disclaimer: WikiMD is not a substitute for professional medical advice. The information on WikiMD is provided as an information resource only, may be incorrect, outdated or misleading, and is not to be used or relied on for any diagnostic or treatment purposes. Please consult your health care provider before making any healthcare decisions or for guidance about a specific medical condition. WikiMD expressly disclaims responsibility, and shall have no liability, for any damages, loss, injury, or liability whatsoever suffered as a result of your reliance on the information contained in this site. By visiting this site you agree to the foregoing terms and conditions, which may from time to time be changed or supplemented by WikiMD. If you do not agree to the foregoing terms and conditions, you should not enter or use this site. See full disclaimer.
Credits:Most images are courtesy of Wikimedia commons, and templates Wikipedia, licensed under CC BY SA or similar.
Contributors: Prab R. Tumpati, MD
