SQLite

What is SQLite?


SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource.

SQLite has the following noticeable features: self-contained, serverless, zero-configuration, transactional.

SQLite Tutorial



Download and Install SQLite


Install SQLite

Installing SQLite is simple and straightforward.

First, create a new folder e.g., C:\sqlite.
Second, extract the content of the file that you downloaded in the  previous section to the C:\sqlite folder. You should see the sqlite3.exe is in the C:\sqlite folder.
To verify the installation, you perform the following steps:

  1. First, open the command line window and navigate to the C:\sqlite folder.
  2. Second, enter sqlite3,
  3. Third, you can type the .help command from the  sqlite> prompt to see all available commands in sqlite3.
  4. Fourth, to quit the sqlite>, you use .quit command

Install SQLite GUI tool

The sqlite3 command is excellent…

However, sometimes, you want to work with the SQLite databases using an intuitive GUI tool.

There are many GUI tools for managing SQLite databases  available ranging from a freeware to commercial licenses.

In this tutorial, we would like to introduce you to a free GUI tool for managing SQLite databases named SQLite Studio.

The SQLite studio is free, portable, intuitive, and cross platform. In addition, it provides some of the most important features to work with SQLite databases such as importing, exporting data in various formats e.g., CSV, XML, JSON, etc.

You can download the SQLite studio at the homepage of SQLite, extract the file into a folder e.g., C:\sqlite\gui\ and run it.







Comments