Re: Asynchronous query to ODBC-compliant database, without waiting for results - possible?

2020-01-15 Thread Rebecca Paz
Mason, Jeremy, All this makes sense - I'll talk to my team about our options here. Sidekiq is also an attractive option since we do have Sidekiq workers already, so that might be our best bet if we can't get `ruby-odbc` to play nice with us. Thanks everyone! Rebecca On Tuesday, January 14, 20

Re: Asynchronous query to ODBC-compliant database, without waiting for results - possible?

2020-01-14 Thread Jeremy Evans
On Tuesday, January 14, 2020 at 10:21:28 AM UTC-8, Rebecca Paz wrote: > > Hello, > > We are interested in using Sequel to interface with Snowflake > , which is ODBC-compliant and can be > connected to as such: > > require 'odbc' > require 'sequel' > db = Sequel.odbc('S

Re: Asynchronous query to ODBC-compliant database, without waiting for results - possible?

2020-01-14 Thread Mason Kimble
Rebecca, You could make the Ruby api itself asynchronous using something like Rabbit MQ or Sidekiq. That's what I do to process web requests async and return documents later. https://www.rabbitmq.com/tutorials/tutorial-one-ruby.html https://github.com/mperham/sidekiq/wiki/Getting-Started Mason

Asynchronous query to ODBC-compliant database, without waiting for results - possible?

2020-01-14 Thread Rebecca Paz
Hello, We are interested in using Sequel to interface with Snowflake , which is ODBC-compliant and can be connected to as such: require 'odbc' require 'sequel' db = Sequel.odbc('SnowflakeDsnGoesHere') db.run('select 1;') db.disconnect We have a need to issue quer