search

digital-fabric / extralite

Ruby on SQLite
http://www.rubydoc.info/gems/extralite
MIT License
253 stars 8 forks source link

What happened to the Sequel adapter? #9

Closed sixtyfive closed 1 year ago

sixtyfive commented 2 years ago 
require 'extralight'
require 'sequel'
DB = Sequel.connect 'extralight://db.sqlite3'
table = DB[:some_table]

... alas ...

Sequel::AdapterNotFound: LoadError: cannot load such file -- sequel/adapters/extralight

used to work but now not so anymore, and https://github.com/jeremyevans/sequel/tree/master/lib/sequel/adapters matches that...

sixtyfive commented 2 years ago

Whoops, my bad. Bad, bad typo. Sorry!!!

Funny enough I now learned that for some reason sqlite:// is faster at getting records out of a 23GB database than extralite:// is.

noteflakes commented 2 years ago

Can you include some code to show what you are doing? I'd like to investigate this.

sixtyfive commented 2 years ago

Oh, you mean with regard to the speed thing, @ciconia ?

noteflakes commented 2 years ago

Sorry for the late reply, yes I'm talking about the speed thing.

sixtyfive commented 2 years ago

Hi, no worries, but now it's for me to say sorry as I can't replicate what I thought I had seen a week ago. Here's what I'm doing with that 23GB database file, anyways:

https://gist.github.com/sixtyfive/83ed7504523e5ecb849375fd224168f0

If I should run across any behaviour again where extralight ends up being the slower adapter, I'll open a new Issue for that.