SQLite3 fat GEM for ruby 2.5 on Windows

[sroller]

Hi, may I asked whether there will be a gem which contains the binaries for ruby 2.5 on Windows?
I can install the gem but a ruby script fails to load the extension.
After I remove the failing gem I can install using the following command

ridk exec pacman -S mingw-w64-x86_64-sqlite3
gem inst sqlite3 --platform ruby

which installs the gem from source, similar to *ix platforms.

[MSP-Greg]

I've created a system to build fat-binary gems on Appveyor, and I just built fat-binary gems for Ruby versions 2.0 thru 2.5, and all versions (both 32 & 64) pass all tests. They are available as artifacts at:

https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/build/3

One can install downloaded gems with the following (-N is no-doc, -l is local):

gem install <full path to gem> -Nl

Note: The gems are built with the current repo master, and also with SQLite version 3.24.0 (2018-06-04).

I build & test stuff, I've never coded with SQLite, and I don't know whether version 3.24.0 is an issue or not.

Hence, not for production apps, but any feedback would be helpful.

Thanks, Greg

[MSP-Greg]

In PR #237, I Integrated fat-binary gem construction in to Appveyor testing. See notes there.

[pddzaic]

Would it be possible to build a new gem with the current sqlite-version 2.25.2?

[duerst]

@MSP-Greg: Many thanks for always working on Ruby and Windows integration. Just a short question: Is a fat gem now actually available, or did you just provide the code for testing? I went to https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/build/3, but didn't see any way how I could download an actual fat gem (maybe a silly question, sorry).

[MSP-Greg]

@duerst

No problem. Being somewhat familiar with Appveyor's UI, I probably haven't left the best directions.

So, let's start at the history page:
https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/history

click the most recent (top) built, which today brings you to a log page (I only did a single job 64 bit build for this one):
https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/24787784

click on 'artifacts'
https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/24787784/artifacts

you should then see two files listed, one is the gem, one is a archive of the test logs.

I added a tag to the gem name, this one is sqlite3-1.4.0.mspgreg-x64-mingw32.gem

I think a direct download link is:
https://ci.appveyor.com/api/buildjobs/yig1yxnoe6pfluou/artifacts/sqlite3-1.4.0.mspgreg-x64-mingw32.gem

Once you've downloaded the gem, install it by using the full path to it:

gem install <path>/sqlite3-1.4.0.mspgreg-x64-mingw32.gem

The gem is build for Ruby 2.2 thru trunk, 64 bit. Note the bottom of the log
https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/24787784#L2572
showing all tests passing.

I'm not a strong c type, this last build is statically linked against sqlite3, so one doesn't need any additional dll's.

Also, this is the build/test code system I mentioned in https://bugs.ruby-lang.org/issues/15851

[MSP-Greg]

@duerst

Apologies, as I didn't ask what version of Ruby you wanted to use with SQLite3. I just ran the CI again and updated the links in the above comment. The previous gem did not work with trunk (2.7), the new one does (Ruby 2.2 thru 2.7 64 bit).

[Xm4s]

@MSP-Greg I know this is an old thread, but please bear with me.

I've downloaded the latest gem I found (this one - https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/36746136/artifacts), which seems to work for Ruby 2.2 thru 2.6 and 3.0, but not for Ruby 2.7, which is actually the version I need.

May I ask for you help?

[MSP-Greg]

@Xm4s

Years ago, I was introduced to Ruby via a program called SketchUp. I still participate in the SketchUp forum, but don't actively use it. I have pre-compiled SQLite3 gems at:

https://github.com/MSP-Greg/SUMisc/releases/tag/sqlite3-mingw-1

Note that the newest release (1.4.2) doesn't support all Rubies, but does support 2.7. See the notes.

Appveyor doesn't have Ruby 2.7 installed, and the MSYS2 system can be out-of-date. so I compiled these locally. My desktop is a lot quicker than the AppVeyor CI systems...

[Xm4s]

@MSP-Greg

Thank you for your answer.

SketchUp is the reason why I'm asking for the pre-compiled SQLite3 gem, since the 2021 release I was not able to load the sqlite driver successfully in a plugin I'm maintaining.

I'll try with the versions you linked, let's see if one of them does the trick.

[Xm4s]

@MSP-Greg

I can confirm that everything worked as expected, I was able to install the gem under SketchUp and then embed it in my plugin, which now works like a charm.

I did go with SQLite3 gem 1.4.2 since Ruby 2.7 is the only one I care about for the latest version of SketchUp.
It's also nice to have the support for a future update to Ruby 3.0 already available.

Considering the time of the year I would say that this is nothing short of a Christmas miracle, so I really mean it we I say thank you for your support 😌

Have a Merry Christmas and a Happy New Year.

[MSP-Greg]

@Xm4s

Glad it worked for you.

All of the pre-compiled gem's sqlite3_native.so files are compiled with MinGW. I just got a new desktop, so I'm busy with WSL2/Ubuntu, etc, but sometime I may compile 2.7 and later with mswin. I'll post info about any updates in the SketchUp forum message thread '[How to] install SQLite3 in Windows SketchUp'

The gem files will remain in the same GitHub release.

Merry Christmas and a Happy New Year to you! Greg

[flavorjones]

We're working on shipping precompiled native gems as well as increasing test coverage for people who want to use system libraries. If you're curious please follow #320.