[ndstephens]

This looks great!! Hopefully you can answer a couple questions for me.

You mention you're using TablePlus. Doesn't look like it has a free option. Can you recommend another similar database GUI tool so I can "code along"? And is there a database I can connect to and work with? Maybe you answer these at some point in the course, but I didn't see anything in the intro.

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? Or is this for a dev to work against a db that fully created and maintained by a DBA? I'm interested in using PlanetScale for hobby projects, so i'm currently trying to learn about not just using a db, but also being my own DBA (on a very small and basic scale).

Thank you for the course and any feedback on my questions.

[pritambarhate]

Never used or heard about TablePlus, so don't know how it compares but I have been using https://dbeaver.io/ community edition for years now and it's my go to tool for interacting with relational databases. Highly recommended.

[aarondf]

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.

[saluki]

Table Plus (Free Trial Version) What are the limitations of the free trial? The free trial is limited to 2 opened tabs, 2 opened windows, 2 advanced filters (filters are not available on the free TablePlus Windows) at a time. We can change the limitations without any notifications in the future releases.

[ndstephens]

Maybe i'm reading into their naming incorrectly. Free "trial" to me sounds like it's time based...as in after a week you can no longer use it and must buy. I'll give it a try.

[tough]

It's not time based, only feature based, if you don't need lots of open tabs you can survive it it's only a bit annoying

Beekeeper Studio similarly has a (community edition) and it's GPLv3 licensed

[ndstephens]

thanks for the recommendation. will check it out