Which database type should be supported first in Vontigo CMS?

[Smilefounder]

Hello everyone,

As you know, we're currently working on adding support for database types in Vontigo CMS. However, we're unsure which database types to prioritize and which ones our community would prefer. We'd like to get some input from you to help us determine which database types to support first.

We are supporting SQLite at the moment. However, in the long term. I'm thinking about which one will be the best for most scenarios, solutions, and users at the moment. So that we can focus on. MySQL is nice and easy for everyone, But PostgreSQL is also strong in vector DB which might help us later for AI data.

Thank you for taking the time to provide us with your input. Your feedback will help us make Vontigo CMS even better!

Best regards,
Vontigo team.

[Smilefounder]

I have found that Vercel now supports PostgreSQL (https://vercel.com/docs/storage/vercel-postgres).

This is also a piece of good news for us. I still really want to have Vontgo setup step easy as possible as we can. Something like 1 click install like our current setup with SQLite and without too many configuration steps for non-tech blog owners, but more powerful than SQLite.

Btw, Postgresql is nice for realtime db (for example what they have done in Supabase).

[Smilefounder]

FYI, after giving it a try, it's working quite well. As no more vote at the moment. I have decided to go with PosgreSQL as it powerful, free, fast and easy to scale for long term.

MySQL will be my 2nd option later once we are all good with PostgreSQL. Any contribute regarding MySQL adapter is welcome.

Cheers!

[Smilefounder]

Vercel's postgresql version can be preview here: https://vontigo.vercel.app/