Open mechanarchy opened 2 years ago
We haven't tested any other DBs so we can't really say anything in our docs about them. But if you do test it out let us know how it works out and we can build on that.
I did a brief look through the code and unfortunately in its current state I'm not able to try it out, as the database connection type
is hard-coded to mysql
. Can you please expose an environment variable for these?
Ah, don't bother. There are hard-coded migrations which use non-portable MySQL specific syntax: https://github.com/standardnotes/auth/blob/60db98c90910a33e0dfe0ed30303a4fe5dfb708e/migrations/1606470249553-init_database.ts#L6-L8
Evidently the project will be locked to MySQL for some time yet.
The official docs only mention MySQL as a database storage engine. Mo has also hinted that AWS RDS is a suitable target:
In my case, I am already running a PostgreSQL server in my stack and would prefer to consolidate Standard Notes onto that, if it is supported or even just "unsupported but shouldn't break". It would also be nice to have a couple of extra sentences on the official docs link above mentioning other common database technologies (even if they're unsupported) for clarity.
What is the status of other DB backends with Standard Notes?