PostgreSQL Hero
@postgresqlhero.bsky.social
SELECT * FROM users WHERE clue > 0;
0 rows returned.
0 rows returned.
December 5, 2025 at 9:48 AM
SELECT * FROM users WHERE clue > 0;
0 rows returned.
0 rows returned.
Why do programmers prefer dark mode?
Because light attracts bugs.
Because light attracts bugs.
December 5, 2025 at 9:48 AM
Why do programmers prefer dark mode?
Because light attracts bugs.
Because light attracts bugs.
ARRAY_AGG is one of those functions you wish you knew about sooner
December 5, 2025 at 9:47 AM
ARRAY_AGG is one of those functions you wish you knew about sooner
Timezones in SQL be like
December 5, 2025 at 9:41 AM
Timezones in SQL be like
This is why we have backups. You have backups, right?
December 5, 2025 at 9:37 AM
This is why we have backups. You have backups, right?
When you give AI database access
December 5, 2025 at 9:36 AM
When you give AI database access
PostgreSQL can store JSON, XML, arrays, geometric shapes, network addresses, time ranges, and even custom types you invent.
Meanwhile MongoDB: 'we store JSON'
Postgres has been doing that since 2012. And it's not even its main thing. 🐘
Meanwhile MongoDB: 'we store JSON'
Postgres has been doing that since 2012. And it's not even its main thing. 🐘
December 5, 2025 at 9:34 AM
PostgreSQL can store JSON, XML, arrays, geometric shapes, network addresses, time ranges, and even custom types you invent.
Meanwhile MongoDB: 'we store JSON'
Postgres has been doing that since 2012. And it's not even its main thing. 🐘
Meanwhile MongoDB: 'we store JSON'
Postgres has been doing that since 2012. And it's not even its main thing. 🐘
When Heroku needed a managed database for their PaaS, they chose PostgreSQL.
This decision single-handedly made Postgres the default database for an entire generation of startups.
Every Rails app, every Django app, every Node app - Postgres.
One decision. Millions of databases. 🐘
This decision single-handedly made Postgres the default database for an entire generation of startups.
Every Rails app, every Django app, every Node app - Postgres.
One decision. Millions of databases. 🐘
December 5, 2025 at 9:34 AM
When Heroku needed a managed database for their PaaS, they chose PostgreSQL.
This decision single-handedly made Postgres the default database for an entire generation of startups.
Every Rails app, every Django app, every Node app - Postgres.
One decision. Millions of databases. 🐘
This decision single-handedly made Postgres the default database for an entire generation of startups.
Every Rails app, every Django app, every Node app - Postgres.
One decision. Millions of databases. 🐘
The PostgreSQL Global Development Group has no CEO, no headquarters, no investors.
Just developers from around the world who care about building a good database.
Every feature is discussed publicly. Every decision is made by consensus.
This is what open source looks like. 🐘
Just developers from around the world who care about building a good database.
Every feature is discussed publicly. Every decision is made by consensus.
This is what open source looks like. 🐘
December 5, 2025 at 9:34 AM
The PostgreSQL Global Development Group has no CEO, no headquarters, no investors.
Just developers from around the world who care about building a good database.
Every feature is discussed publicly. Every decision is made by consensus.
This is what open source looks like. 🐘
Just developers from around the world who care about building a good database.
Every feature is discussed publicly. Every decision is made by consensus.
This is what open source looks like. 🐘
PostgreSQL has a mascot named Slonik.
'Slonik' is Russian for 'little elephant'.
Why an elephant? Because elephants have perfect memory.
And PostgreSQL never forgets your data. 🐘
'Slonik' is Russian for 'little elephant'.
Why an elephant? Because elephants have perfect memory.
And PostgreSQL never forgets your data. 🐘
December 5, 2025 at 9:34 AM
PostgreSQL has a mascot named Slonik.
'Slonik' is Russian for 'little elephant'.
Why an elephant? Because elephants have perfect memory.
And PostgreSQL never forgets your data. 🐘
'Slonik' is Russian for 'little elephant'.
Why an elephant? Because elephants have perfect memory.
And PostgreSQL never forgets your data. 🐘
Reddit, Spotify, and Discord all run on PostgreSQL.
The common thread? They all started small, grew massive, and never needed to 'migrate to something that scales'.
Turns out Postgres scales just fine. 🐘
The common thread? They all started small, grew massive, and never needed to 'migrate to something that scales'.
Turns out Postgres scales just fine. 🐘
December 5, 2025 at 9:34 AM
Reddit, Spotify, and Discord all run on PostgreSQL.
The common thread? They all started small, grew massive, and never needed to 'migrate to something that scales'.
Turns out Postgres scales just fine. 🐘
The common thread? They all started small, grew massive, and never needed to 'migrate to something that scales'.
Turns out Postgres scales just fine. 🐘
Michael Stonebraker, the creator of PostgreSQL, also created Ingres.
Ingres was sold. Got acquired. Became proprietary.
So he made POSTGRES - to never let that happen again.
30+ years later, it's still free. Still community-owned. Still thriving. 🐘
Ingres was sold. Got acquired. Became proprietary.
So he made POSTGRES - to never let that happen again.
30+ years later, it's still free. Still community-owned. Still thriving. 🐘
December 5, 2025 at 9:34 AM
Michael Stonebraker, the creator of PostgreSQL, also created Ingres.
Ingres was sold. Got acquired. Became proprietary.
So he made POSTGRES - to never let that happen again.
30+ years later, it's still free. Still community-owned. Still thriving. 🐘
Ingres was sold. Got acquired. Became proprietary.
So he made POSTGRES - to never let that happen again.
30+ years later, it's still free. Still community-owned. Still thriving. 🐘
TIL: The PostgreSQL version numbering used to be X.Y.Z (like 9.6.24).
In 2017 they switched to X.Y (like 10.0, 11.0...).
Why? Because people kept thinking 9.5 and 9.6 were minor updates. They weren't - they were massive releases. 🐘
In 2017 they switched to X.Y (like 10.0, 11.0...).
Why? Because people kept thinking 9.5 and 9.6 were minor updates. They weren't - they were massive releases. 🐘
December 5, 2025 at 9:34 AM
TIL: The PostgreSQL version numbering used to be X.Y.Z (like 9.6.24).
In 2017 they switched to X.Y (like 10.0, 11.0...).
Why? Because people kept thinking 9.5 and 9.6 were minor updates. They weren't - they were massive releases. 🐘
In 2017 they switched to X.Y (like 10.0, 11.0...).
Why? Because people kept thinking 9.5 and 9.6 were minor updates. They weren't - they were massive releases. 🐘
TIL: Instagram ran on PostgreSQL when they were acquired by Facebook for $1 billion.
3 engineers. 30 million users. PostgreSQL.
They didn't need to 'scale to NoSQL'. Postgres handled it. 🐘📸
3 engineers. 30 million users. PostgreSQL.
They didn't need to 'scale to NoSQL'. Postgres handled it. 🐘📸
December 5, 2025 at 9:34 AM
TIL: Instagram ran on PostgreSQL when they were acquired by Facebook for $1 billion.
3 engineers. 30 million users. PostgreSQL.
They didn't need to 'scale to NoSQL'. Postgres handled it. 🐘📸
3 engineers. 30 million users. PostgreSQL.
They didn't need to 'scale to NoSQL'. Postgres handled it. 🐘📸
TIL: PostgreSQL releases a new major version every year like clockwork.
They've done this since 2017. Every fall, a new major version drops.
No drama. No delays. Just consistent, boring reliability.
That's the elephant way. 🐘
They've done this since 2017. Every fall, a new major version drops.
No drama. No delays. Just consistent, boring reliability.
That's the elephant way. 🐘
December 5, 2025 at 9:33 AM
TIL: PostgreSQL releases a new major version every year like clockwork.
They've done this since 2017. Every fall, a new major version drops.
No drama. No delays. Just consistent, boring reliability.
That's the elephant way. 🐘
They've done this since 2017. Every fall, a new major version drops.
No drama. No delays. Just consistent, boring reliability.
That's the elephant way. 🐘
TIL: Apple ships PostgreSQL with every Mac.
It's been bundled with macOS since 10.7 Lion (2011).
Next time someone says 'I've never used Postgres' - if they have a Mac, they technically have. 🐘🍎
It's been bundled with macOS since 10.7 Lion (2011).
Next time someone says 'I've never used Postgres' - if they have a Mac, they technically have. 🐘🍎
December 5, 2025 at 9:33 AM
TIL: Apple ships PostgreSQL with every Mac.
It's been bundled with macOS since 10.7 Lion (2011).
Next time someone says 'I've never used Postgres' - if they have a Mac, they technically have. 🐘🍎
It's been bundled with macOS since 10.7 Lion (2011).
Next time someone says 'I've never used Postgres' - if they have a Mac, they technically have. 🐘🍎
TIL: PostgreSQL was the first database to implement MVCC (Multi-Version Concurrency Control).
This lets readers never block writers and writers never block readers.
Oracle later 'invented' the same thing. PostgreSQL had it in 1999. 🐘
This lets readers never block writers and writers never block readers.
Oracle later 'invented' the same thing. PostgreSQL had it in 1999. 🐘
December 5, 2025 at 9:33 AM
TIL: PostgreSQL was the first database to implement MVCC (Multi-Version Concurrency Control).
This lets readers never block writers and writers never block readers.
Oracle later 'invented' the same thing. PostgreSQL had it in 1999. 🐘
This lets readers never block writers and writers never block readers.
Oracle later 'invented' the same thing. PostgreSQL had it in 1999. 🐘
TIL: PostgreSQL is older than MySQL.
PostgreSQL: 1996
MySQL: 1995 (barely)
But POSTGRES (the project) started in 1986 - making the underlying technology a decade older.
The old elephant has seen things. 🐘
PostgreSQL: 1996
MySQL: 1995 (barely)
But POSTGRES (the project) started in 1986 - making the underlying technology a decade older.
The old elephant has seen things. 🐘
December 5, 2025 at 9:32 AM
TIL: PostgreSQL is older than MySQL.
PostgreSQL: 1996
MySQL: 1995 (barely)
But POSTGRES (the project) started in 1986 - making the underlying technology a decade older.
The old elephant has seen things. 🐘
PostgreSQL: 1996
MySQL: 1995 (barely)
But POSTGRES (the project) started in 1986 - making the underlying technology a decade older.
The old elephant has seen things. 🐘
TIL: PostgreSQL has been open source since 1996 and has NEVER been owned by a corporation.
It's maintained by a global community of volunteers and companies who contribute.
No single company can buy it, fork it, or kill it.
True open source. 🐘
It's maintained by a global community of volunteers and companies who contribute.
No single company can buy it, fork it, or kill it.
True open source. 🐘
December 5, 2025 at 9:32 AM
TIL: PostgreSQL has been open source since 1996 and has NEVER been owned by a corporation.
It's maintained by a global community of volunteers and companies who contribute.
No single company can buy it, fork it, or kill it.
True open source. 🐘
It's maintained by a global community of volunteers and companies who contribute.
No single company can buy it, fork it, or kill it.
True open source. 🐘
TIL: PostgreSQL's elephant mascot is named 'Slonik'.
The name comes from the Russian word for 'little elephant' (слоник).
Why an elephant? Because elephants never forget - just like PostgreSQL never loses your data. 🐘
The name comes from the Russian word for 'little elephant' (слоник).
Why an elephant? Because elephants never forget - just like PostgreSQL never loses your data. 🐘
December 5, 2025 at 9:31 AM
TIL: PostgreSQL's elephant mascot is named 'Slonik'.
The name comes from the Russian word for 'little elephant' (слоник).
Why an elephant? Because elephants never forget - just like PostgreSQL never loses your data. 🐘
The name comes from the Russian word for 'little elephant' (слоник).
Why an elephant? Because elephants never forget - just like PostgreSQL never loses your data. 🐘
TIL: PostgreSQL was originally called POSTGRES (no SQL).
It was created at UC Berkeley in 1986 by Michael Stonebraker.
The 'SQL' was added in 1996 when SQL support was added. The name is a play on 'Ingres' - Stonebraker's previous database.
Post-Ingres → Postgres 🐘
It was created at UC Berkeley in 1986 by Michael Stonebraker.
The 'SQL' was added in 1996 when SQL support was added. The name is a play on 'Ingres' - Stonebraker's previous database.
Post-Ingres → Postgres 🐘
December 5, 2025 at 9:31 AM
TIL: PostgreSQL was originally called POSTGRES (no SQL).
It was created at UC Berkeley in 1986 by Michael Stonebraker.
The 'SQL' was added in 1996 when SQL support was added. The name is a play on 'Ingres' - Stonebraker's previous database.
Post-Ingres → Postgres 🐘
It was created at UC Berkeley in 1986 by Michael Stonebraker.
The 'SQL' was added in 1996 when SQL support was added. The name is a play on 'Ingres' - Stonebraker's previous database.
Post-Ingres → Postgres 🐘
FUN FACT: https://postgresqlhero.vercel.app runs a full PostgreSQL database directly in your browser using PGlite.
No server. No backend. Just WASM magic under 3MB.
Learn SQL for free without us paying a cent for infrastructure 🐘
No server. No backend. Just WASM magic under 3MB.
Learn SQL for free without us paying a cent for infrastructure 🐘
December 5, 2025 at 9:27 AM
FUN FACT: https://postgresqlhero.vercel.app runs a full PostgreSQL database directly in your browser using PGlite.
No server. No backend. Just WASM magic under 3MB.
Learn SQL for free without us paying a cent for infrastructure 🐘
No server. No backend. Just WASM magic under 3MB.
Learn SQL for free without us paying a cent for infrastructure 🐘
Reposted by PostgreSQL Hero
Regression testing facility for PostgreSQL queries
December 4, 2025 at 2:53 PM
Regression testing facility for PostgreSQL queries
A SQL query walks into a bar, walks up to two tables and asks...
"Can I join you?"
"Can I join you?"
December 4, 2025 at 10:48 PM
A SQL query walks into a bar, walks up to two tables and asks...
"Can I join you?"
"Can I join you?"
One simple trick to speed up your queries 👇
December 4, 2025 at 10:48 PM
One simple trick to speed up your queries 👇