docs: document on how to run OMC with SQLite #759
Assignees
Labels
Comments
schu
added a commit
that referenced
this issue
Apr 14, 2024
There doesn't seem to be a way to configure SQLite pragmas like `journal_mode=WAL` from Laravel's database config (if there is a better way, please let us know). Therefore, configure the SQLite database in the `AppServiceProvider` upon boot. More infos on `journal_mode=WAL` and relevant pragma knobs for performance can be found under the links below: https://www.sqlite.org/pragma.html#pragma_journal_mode https://phiresky.github.io/blog/2020/sqlite-performance-tuning/ Resolves #759 (I think..)
schu
added a commit
that referenced
this issue
Apr 14, 2024
There doesn't seem to be a way to configure SQLite pragmas like `journal_mode=WAL` from Laravel's database config (if there is a way, please let us know). Therefore, configure the SQLite database in the `AppServiceProvider` upon boot. More infos on `journal_mode=WAL` and relevant pragma knobs for performance can be found under the links below: https://www.sqlite.org/pragma.html#pragma_journal_mode https://phiresky.github.io/blog/2020/sqlite-performance-tuning/ Resolves #759 (I think..)
schu
added a commit
that referenced
this issue
Apr 15, 2024
There doesn't seem to be a way to configure SQLite pragmas like `journal_mode=WAL` from Laravel's database config (if there is a way, please let us know). Therefore, configure the SQLite database in the `AppServiceProvider` upon boot. More infos on `journal_mode=WAL` and relevant pragma knobs for performance can be found under the links below: https://www.sqlite.org/pragma.html#pragma_journal_mode https://phiresky.github.io/blog/2020/sqlite-performance-tuning/ Resolves #759 (I think..)
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Using SQLite as database is only a matter of settting
DB_CONNECTION=sqlitein the.envconfig, but it's not clear from the Laravel documentation if additional configuration is needed to enable WAL mode and other parameters relevant for performance. We should document this.The text was updated successfully, but these errors were encountered: