Hacker News new | ask | show | jobs
by aarondf 1190 days ago
Hey there! Looks like the TablePlus question was answered below. I don't cover connecting to a database and coding along, but that's a good idea. I'll see if I can get the sample data up somewhere for y'all to download.

> Also you mention this is for devs and not DBA's. Do you go over strategies for creating and "maintaining" a new db for a basic app?

We do spend a lot of time talking about schema up front actually! What it takes to design good tables, what data types to use, and so on. I talk at the end of the schema section about migrations and how you can use those to keep your tables up to date as business requirements change over time.

I think if you use a hosted provider like PlanetScale, they (we) take care of a lot of the stuff that was traditionally the realm of the DBA, although maybe not all of it. I don't know exactly where to draw the DBA line to be honest.

Let me know if you have any other questions! Happy to help however I can.