SQLite is the most widely deployed database which is been used in various applications & high profile projects. It is an in-process library that implements a self-contained, server less, transactional SQL database engine. SQLite is an embedded SQL database engine.
Trivialworks use SQLite because of its variant features. Using SQLite in software and applications increases application’s efficiency and flexibility and making it more reliable to use.
Transactions are atomic, consistent, isolated and durable (ACID) even after system crashes and power failures.
Zero Configurations: No setup or administration needed.
Full Featured SQL with advanced capabilities like partial indexes, indexes on expressions, JSON, and common table expressions.
Self Contained: No external Dependencies.
Cross Platform: Android, iOS, Mac, Linux, Solaris and Windows are supported out of the box. Easy to port to other systems.
We strongly prefer SQLite for small to medium sized websites as it is fast and does not require any configuration as it stores information in ordinary disk files. SQLite is a smart choice for the database engine in cell phones, 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.