# Error While loading sqlite3 in ruby

**URL:** <https://forums.sketchup.com/t/error-while-loading-sqlite3-in-ruby/94189>\
**Category:** Developers\
**Tags:** ruby, database\
**Created:** [April 27, 2019, 1:09am UTC](https://forums.sketchup.com/t/error-while-loading-sqlite3-in-ruby/94189 "2019-04-27T01:09:17Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![MSP\_Greg](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/msp_greg/32/206066_2.png) [@MSP\_Greg](https://forums.sketchup.com/u/MSP_Greg)\
**Post date:** [May 2, 2019, 6:25pm UTC](https://forums.sketchup.com/t/error-while-loading-sqlite3-in-ruby/94189/13 "2019-05-02T18:25:32Z")

</div>

@susketch17

Please see [Installing ruby gems in Sketchup - #19 by MSP\_Greg](https://forums.sketchup.com/t/installing-ruby-gems-in-sketchup/3787/19)

That message refers to installing another gem. Ignore step #1, as the dll issue doesn’t affect sqlite3.

As to the gem, it is located at:  
[https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/24263868/artifacts](https://ci.appveyor.com/project/MSP-Greg/sqlite3-ruby/builds/24263868/artifacts)

titled:  
sqlite3-1.4.0.mspgreg-x64-mingw32.gem

It needs to be downloaded.

So, once you have the gem and `su_utils.zip` downloaded & extracted, in the SketchUp Ruby console::

```ruby
require '<path>/su_gem.rb'

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

```

You should be able to use SQLite3 with SU2019 or SU2017/18.

The gem is compiled statically with SQLite3, so no ‘DevKit’ or additional installation is needed.

---

_[View the full topic](https://forums.sketchup.com/t/error-while-loading-sqlite3-in-ruby/94189)._