Hello all
I'd like to change the journal mode on the Sqlite database that I'm
connecting to.
Looking at `connection_pragmas in the shared sqlite adapter, it doesn't
seem to be supported though.
Can I access the underlying Sqlite3 db object somehow and do it there
directly? Is there a reason I'm not aware of why it isn't supported?
For reference, here's what I'm doing on the bare SQLite3 connection:
SQLite3::Database.new("data.db") do |db|
db.foreign_keys = true
db.journal_mode = 'wal'
db.synchronous = 'normal'
db.locking_mode = 'normal'
db.auto_vacuum = 'incremental'
db.temp_store 'memory'
db.create_function('ulid', 0) do |func|
func.result = ULID.generate
end
end
Thank you all
immi
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/12dadfc6-5154-458b-8437-a400ce0cd353n%40googlegroups.com.
