feat: add support for `SQLite`

SychO9 commented 2 months ago

Part of the roadmap

Changes proposed in this pull request: Adds support for installing and using Flarum with SQLite 3.8.8+

While it is trivial to support it from core (apart from a couple exceptions where queries needed to be adapted), whether third party extensions will work with sqlite is a different matter. So I've added a warning about that on the installation page.

Screenshot

Necessity

[ ] Has the problem that is being solved here been clearly explained?
[ ] If applicable, have various options for solving this problem been considered?
[ ] For core PRs, does this need to be in core, or could it be in an extension?
[ ] Are we willing to maintain this for years / potentially forever?

Confirmed

[ ] Frontend changes: tested on a local Flarum installation.
[ ] Backend changes: tests are green (run composer test).
[ ] Core developer confirmed locally this works as intended.
[ ] Tests have been added, or are not appropriate here.

Required changes:

[ ] Related documentation PR: (Remove if irrelevant)
[ ] Related core extension PRs: (Remove if irrelevant)

SychO9 commented 2 months ago

is it possible to catch syntax errors, and in the error message, flag use of sqllite as a possible culprit?

Done in the pgsql branch

SychO9 commented 1 month ago

great idea @jaggy! will add that in the PgSQL PR which builds on top of this branch: https://github.com/flarum/framework/pull/3985

SychO9 commented 1 month ago

added in https://github.com/flarum/framework/pull/3985#issuecomment-2152822982

flarum / framework

feat: add support for `SQLite` #3984