elixir-sqlite / exqlite

An SQLite3 driver for Elixir
https://hexdocs.pm/exqlite
MIT License
217 stars 48 forks source link

Allow setting custom pragmas #229

Closed adri closed 1 year ago

adri commented 1 year ago

This allows for someone to set any PRAGMA keys and values, next to the most common ones. See the documentation for a full list: https://www2.sqlite.org/draft/pragma.html

One use-case is to set the cipher_compatibility PRAGMA which is supported by the SQLCipher extension: https://www.zetetic.net/sqlcipher/sqlcipher-api/#cipher_compatibility

Fixes #227

warmwaffles commented 1 year ago

I swear I'll get to this soon. I've got another bit of work for ecto_sqlite3 I need to knock out and then will refocus on this today.

adri commented 1 year ago

Thank you so much!