support supplying hooks when opening connections (fixes #3)
To support setting SQLite pragmas when opening a connection, we add the following:
- 2 new functions added:
openWithandcreateSqlitePoolWith. Which will receive a connection string and an additional parameter:[SQL], to execute after establishing a connection. - A change to
createSqlitePool- will, by default, set thebusy_timeoutto30000ms, to avoid "database locked" errors, and will set the "foreign_keys" to true, to enforce foreign key constraints.
Edited by gilmi