CODEWITHSUNDEEP
windowssqlite
Nerret RAISE
Nerret RAISE

Reputation: 29

How to "install" sqlite3 on my Windows 10 computer?

So I wanted to get started on Ruby on Rails because it sounds like fun but as I reached part 3.1 over here I ran into some problems.

First I just attempted "sqlite3 --version" in the "ruby cmd" and it came up with: "'sqlite3' is not recognized as an internal or external command, operable program or batch file." So I attempted to just install the sqlite ruby gem and it did that just fine but as I typed "sqlite3 --version", same story. So I just figured you needed to install the thing your self.

So after I downloaded the "Precompiled Binaries for Windows" (64-bit DLL (x64) for SQLite version 3.11.1.) over here I moved the .dll and .def files to my system32 folder, launched CMD as admin and typed regsvr32 sqlite3.dll I get this error message: "The module "C:\WINDOWS\System32\sqlite3.dll" was loaded but the entry-point DIIRegisterServer was not found. Make sure that "C:\WINDOWS\System32\sqlite3.dll" is a valid DLL or OCX file and then try again.

I did a lot of googleing and talked with microsoft support and nothing helped. So im hopeing someone can help me out here. Thanks in advance :)

PS: My PC is "Windows 10 pro" 64 bit. If it matters.

Upvotes: 2

Views: 10638

Answers (2)

CL.
CL.

Reputation: 180020

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.

Upvotes: 3

SomeSchmo
SomeSchmo

Reputation: 665

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.

Upvotes: -1

Related Questions