News for hackers. Stuff that matters.
Re:Learn Postgres at the Playground – Postgres compiled to W... by afavour on Wednesday August 17, 2022 @01:40PM (#32499430)
1000%. Lots of people want to do data analysis, learn SQL, all that kind of stuff, without having to learn a load of other unrelated development crap. Think of all the people out there using Excel who want to take the next step.
Re:Learn Postgres at the Playground – Postgres compiled to W... by l2k34j1l2k34jj1 on Wednesday August 17, 2022 @10:01PM (#32504323)
After browsing this site for a couple of years, I made an account to reply to your comment and say, "This is exactly right" lol. I'm a teacher who uses Excel for basic stuff (power query, pivot tables), but I'm also using Excel as a "database", which is obviously not a good idea.

So here I am trying to take the next step and learn SQL along with good database design, but learning these things through Postgres is really not appropriate for someone like me. I think I have to swallow my pride and start with Access or something.

Re:Learn Postgres at the Playground – Postgres compiled to W... by konart on Thursday August 18, 2022 @12:11AM (#32505173)
You may want to try https://dbeaver.io/ + SQLLight for the start.

You just download binary for your OS, create a db as described here (https://www.sqlite.org/quickstart.html) and then connect to it with dbeaver.

This is more the enough to get familiar with SQL.

Re:Learn Postgres at the Playground – Postgres compiled to W... by afavour on Thursday August 18, 2022 @09:44AM (#32509475)
No shame in using Access! It's actually part of how I got my start in tech. Started with an Access database, started writing macros for it in VBA, then started writing VB.NET, then convinced a higher up to give me access to a SQL Server database.

I was in an industry with an absurd number of boilerplate forms that needed to be printed and the ability to create Access forms that automated all the manual filling out coworkers were doing felt like magic. Postgres doesn't really have an equivalent of that.