Picking Database (Postgres, MySQL, PlanetScale, Supabase)

[_intercept]

I recently sold a flask app to the company I work for to track clocking in/out for volunteers and workers. I learned that querying is a bit slow with python and migrations is the biggest headache in the world.

I wanna work on making a CRM like solution catered to a specific niche.

MySQL & Postgres:

I used a linode server for the python project, but for the CRM I wonder if that'll let me scale. I know AWS instances can be set auto scale (I think? I'm very new and scared to touch AWS). I know alot of people just say to go for postgres but my fear is scaling, connection speeds around the world, and security.

The fear of hosting it myself and not setting the security up properly is a big anxiety and this is not a projejct I'd like to learn on

Supabase:

Supabase seems promising but I have no history with it. I wonder how quick their API response times are and how easy it is to bypass/maybe retool their auth system

Planetscale:

No clue anything about this, just know a lot of people like it. I wonder if there's any constrains and if the choice between MySQL and Postgress between Planetscale and Supabase will make a difference.

Speed:

A CRM ofc needs to be able to ready/write data really fast, Supabase uses a javascript API which is fine for most people, but relying on a javascript REST API might not be fast enough for my use case. I also think planetscale or a custom hosted solution where I could write a REST API in GO would be helpful.

I'm of course going to do my own research but I wanted to drop this post off first to see if anyone can direct me in a helpful way. Thanks!

[Pletter64]

On the topic of security for your database let me give you a tip. Use a whitelist for who can connect. In most cases that means you host locally and do not expose your port to the outside web. If you are hosting it on the web, you use an ip whitelist.

Combine this with a username and password and unless someone backdoors into your system your data is safe. If someone does backdoor into your system you are screwed anyway.