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

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

Python Tornado package error when running server -

Qt QGraphicsScene is not accessable from QGraphicsView (on Qt 5.6.1) -