Like you, I like ruby and working with sqlite via sqlite3 gem. So you have recompiled sqlite3 with the sessions extension. Correct? And this modified sqlite3 is the nearest sqlite3 available in your execution path. Correct? The sqlite_ruby library is an interface to sqlite3...the base model. Granted, I have no knowledge of the sessions extension, nor any extension for that matter. But I do not know how sqlite_ruby would have any language to the extended functionality; it is simply unaware of the bindings. If the functionality is available via function calls in the sql itself, have you tried executing the sql directly, i.e.:
conn = ActiveRecord::Base.establish_connection(adapter:'sqlite3',database:DB_NAME) conn.connection.execute(pragma_this_or_that) conn.connection.execute(your_sql_with_functions) Without you augmenting the sqlite3 gem and teaching it how to interact with the new functions, I don't know how your would accomplish what you are suggesting. dvn On Wed, Dec 7, 2016 at 12:07 PM, Will Parsons <varro@nodomain.invalid> wrote: > I don't usually see questions about using SQLite3 from Ruby here, so I > hope this is not out of place. > > Ruby is my normal programming language of choice nowadays, and I've > been very happy with the sqlite3 ruby gem to use SQLite3 within my > programs. I'd now like to make use of the SQLite3 session extension > under Ruby using the sqlite3 gem, but can't figure out how to do that. > > I'm currently using FreeBSD and have compiled sqlite3 with the > SESSION extension. > > I previously asked this question on stackoverflow: > > http://stackoverflow.com/questions/40875967/how-to-use- > sqlite3-session-extension-with-ruby > > and got the reply that no such support was available. I'm hoping that > someone here may have helpful advice. > > -- > Will > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
