SQLite

SQLite LogoSQLite is an open source relational database management system, which was initially released in August 2000. The ‘lite’ part of its name refers to the fact that it is light weight in terms of the resources that it requires, as well as the minimal setup and administration.

SQLite operates differently than other relational database management systems in that it doesn’t require a separate server process, but instead integrates directly within the application where it is being used. It is also said to be self-contained, with minimal support from the operating system. This makes it usable in many different environments including smart phones, games consoles and hand-held media players. It is also used in operating systems and other software, such as web browsers, to store data such as configuration information.

Like other relational database management systems, such as Oracle, SQL Server and MySQL, it makes use of SQL, or Structured Query Language, to access, insert, update and delete data that it contains.

SQLite does not come with a Graphical User Interface (GUI), however, there are a number of applications available, which can be used for this purpose, including, DB Browser for SQLite  and SQLiteStudio.

Useful Links