Document or define SQLite setup procedure

[zacwest]

Is your feature request related to a problem? Please describe.
It's possible to set up LinkAce using SQLite, for example in .env:

DB_CONNECTION=sqlite
DB_DATABASE=/path/to/db.sqlite

However, it is not possible to complete onboarding with SQLite.

Describe the solution you'd like
Add support for SQLite-driven databases during setup. Maybe add examples to e.g. env files.

Additional context
Some things I ran into while doing this:

You may need to touch the sqlite file, and you need to make sure both the file and its directory (so SQLite can create its wal, etc.) as writeable.

Getting an error during onboarding such as:

• 2002] No such file or directory
• 2002] Connection refused

You will need to skip the initial onboarding on /setup/database which doesn't allow you to go past. Manually navigating to the next step, /setup/account succeeds.

[Kovah]

Hi, thanks for trying LinkAce.
I will take a look into this, but is has no priority right now as I don't use SQLite.

[Kovah]

I updated the docs with a dedicated guide for SQLite.
https://www.linkace.org/docs/v1/setup/setup-with-sqlite/

[rogatty]

@Kovah thank you for adding the docs. I noticed there is one thing missing: DB_DATABASE=/app/database/database.sqlite. Without it, I was getting this error:

In SQLiteConnector.php line 34:

  Database (linkace) does not exist.

[Kovah]

Thank you! I've updated the docs.