How To Install Sqlite3 On Windows 10

Sqlite is often a serverless relational database management system, what we should called as an embedded database. It is very lightweight and also easy to work with. In this article we intend to see how to setup sqlite database on Microsoft windows 10 operating-system.

Sqlite3 installation register for windows 10 can be a zip file, that contains the sqlite3.exe. What we should do is Download and extract zip file to hard disk drive, then access the sqlite3.exe on the windows 10 command line.

Download sqlite3 for Windows 10

Go to sqlite3 download page and download the sqlite-tools zip file for a hardrive(Under the Precompiled Binaries for Windows).

Once you extract the zip file, you will discover sqlite3.exe file, which is the command line shell we use to make and manage sqlite databases.

Create sqlite3 folder inside C Drive

Now build a folder called sqlite3 within the C drive and copy the sqlite3.exe file on the folder you created.

Basically that's all we should do. We can now create sqlite databases using windows command prompt by moving to C:sqlite3 directory.

Example : Create sqlite database and table.

To develop a database first open the Windows 10 command prompt(Start menu > All Apps > Windows System > Command Prompt). Then move towards the C:sqlite3 folder using cd command.

Then utilize the sqlite3 command and then the name of the database to generate a database.

It is not needed to use .db extension on the database name. You can put any extension you wish or if you would like, you may create the database without extension.

Add Sqlite3 to Windows Path Variable

There is but one more thing we're able to do. We can add sqlite for the Windows PATH variable, while it's not essential. If we add Sqlite towards the Windows 10 PATH variable you can access the sqlite3 command without moving for the C:sqlite3 folder.

- Open Advanced System Properties ( Control Panel > System and Security > System > Advanced System Settings).

- Click Environment Variables.

- Under the system variables, Select the PATH variable and click on edit.

- Append ;C:sqlite3 following the value and click on ok(Do not forget the semicolon).

A Sqlite database can be a one single file, which you can relocate to anywhere in your personal computer. Also you can move a database from one os to another without problem.