How to Install SQLite on Windows

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:

    1. Visit the official website of SQLite for downloading the installation files.
    2. 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
    3. Create a folder “sqlite3” in local disk C or D  and extract the zip files there.
    4. 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>

Note:

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.

Leave a Reply