SQLITE- MOST WIDELY DEPLOYED DATABASE IN THE WORLD

Self-proclaimed as the most widely deployed database in the world, SQLite began in 2000 and has been used by notable companies like Apple, Facebook, Microsoft, and Google. Each release is carefully tested to ensure reliability. Even if there are bugs, the developers of SQLite are honest about potential shortcomings by providing bug lists and chronologies of code changes for every release.

SQLite is a best and popular choice as embedded database software for local/client storage in application software such as web browsers. It is the most widely used database engine, as it is used today by several widespread browsers, operating systems, and embedded systems. SQLite has bindings to many programming languages also. SQLite  is not a client–server database engine. Rather, it is embedded into the end program. Due to the server-less design, SQLite applications require fewer configurations than client-server databases. SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. It is the most used database engine in the world. Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures. It is Simple and easy to use API. SQLite have Well-commented source code with 100% branch test coverage. SQLite is popular choice for the database engine in cellphones, PDAs, MP3 players, set-top boxes, and other electronic gadgets. SQLite has a small code footprint, makes efficient use of memory, disk space, and disk bandwidth, is highly reliable, and requires no maintenance from a Database Administrator.

Pros

• No separate server process
• File format is cross-platform
• Compact library: runs faster even with more memory
• Transactions are ACID compliant
• Professional support also available

Cons

• Client/Server applications
• Not recommended for:
• High-volume websites
• Large datasets
• High concurrency