# How do I install sqlite3 on Windows, no really!?

**URL:** <https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661>\
**Category:** Ruby\
**Created:** [June 6, 2009, 1:40pm UTC](https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661 "2009-06-06T13:40:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![maz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e9c0ed/32.png) [@maz](https://www.ruby-forum.com/u/maz)\
**Post date:** [June 6, 2009, 1:40pm UTC](https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661/1 "2009-06-06T13:40:58Z")

</div>

Before someone comes in and says “this has been covered before,” I know  
people _think_ that it has been covered before but that isn’t helping me  
now. People have been saying that all you have to do is use the  
previous  
version like so:

gem install sqlite3-ruby -v=1.2.3

```
...however, this isn't working for me. The error I get... is 

```

exactly  
the same error you would get if you didn’t bother specifying a version  
number. It looks like this is not the right syntax since it tries to  
install 1.2.4. However, I can’t for the life of me figure out what the  
correct syntax for this command is 'cause every combination I’ve tried  
does  
exactly the same thing!  
So, how do I install this crazy thing on Windows, no really?!  
Thank you…

---

<div class="post-metadata">

**Author:** ![maz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e9c0ed/32.png) [@maz](https://www.ruby-forum.com/u/maz)\
**Post date:** [June 6, 2009, 8:42pm UTC](https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661/2 "2009-06-06T20:42:59Z")

</div>

> gem install sqlite3-ruby -v=1.2.3
> 
> ```
> ...however, this isn't working for me. The error I get... is 
> 
> ```
> 
> exactly  
> the same error you would get if you didn’t bother specifying a version  
> number. It looks like this is not the right syntax since it tries to  
> install 1.2.4. However, I can’t for the life of me figure out what the  
> correct syntax for this command is 'cause every combination I’ve tried  
> does  
> exactly the same thing!  
> So, how do I install this crazy thing on Windows, no really?!  
> Thank you…

You might need -v=1.2.3 --platform=mswin32 (?)

> **[how to install sqlite3 from source on ruby mingw (1.8 or 1.9)](http://programming-gone-awry.blogspot.com/2009/05/how-to-install-sqlite3-binaries-on-ruby.html)**
>
> here they are, inspired by a question from Charles Roper 1) install wget or curl in path 2) install unzip.exe (http://gnuwin32.sourceforge.n...

might help.  
Cheers!  
-=r

---

<div class="post-metadata">

**Author:** ![maz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e9c0ed/32.png) [@maz](https://www.ruby-forum.com/u/maz)\
**Post date:** [June 6, 2009, 9:00pm UTC](https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661/3 "2009-06-06T21:00:33Z")

</div>

“Just Another Victim of the Ambient M.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote  
in message news:mwsWl.62105$removed\_email\_address@domain.invalid…

> install 1.2.4. However, I can’t for the life of me figure out what the  
> correct syntax for this command is 'cause every combination I’ve tried  
> does exactly the same thing!  
> So, how do I install this crazy thing on Windows, no really?!  
> Thank you…

```
I figured it out!
I coincidentally had an sqlite3-ruby-1.2.4.gem file in the working

```

directory so gem must have been loading it regardless of what version I  
specified. Interesting…

---

<div class="post-metadata">

**Author:** ![maz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/e9c0ed/32.png) [@maz](https://www.ruby-forum.com/u/maz)\
**Post date:** [June 6, 2009, 9:41pm UTC](https://www.ruby-forum.com/t/how-do-i-install-sqlite3-on-windows-no-really/169661/4 "2009-06-06T21:41:36Z")

</div>

On Jun 6, 8:35 am, “Just Another Victim of the Ambient M.”  
[removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> install 1.2.4. However, I can’t for the life of me figure out what the  
> correct syntax for this command is 'cause every combination I’ve tried does  
> exactly the same thing!  
> So, how do I install this crazy thing on Windows, no really?!  
> Thank you…

You without providing more information about your ruby environment is  
not helping us help you.

running “gem env” or at least tell the Windows version, the version of  
ruby or _something_ to help you.

[http://catb.org/esr/faqs/smart-questions.html](http://catb.org/esr/faqs/smart-questions.html)

Anyhow, and even you don’t like it, this has been covered in the list,  
Google is your friend and you could get results form ruby-talk and  
stack overflow about this issue.

You just need to start providing more information than “it just  
fails”. That is like going to a doctor and saying “it hurts”, without  
giving more details.
