(Feature request) Other databases

[kamuridesu]

Describe feature

Now that the project has changed from hands, I wonder if other databases like MySQL or PostgreSQL will be supported. This was discussed at zadam/trilium#174, where the author said he wouldn't add it because it would mean more work.

Additional Information

No response

[TC218]

The TriliumNext SQLite code can be refactored by using Sequelize, an ORM for modern Node.js:
https://github.com/sequelize/sequelize

• and then it's easy to change underlying database

[eliandoran]

@TC218 , if you're willing to have a go at it, PRs are welcome.

On my side I don't expect to be working any time soon on this feature since I believe there are higher priority tasks soon such as supporting multiple SQLite database files and the work-benefit ratio is rather low.

[TC218]

@eliandoran not interested into that.

@kamuridesu why you need this feature ?

[kamuridesu]

@TC218 I run trilium inside a Kubernetes cluster, so I have some options to setup it:

1. Use a PersistentVolume and mount it to the pod, syncing the folder across all my nodes (that's what i'm doing rn)
2. Mount a NFS storage to the pod
3. Run the pod in a specific node only

None of those options are really great and as I do already have postgresql deployed with redundancy and backups it would take a lot less work to deploy trilium or make backups.

[shutaozhenzhen]

Also can we run trilium without any db, just pure folder and file?
Or have such a dir sync with db

[eliandoran]

@shutaozhenzhen , unfortunately that would not be possible. A lot of Trilium features relies on a database such as being able to place the same note into multiple directories, or reordering notes (workarounds can be found, but it would transform Trilium to the point it's a completely different application), or the search system.