Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you install sqlite3 on Windows

Tags:

sqlite

http://www.sqlite.org/download.html - The download page shows 3 pre-compiled zips for the database. It doesn't look like a full installation. Where am I supposed to install these files?

like image 276
Jason Avatar asked Sep 07 '11 07:09

Jason


People also ask

How can I tell if SQLite is installed on Windows?

Check for SQLite The first thing to do is to check whether SQLite is installed on your system or not. You can do this simply by entering sqlite3 into your system's command line interface (assuming version 3+ is installed).

Does SQLite need to be installed?

SQLite does not need to be "installed" before it is used. There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured. There is no need for an administrator to create a new database instance or assign access permissions to users.

Where is sqlite3 exe located?

Navigate manually to the folder where sqlite3.exe is located “C:\sqlite”. Double click sqlite3.exe to open the SQLite command line.


1 Answers

Here is the list:

Precompiled Binaries For Windows

sqlite-shell-win32-x86-3070701.zip (244.12 KiB) A command-line shell for accessing and modifying SQLite databases.

sqlite-dll-win32-x86-3070701.zip (278.28 KiB) This ZIP archive contains a DLL for the SQLite library version 3.7.7.1.

sqlite-analyzer-win32-x86-3070701.zip (710.48 KiB) An analysis program for database files compatible with all SQLite versions through 3.7.7.1 and beyond.

There are shell and analyzer program that can be used to interactively work with sqlite databases without writing any code. Shell is an interactive SQL command-line interface; and analyzer is program to get info about some sqlite database. You can place this tools anywhere, or install them to some folder, which is in your %PATH%.

DLL is compiled sqlite library that should be placed in your application directory.

like image 153
osgx Avatar answered Oct 19 '22 06:10

osgx