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 -

reflection - How to access the object-members of an object declaration in kotlin -

php - Doctrine Query Builder Error on Join: [Syntax Error] line 0, col 87: Error: Expected Literal, got 'JOIN' -