PostgreSQL Stan

I tweet about PostgreSQL, data wrangling, open source software, command line tools, and macOS. Plus an occasional cat picture.

[PostgreSQL Stan @PostgresqlStan]

I stan for PostgreSQL.
https://t.co/jy2bMznhTs

[Sarah @heyaimsarah]

so my mom (who hasn’t always understood what I do for work) read through all these comments and called me crying.

Seriously thank you guys 😭

[Sarah Conway @xenophenes]

#DevCommunity, need an excuse to practice your #PostgreSQL skills? My course on #LinkedInLearning is designed for beginner to intermediate learners and is hosted on #GitHubCodespaces to make it easy to practice. Check it out: https://t.co/gsbCnv1dzH #onlinecourse

[dr. sarah HANNAH gómez @shgmclicious]

NO I DO NOT WANT TO WATCH A VIDEO I JUST WANT WRITTEN INSTRUCTIONS ON HOW TO USE YOUR PRODUCT

[PostgreSQL Stan @PostgresqlStan]

@redixhumayun Yeah, I overlooked that key paragraph. You're right.

[PostgreSQL Stan @PostgresqlStan]

@sql_xocolatl I thought the post was clear.
https://t.co/LW90UJBB9G

[PostgreSQL Stan @PostgresqlStan]

😎 “bosses only”

[PostgreSQL Stan @PostgresqlStan]

@gumnos @lukaseder The next boss level is empty tables.
https://t.co/2gW3KyYftx

[PostgreSQL Stan @PostgresqlStan]

@AlanddSleman 💯

You might enjoy this story:
https://t.co/d13mkimLck

[PostgreSQL Stan @PostgresqlStan]

@gumnos @lukaseder The next boss level is empty tables.
https://t.co/2gW3KyYftx

[PostgreSQL Stan @PostgresqlStan]

@gumnos I have no idea, but @lukaseder probably knows.

[PostgreSQL Stan @PostgresqlStan]

from:
https://t.co/HR5UugJuLx

[Claire Giordano ✨ @clairegiordano]

Database experts responding to queries #PostgreSQL 👀😁

[🔎Julia Evans🔍 @b0rk]

interactive rebase

(this is #bonuscomic #1 for How Git Works https://t.co/wwYcr12mYY, covering some topics that didn't make it into the zine!)

permalink: https://t.co/jVNifZ83JP

[amrit @amritwt]

just made a small cli tool that gives you instant permalinks of images that you can embed at other places, right from images stored locally your pc

@var_epsilon's idea list is nice

[Haki @be_haki]

Excellent post. Reading and nodding. I wish customers would read this as well... 😩

[Ben Brumm @databasestar]

EAV stands for Entity Attribute Value, and it’s a database design that allows data to be captured in a flexible way.

In almost all cases, it’s not a good idea. It doesn’t enforce data types or referential integrity.

It's solving the wrong problem. Normalise the design instead.

[David Corn @DavidCornDC]

But no Republican has the guts to say this publicly. They’d rather elect a nutter and give him the power to destroy the planet than risk losing their elected office.

[James Kirk @Jiminy_Kirket]

you will not outsmart the query planner
you will not outsmart the query planner
you will not outsmart the query planner
you will not outsm

[Philippe Noël @philippemnoel]

You either die a specialized datastore hero or live long enough to bring it to people directly inside Postgres