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

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

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

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

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

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: How to handle boolean in literal where clauses with squel 5.28

Jeremy, thanks for your response. I created a minimal self-contained example in the attached file. I do not manage to perform it does work with ruby 1.9.3, having sequel 4.49 where it produces P:\OptigemBridge\obdev\80_sequel-tests>ruby testwithmdb.rb all data unfiltered --- {:I

Can I alias the join table with association_join?

I have a model association through join table. When using `association_join` with the association multiple times, Sequel will append `_[integer]` to the join table; e.g. `joined_table...joined_table_0`. Is is possible to alias each instance of the join table without explicitly declaring each jo

Re: How to handle boolean in literal where clauses with squel 5.28

On Tuesday, January 14, 2020 at 2:42:30 PM UTC-8, Bernhard Weichel wrote: > > Jeremy, thanks for your response. > > I created a minimal self-contained example in the attached file. > I do not manage to perform > > it does work with ruby 1.9.3, having sequel 4.49 where it produces > > P:\OptigemBri

Re: Can I alias the join table with association_join?

On Tuesday, January 14, 2020 at 2:53:23 PM UTC-8, Shane Cavanaugh wrote: > > I have a model association through join table. When using > `association_join` with the association multiple times, Sequel will append > `_[integer]` to the join table; e.g. `joined_table...joined_table_0`. Is is > poss