crate/crate_ruby

A Ruby client library for CrateDB.

crate_ruby's Issues

Missing batch in the Gem

I noticed that in the gem 0.0.8, the following command does not work:

    bulk_args = [
  [1, "Post 1", {:street=>'1010 W 2nd Ave', :city=>'New York'}, ['foo','bar']],
  [2, "Post 2", {:street=>'1010 W 2nd Ave', :city=>'San Fran'}, []]
]
  @client.execute("insert into my_table (id, name, address, tags) VALUES (?, ?, ?, ?)", nil, bulk_args)

At the contrary, on the github version, this bulk command works as expected.

I would like to use this action, but I don't know if the last version of this crate_ruby is enough stable.
Will you deliver a new stable version of this gem soon?

[HELP] Running new releases

Hi @autophagy and @chaudum,

we would like to run new releases for crate_ruby [1] and activerecord-crate-adapter [2]. Can I humbly ask you to assign me [3] as a co-owner for both projects on RubyGems.org?

With kind regards,
Andreas.

/cc @hammerhead

[1] https://rubygems.org/gems/crate_ruby
[2] https://rubygems.org/gems/activerecord-crate-adapter
[3] https://rubygems.org/profiles/amotl

Use multiple connections

Hey,
At the moment, this gem only uses the first server from the array we pass, I think it would be very useful to use all of them because sometime under heavy load or when running a lot of request in a short duration, queries ended up failing.
I think it's not because the cluster cannot process the request but simply because of HTTP requests saturation.

I'm willing to work on a patch for this but I'd like your approval first ; mostly to know if it's recommended to run queries directly on secondary nodes while queries are running on the primary. I'm pretty sure it works, but I'm not sure it's recommended.

What I have in mind right now (didn't start coding anything):

• Retry on a different server if request fails
• Simple load balancing (round roaming)
• (Maybe) Advanced load balancing depending on the individual load of each node of the cluster (if possible)

Let me know what you think,
Cheers,

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Clarify purpose of this driver vs. generic PostgreSQL driver

Hi there,

this driver is clearly to consume CrateDB's HTTP API, this should be reflected better within the README document. I think it still has purpose, providing some highlevel DDL-related API methods, as well as a wrapper interface around BLOB tables.

On the other hand, we may want to advise the community to use a generic PostgreSQL driver for regular use with Ruby. Can you recommend a corresponding driver, @hammerhead? Would ruby-pg be the right choice?

See also:

• crate/activerecord-crate-adapter#19

With kind regards,
Andreas.

/cc @seut

Object Relational binding like AR or Mongoid?

Are you going to support OR bindings like AR or maybe something similar to Mongoid?