What and Why SQLite3 in Python

 

SQLite3


SQLite is a software library that provides a lightweight disk-based (Table format) database.
SQLite3 doesn’t require a separate server process.
SQLite is the most widely deployed SQL database engine in the world.




Why SQLite3 

 SQLite does not need a separate server process or system to operate (serverless)..

SQLite comes with zero-configuration, which means no setup or administration needed.

A complete SQLite database is stored in a single cross-platform disk file.

SQLite is very small and light weight, less than 400KiB fully configured or less than 250KiB with optional features omitted.

SQLite is self-contained, which means no external dependencies.

SQLite transactions are fully ACID-compliant, allowing safe access from multiple processes or threads.

SQLite supports most of the query language features found in SQL92 (SQL2) standard.

SQLite is written in ANSI-C and provides simple and easy-to-use API.

SQLite is available on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT).





Comments

My photo
Techno Xpresss
Bangalore, Karnataka, India