database - How to install SQLite on Windows? - Stack Overflow
SQLite User Forum: install sqlite on windows10
sqlite - How to "install" sqlite3 on my Windows 10 computer? - Stack Overflow
How do I install SQLite?
Do I need to install any additional software to use SQLite?
No additional software is required for basic SQLite usage. However, for enhanced functionality or graphical interfaces, you might consider using SQLite management tools like SQLiteStudio or DB Browser for SQLite
What is SQLite?
SQLite is a lightweight, disk-based database engine that doesn't require a separate server process. It is widely used for local storage in applications and is known for its simplicity and efficiency.
Where can I find documentation for SQLite?
You can find comprehensive documentation and resources on the official SQLite website: SQLite Documentation.
You can install SQLite on Windows so that you can use it on terminal(command prompt).
First, download the 3rd one saying A bundle of command-line ... from the website:
Then, unzip it, then get 3 files below, then put them in C:\sqlite\ which you need to create manually:
sqldiff.exe
sqlite3.exe
sqlite3_analyzer.exe
Then, search and click on Edit the system environment variables:
Then, click on Environment Variables...:
Finally, set C:\sqlite to Path in both or either User variables and/or System variables, then you can use SQLite on terminal(command prompt). *User variables are specific only to the currently logged-in user and System variables are globally accessed by all users:
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.
SQLite is an embedded database; it does not run as a separate server process, but is a library that is usually compiled directly into the application itself.
Running the sqlite3 command-line shell does not make sense, because the version of the SQLite library compiled into that is not necessarily related to the version compiled into the Ruby gem. The guide you linked to is wrong; just ignore that point.
(But if you want to test SQL queries outside of Ruby, there's nothing wrong with installing and running sqlite3.exe.)
You do not need to install the DLL manually; any program that needed it would already ship with it.
For how to test the SQLite Ruby gem, see the sqlite3-ruby documentation.
Guide of what a path is and how to add stuff to it it. You may also want to consider using PostgreSQL as many members of the community prefer it over the packaged sqlite3.
These guys are also right about Ruby development kind of sucking on non-Unix systems though so if you plan on getting into this you might want to consider dual booting a Linux OS for development. You'll probably save yourself a lot of bugs.