Support MySQL Database Backend

[srilman]

The database backends are all based on SQL queries "compiled" using SQLC to Go code. So it shouldn't be too difficult to add another support for MySQL on top of Postgres and SQLite. Would anyone be interested in this? I ask because the purpose of the current backends are:

• SQLite: Embedded local transient use
• Postgres: Hosted scalable use

MySQL would be an alternative to Postgres, but is it as popular? Are there popular database services based on MySQL? For example, Planetscale is one (https://planetscale.com/).

[derekperkins]

Very interested

[srilman]

Sounds good, can I ask what the situation is that needs or prefers MySQL? Just curious to learn more!

[derekperkins]

We're running Vitess (OSS behind Planetscale), that already has backups, management, etc. We wouldn't add Postgres / SQLite to our infra just for a REST catalog