sqlite

Connecting Ruby and SQLite with ADBC

Instructions

Prerequisites

1. Install Ruby

2. Install dbc

3. Install SQLite

   • On macOS, if you have Homebrew installed, run brew install sqlite

4. Ensure the native Arrow GLib and ADBC GLib libraries required by red-adbc are installed and discoverable. If bundle install reports missing arrow, arrow-glib, or adbc-glib, use the platform-specific commands below.

   macOS with Homebrew

   brew install apache-arrow-glib apache-arrow-adbc-glib

   Debian/Ubuntu

   sudo apt install libarrow-glib-dev libadbc-glib-dev

   RHEL-compatible distributions

   sudo dnf install arrow-glib-devel adbc-glib-devel

   Windows with RubyInstaller/MSYS2 UCRT64

   pacman -S --needed mingw-w64-ucrt-x86_64-arrow mingw-w64-ucrt-x86_64-arrow-adbc-glib

   If you use a different MSYS2 environment, adjust the package prefix to match it; for example, use mingw-w64-x86_64-* from the MINGW64 shell.

5. Install Ruby dependencies:

   bundle install

   If you have multiple Ruby installations, ensure ruby and bundle resolve to the same installation before running this command.

Connect to SQLite

1. Install the SQLite ADBC driver:

   dbc install --level user sqlite

2. Customize the Ruby script main.rb as needed

   • Change the connection options in database.set_option()
     • Set uri to the location of the SQLite database file you want to query, or keep it set to games.sqlite to use the database file included with this example
   • If you changed the database file, also change the SQL SELECT statement in connection.query()

3. Run the Ruby script:

   bundle exec ruby main.rb