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. practicalsql.com Joined December 2017

Tweets

208
Followers

325
Following

69
Likes

34

Practical SQL @practicalsql

3 weeks ago

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/

0 1 1 140 2

Practical SQL @practicalsql

4 months ago

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 716 0

Download Image

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…

0 6 21 2K 10

Download Image

黄健宏 @huangzworks

6 months ago

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

0 2 4 996 2

Download Image

Practical SQL @practicalsql

6 months ago

What's your favorite free GUI for use with PostgreSQL?

1 0 0 172 0

Practical SQL @practicalsql

6 months ago

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.

Practical SQL @practicalsql

7 months ago

0 2 2 447 1

0 1 1 269 0

Practical SQL @practicalsql

7 months ago

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…

0 2 2 447 1

Practical SQL @practicalsql

8 months ago

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

0 3 1 640 0

Download Image

Practical SQL @practicalsql

9 months ago

ROLLUP and CUBE are now on my PostgreSQL learning to-do list. By @sqlliz crunchydata.com/blog/easy-tota…

1 4 11 400 5

Practical SQL @practicalsql

9 months ago

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.

Practical SQL @practicalsql

10 months ago

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.