Ruby - SQLite3 - set pragmas from code -
i using ruby sqlite3
(1.13.11) on macos (ruby 2.0.0-p247) create few databases application. need set pragmas, not sure doing right thing. set pragma synchronous = off
db = sqlite3::database.new("test.db") db.synchronous 2 db.synchronous = 0 db.synchronous 0
this seems work, when open test.db
db browser sqlite
, synchronous
still set full
.
i have tried
db.execute("pragma synchronous = off")
with same result.
is synchronous
associated connection? case pragmas
?
Comments
Post a Comment