In this tutorial shows you step by step how to download and install SQLite on your computer.
Download SQLite
To download SQLite, you open the download page of the SQlite website.
- First, go to the https://www.sqlite.org website.
- Second, open the download page https://www.sqlite.org/download.html
SQLite provides various versions for various platforms e.g., Windows, Linux, and Mac. You should choose an appropriate version to download.
For example, to work with SQLite on Windows, you download the command-line shell program as shown in the screenshot below.
The downloaded file is in the ZIP format and its size is quite small.
- Download the sqlite-dll and sqlite-shell zip file. Or sqlite-tools-win32-x86-3170000.zip file.
- Create a folder named sqlite in C directory and expand these files.
- Open command prompt to set the path. Set your PATH environment variable and open sqlite3 command. It will look like this:
The above method facilitates you a permanent way to create database, attach database and detach database.
There is another way to execute CRUD operation in SQLite. In this method, there is no need to set a path.
- Just download the SQlite precompiled Binary zip file.
- Expand the zipped file, you will see a page like this:
- Run the selected sqlite3 application:
You can execute the SQLite query here. But here, the data is temporary and once you shut down your computer, you will lose the records you have. Because, you cannot create, attach or detach a database here.
0 comments:
Post a Comment