Using Postgresql or Mysql with Ponzu

[koreset]

Hey there,
Stumbled upon Ponzu via CMS searches and I am impressed with the great work. One question though... How do I swop out the embedded DB with a db of my own (Postgresql or Mysql)?
Is there any extensive configuration or rework that I need to do to make this happen?
Would the system/db package be a good place to start?

[nilslice]

Hi @koreset -

Thank you for the kind words - I'm glad you found Ponzu and I hope it is useful to you!

We have had a bit of discussion on other issue threads about support for other databases, but there hasn't yet been any concrete work to start support. Currently, only the embedded BoltDB is supported, but as you mention, the system/db pkg is where you'd want to begin looking.

Also, there is currently no built in way to provide configuration options at runtime to the system except through the admin config in the UI, which is probably not how you want to provide DB host/user/password details. Just something to keep in mind in case you do start investigating how SQL database support could work.

I'd be happy to work with you on this, so please keep me updated with your ideas or thoughts.

Thanks!

[silbinarywolf]

Adding this related thread for reference:
#202

[olliephillips]

Closing this issue. No activity. Please reopen if need to.

[hubyhuby]

Hi @olliephillips ,
Thanks for this great work.
I am interested to know the status of this feature request.

With bolt, Ponzu is a good match for prototyping API.

Now if you want to get into production and scale, you need to scale the database.... and then get connected to things like mysql postgres or anything else ;)

Especially EVERY computer devs know SQL and can jump in your project with Mysql / postgres.
Using bolt is nice, but will retain Ponzu from beeing used by the many ...
Maintenance costs on real production apps will grow fast.

[olliephillips]

Hey @hubyhuby I can't take much credit for Ponzu my contributions don't amount to much. @nilslice is the man.

Re this feature, nothing has moved here. There's a general hiatus on submissions pending go modules support and improvements to the CI/CD piece. I don't know where that work is up to.

I would expect however that the work to implement support for a new DB would need help from the community and those that need this support. There are no plans to add further DB providers that I am aware of.