
Practical SQL
@practicalsql
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.
你可能會喜歡
Wow, JetBrains is making DataGrip available for free for non-commercial use. Great news for students and open-source projects. (And readers of my book.) blog.jetbrains.com/datagrip/2025/…
Postgres.app -- my favorite way to run PostgreSQL on macOS -- is making it easier to add extensions to your environment. Really handy. postgresapp.com/extensions/
Newest versions of pgAdmin now let us customize the font in the Query Tool. Nice upgrade. Set here to MesloLGL Nerd Font:

Postgres users love Common Table Expressions (CTEs) because they make complex SQL easy to read, create, edit, and reuse. Simplicity – CTEs let you break a query into smaller logical chunks, with subqueries defined at the top of the query. It is almost like giving a query book…

Anthony DeBarros' excellent book "Practical SQL" is now available in Chinese!🎆🎉 @anthonydb @practicalsql @nostarch

What's your favorite free GUI for use with PostgreSQL?
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. github.com/anthonydb/prac…
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. github.com/anthonydb/prac…
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! practicalsql.com

ROLLUP and CUBE are now on my PostgreSQL learning to-do list. By @sqlliz crunchydata.com/blog/easy-tota…
crunchydata.com
Easy Totals and Subtotals in Postgres with Rollup and Cube | Crunchy Data Blog
Learn about easy subtotals with the GROUP BY ROLLUP and CUBE to get totals and subtotals across categories and date bins.
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.

pgAdmin version 8.13, out today, jazzes up the results grid with alternating row colors and paginated output.

Here's how to handle your Python install for PostgreSQL under Windows, given the below thread. github.com/anthonydb/prac…
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. 🧵
PostgreSQL 17 released with performance improvements to VACUUM, indexing, JSON handling and more ... postgresql.org/about/news/pos…
United States 趨勢
- 1. Bears 89.3K posts
- 2. Jake Moody 13.7K posts
- 3. Snell 24.3K posts
- 4. Caleb 49.2K posts
- 5. Falcons 51.3K posts
- 6. Bills 141K posts
- 7. Josh Allen 26.6K posts
- 8. Jayden 22.9K posts
- 9. #BearDown 2,369 posts
- 10. phil 175K posts
- 11. Swift 290K posts
- 12. Happy Birthday Charlie 8,474 posts
- 13. Ben Johnson 4,433 posts
- 14. Joji 29.7K posts
- 15. #Dodgers 15.3K posts
- 16. Turang 4,321 posts
- 17. Troy Aikman 6,517 posts
- 18. Roki 6,101 posts
- 19. Bijan 32.9K posts
- 20. Brewers 48.5K posts
你可能會喜歡
-
Matt Johansen
@mattjay -
Data Egret | PostgreSQL support
@dataegret -
ThoughtSpot
@thoughtspot -
SQL Daily
@sqldaily -
Andrew Van Dam
@andrewvandam -
MSSQLTips - Free Daily #SQLServer Tips
@mssqltips -
Eugene Meidinger
@SQLGene -
Kim Manis
@kimmanis -
Azimutt · Database explorer and analyzer
@azimuttapp -
Ginger Grant
@DesertIsleSQL -
Katie Bauer
@imightbemary -
IPUMS
@ipums -
Agent 009
@curtispokrant
Something went wrong.
Something went wrong.