extralite icon indicating copy to clipboard operation
extralite copied to clipboard

Add default pragma values for newly opened databases

Open noteflakes opened this issue 1 year ago • 1 comments

Some sensible defaults here: https://gcollazo.com/optimal-sqlite-settings-for-django/

# define pragmas manually
Extralite.default_pragmas = {
  ...
}

# one possibility for letting extralite manage it
Extralite.modern_settings!

# another, somewhat better possibility:
require 'extralite/sensible_default_pragmas'

noteflakes avatar Jun 13 '24 07:06 noteflakes

Minus the temp_store setting, these are exactly the defaults that @oldmoe and I recommend and are now default in Rails:

https://fractaledmind.github.io/2023/09/07/enhancing-rails-sqlite-fine-tuning/ https://github.com/rails/rails/pull/49349

fractaledmind avatar Jul 05 '24 10:07 fractaledmind