Step-by-Step Guide to Install SQLite on Windows
In this article, I will tell you how to install SQLite on windows with simple steps:
- Visit the official website of SQLite for downloading the installation files.
- Download these two zip file
i)sqlite-dll-win32-x86-3370xxx.zip (OR) sqlite-dll-win32-x64-3370xxx.zip ii) SQLite-tools-win32-x86-3370200.zip
- Create a folder “sqlite3” in local disk C or D and extract the zip files there.
- Go to the command prompt. Set the path for the location of the SQLite folder given in the previous step. After that write, “sqlite3” and press enter.
D:\sqlite3>sqlite3 SQLite version 3.37.2 2022-02-06 13:25:40 Enter ".help" for usage hints. connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent DB sqlite>
We can use third-party tools like DB Brower (SQLite) to view/create tables. The latest PHP version, SQLite is pre-installed. We can copy the database file created to the www folder and access it in PHP.