SQLite

SQLite is a simple relational database engine that does not require a separate service on the server to run. The use of the SQLite API is possible in many programming languages including Python, PHP, Java and .NET. SQLite is fully compatible with frameworks such as Django or Symfony, and supports the ANSI SQL dialect, which allows you to easily switch to a dedicated database engine if necessary.

It works well on devices with limited possibilities of installing additional software, such as smartphones, set-top boxes and TV sets. It is also a great database engine for websites with low to medium traffic. When properly configured, it is efficient and can act as both an engine for analyzing a large set of information and a cache server for data with frequent reading.