(Feature request) Transition from SQLite database to MariaDB/Postgree

[miltuss]

Describe feature

Trilium is defined as a database that can contain large databases containing all kinds of information. But trilium uses sqlite which has countless limitations such as the size of stored files, data reading performance...

Why not use a MariaDB or Postgree database for trilium?

This could solve several problems on Trilium!

Additional Information

No response

[Nriver]

SQLite is good enough for personal use.

[meichthys]

This would better be addressed in TriliumNext if/when more collaborative features are added.

[miltuss]

SQLite is good enough for personal use.

Trilium is supposed to be the largest self-hosted knowledge base. You can't just ask for personal use.

Even for personal use, sqlite quickly reaches its limits, as you can't upload files over 250 MB.

[Nriver]

SQLite is said to be able to handle terabyte-level data. It's already overkill. All of your mobile phone apps use SQLite databases to store data. I believe it's well-tested for personal use.

However, it's not a good practice to store large single files in a database.

Trilium is not designed for large file storage. The limit of 250MB is set to protect your data. You can bypass it, but there is no guarantee everything will work.

[meichthys]

Trilium is supposed to be the largest self-hosted knowledge base.

Is this in our documentation somewhere?

[miltuss]

Trilium is supposed to be the largest self-hosted knowledge base.

Is this in our documentation somewhere?

[zadam]

As others mentioned, SQLite is good enough. Closing since this is not going to change.