How To Download & Install SQLite Tools

                 How To Download & Install SQLite Tools

Download SQLite tools

To download SQLite, you open the download page of the SQlite official website.

1.    First, go to the https://www.sqlite.org website.

2.    Second, open the download page https://www.sqlite.org/download.html

SQLite provides various tools for working across platforms e.g., Windows, Linux, and Mac. You need to select an appropriate version to download.

screenshot below.

The downloaded file is in the ZIP format and its size is quite small.

Run SQLite tools

Installing SQLite is simple and straightforward.

1.    First, create a new folder e.g., C:\sqlite.

2.    Second, extract the content of the file that you downloaded in the previous section to the C:\sqlite folder. You should see three programs in the C:\sqlite folder as shown below:

First, open the command line window

and navigate to the C:\sqlite folder

C:\cd c:\sqlite

C:\sqlite>

Second, type sqlite3 and press enter, you should see the following output:

C:\sqlite>sqlite3

SQLite version 3.29.0 2019-07-10 17:32:03

Enter ".help" for usage hints.

Connected to a transient in-memory database.

Use ".open FILENAME" to reopen on a persistent database.

sqlite>

Install SQLite GUI tool

the SQLite Studio, you can use the following free SQLite GUI tools:

·         DBeaver  is another free multi-platform database tool. It supports all popular major relational database systems MySQL, PostgreSQL, Oracle, DB2, SQL Server, Sybase.. including SQLite.

·         DB Browser for SQLite – is an open-source tool to manage database files compatible with SQLite.

then happy coding.

if you used then follow my page.