RFE: Consider using an ORM to support databases other than Postgres about commentoplusplus HOT 6 OPEN

Happy new year! 😄

I completely agree we should move to an ORM, this would definitely help increase where commento can run!

Currently, the only things holding this back from the original commento are:

• Reliance on pgsql features like triggers
• A folder full of migrations to help upgrade older versions of commento
• Hardcoded SQL statements in the /api folder

I will think about how best to address all of these!

from commentoplusplus.

Awesome, thank you for outlining the work and the willingness to look into the various pieces. I understand these are all significant pieces of work however, so no pressure!

from commentoplusplus.

I too would love to help in some way to support mysql. All my other services use MySQL, they also support postgresql, all except one. And the chances of Ghost supporting postgresql are .... not likely, especially since it looks like they dropped support for it a few versions back.

from commentoplusplus.

I would love to see this. SQLite support in particular would open up hosting options a lot; would be much simpler to host serverless, etc... I know this is only a small part of the work, but SQLite does support triggers.

from commentoplusplus.

I guess step one would be to choose an ORM?

from commentoplusplus.

Possibly, although it may make more sense to wait until there's someone willing to work on this, since they may have a strong opinion on which ORM they want to use. :-)

from commentoplusplus.