SQLite Forum

Setup of SQLite on windows

Setup of SQLite on windows

(1) By SQLshockwave (SQLwave) on 2020-12-04 22:41:00 [link] [source]

How do you set up SQLite on windows? Just trying to know

(2) By Larry Brasfield (LarryBrasfield) on 2020-12-05 01:50:08 in reply to 1 [source]

I assume you are asking how to setup the SQLite CLI shell. From the Download page, get the .zip archive described as "A bundle of command-line tools for managing SQLite database files". Select a directory named in your PATH environment variable, or create one and add it to that variable. Then extract the archive content to that directory. At that point, from either a CMD.exe shell or a Powershell session, you should be able to invoke 'sqlite3' to start the SQLite CLI shell.

If you mean something else by "set up SQLite", you will need to learn programming before you can expect to make use of the SQLite library. By the time you do that, details of getting it setup will be more obvious.

Have fun.

(3) By anonymous on 2020-12-05 06:41:47 in reply to 1 [link] [source]

There is no setup in the sense that SQLite has no Windows installer and does NOT require any registry entries/changes.

To start with download the SQLite Shell and extract the files to a hard disk location of your choice. To move SQLite from your computer, you will simply delete the location you specified.

At that location, find SQLite.EXE, right click and select Create Shortcut from the menu; by default, the shortcut will appear on your desktop.

a. The Target will be your location - for me it is D:\SQLite32\sqlite3.exe.

b. Specify your location as the value for Start in - for me it is D:\SQLite32

Double click on the shortcut on your desktop to start the SQLite CLI (command line interface).

The commands .exit or .quit followed by Enter terminates the SQLite CLI; type .help for other options.

You need a database to explore SQLite. Download a sample database for this purpose. Alternatively search for other samples using Google.

If you want to use SQLite from C#, examine the literature at System and Microsoft. These have a version of SQLite built-in.

If you want to use legacy ADODB, you will need to download an ODBC driver . Take care to select the appropriate 32- or 64-bit driver; this will depend on the bit-ness of your programming language. the ODBC driver has a version of SQLite built-in.

If you want to use the SQLite library from your programming language, download either the 32-bit or 64-bit version. Refer to Programming Interfaces for the available APIs.

If you want to customize SQLite for your purposes, you will need to compile the source code with your options.

(4) By anonymous on 2020-12-05 08:47:30 in reply to 3 [link] [source]

Correction:To remove SQLite from your computer, you will simply delete the location you specified.

You are already aware of this forum.You will also find over 85,000 SQlite threads here. In the former, you can post anonymously, in the latter you will need credentials to post questions.

Regardless of which forum you use to ask questions; both might seem rather unforgiving unless you compose your questions in a certain (expected) way; at the very least, you need to

a. demonstrate that you have done some research b. provide enough details to reproduce your problem c. be very explicit with your questions