You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Using SQLite as database is only a matter of settting DB_CONNECTION=sqlite in the .env config, 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:
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_modehttps://phiresky.github.io/blog/2020/sqlite-performance-tuning/Resolves#759 (I think..)
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_modehttps://phiresky.github.io/blog/2020/sqlite-performance-tuning/Resolves#759 (I think..)
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_modehttps://phiresky.github.io/blog/2020/sqlite-performance-tuning/Resolves#759 (I think..)
schu
linked a pull request
Apr 15, 2024
that will
close
this issue
Using SQLite as database is only a matter of settting
DB_CONNECTION=sqlite
in the.env
config, 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: