sequel-xtdb

Adapter to connect to XTDB v2 using Sequel.

Install the gem and add to the application's Gemfile by executing:

bundle add sequel-xtdb

If bundler is not being used to manage dependencies, install the gem by executing:

gem install sequel-xtdb

Shortcut to happiness:

# Get a Ruby console using the sequel CLI
$ sequel 'xtdb://localhost:5432/xtdb'

# ..or from repl/your project
DB = Sequel.connect("xtdb://localhost:5432/xtdb")

# then
irb(main)> DB << "insert into products(_id, name, price) values(1, 'Spam', 1000), (2, 'Ham', 1200)"
irb(main)> DB["select * from products"].all
=> [{:_id=>2, :name=>"Ham", :price=>1200}, {:_id=>1, :name=>"Spam", :price=>1100}]

def shift_days(n, from: Time.now)= from + (60 * 60 * 24 * n)
DB = Sequel.connect("xtdb://localhost:5432/xtdb")

# get a dataset (ie query)
users = DB[:users]
ds1, ds2 = users.as_of(valid: shift_days(-2)), users.as_of(valid: shift_days(2))

# expect empty
ds1.all
ds1.insert(_id: 1, name: "James")

# expect a user
ds1.as_of(valid: shift_days(-1)).all

# add to future
ds2.insert(_id: 2, name: "Jeremy")

# expect only James
users.all
# expect both James and Jeremy
ds2.as_of(valid: shift_days(3)).all

Very early days :)

After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests.

You can also run bin/console [xtdb-url] for an interactive prompt that will allow you to experiment. The script will pick up on env-var XTDB_URL, though the argument takes precedence. The console-script sets up (query-)logging.

Speaking of logging: best to start the XTDB docker container with debug-logging:

docker run -it --pull=always -e XTDB_LOGGING_LEVEL=debug -v $PWD/tmp/db:/var/lib/xtdb -p 6543:3000 -p 5432:5432 ghcr.io/xtdb/xtdb:nightly

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and the created tag, and push the .gem file to rubygems.org.

Bug reports and pull requests are welcome on GitHub at https://github.com/eval/sequel-xtdb.

The gem is available as open source under the terms of the MIT License.