SQLite as the name itself suggests, a lightweight relational database management system contained in a C library. It does not follow the traditional client-server model like any other RDBMS (PostgreSQL, MySQL, MariaDB, Microsoft SQL). Rather, it is just a small self-contained file having everything in it. This file can be embedded into any end program.
Being so small but still SQLite has ACID compliance and implements most of the SQL standards while following SQL syntax. Let?s see how you can get the SQLite in your Ubuntu or Debian distribution.