Practical SQL
@practicalsql
Followers
324
Following
34
Media
16
Statuses
208
Tips on SQL, PostgreSQL, and news about the book "Practical SQL: A Beginner's Guide to Storytelling With Data" by Anthony DeBarros. Published by @nostarch.
Joined December 2017
-- my favorite way to run PostgreSQL on macOS -- is making it easier to add extensions to your environment. Really handy.
0
1
1
Newest versions of pgAdmin now let us customize the font in the Query Tool. Nice upgrade. Set here to MesloLGL Nerd Font:
0
2
5
RT @crunchydata: Postgres users love Common Table Expressions (CTEs) because they make complex SQL easy to read, create, edit, and reuse.….
0
6
0
RT @huangzworks: Anthony DeBarros' excellent book "Practical SQL" is now available in Chinese!🎆🎉 @anthonydb @practicalsql @nostarch https:/….
0
2
0
pgAdmin developers planning a version 9.1 release on Friday that addresses user concerns related to the new "Workspace" layout. Notably, they've restored the ability to see the server object tree while in the Query Tool, which was a must-have for many users.
Important note for new readers of Practical SQL! Today's release of pgAdmin v9.0 introduces a "Workspace" layout that's enabled by default. I've written instrux on how to set the layout back to "Classic," which matches the book and is, IMO, better.
0
1
1
Important note for new readers of Practical SQL! Today's release of pgAdmin v9.0 introduces a "Workspace" layout that's enabled by default. I've written instrux on how to set the layout back to "Classic," which matches the book and is, IMO, better.
0
2
2
I'm always humbled and grateful when this happens, which it has done a couple times (often coinciding with the start of college semesters). Thank you to all my readers!
0
3
1
To support students, career-switchers and others who want to add SQL to their data analysis skillsets in 2025, I'm providing three free copies of "Practical SQL." To enter a drawing for one of the free copies, please provide all the information below!.
docs.google.com
To support students, career-switchers and others who want to add SQL to their data analysis skillsets in 2025, I'm providing three free copies of the 2nd Edition of Practical SQL: A Beginner's Guide...
1
2
3
ROLLUP and CUBE are now on my PostgreSQL learning to-do list. By @sqlliz .
crunchydata.com
Learn about easy subtotals with the GROUP BY ROLLUP and CUBE to get totals and subtotals across categories and date bins.
1
4
11
In the upcoming version 8.14, the pgAdmin developers are providing the ability to shut off the alternating row shadings—a result of negative user feedback.
pgAdmin version 8.13, out today, jazzes up the results grid with alternating row colors and paginated output.
0
0
0
pgAdmin version 8.13, out today, jazzes up the results grid with alternating row colors and paginated output.
0
1
2
Here's how to handle your Python install for PostgreSQL under Windows, given the below thread.
github.com
Unfortunately, as of PostgreSQL 17, the Windows download from EDB described on page 5 of Chapter 1 no longer includes the Language Pack that had been part of the Stack Builder utility. Instead, to ...
NOTE! to new readers of Practical SQL: I'm assessing the decision by @EDBPostgres to discontinue its Language Pack installer for Windows as of PostgreSQL 17 -- and thus how to advise you on installing Python support. 🧵.
0
1
0
Once I figure this out, I'll post directions here:
github.com
Code and Data for the Second Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press. - anthonydb/practical-sql-2
1
1
0
In the meantime, Python is only required for one exercise in Chapter 17 in the book, so you can still do 99.9% of the exercises! 🙂.
1
0
0
NOTE! to new readers of Practical SQL: I'm assessing the decision by @EDBPostgres to discontinue its Language Pack installer for Windows as of PostgreSQL 17 -- and thus how to advise you on installing Python support. 🧵.
1
1
1
PostgreSQL 17 released with performance improvements to VACUUM, indexing, JSON handling and more .
postgresql.org
The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 17](https://www.postgresql.org/docs/17/release-17.html), the latest version of the...
0
1
0
The version 17 installer currently does not include PostGIS or the language pack.
0
0
1