#PostgreSQL,
LightNews LightNews
jacob.gold
There are 2 million user accounts on Bluesky as of a few minutes ago! 🎉
PostgreSQL query output showing 2000187 accounts on Bluesky
November 13, 2023 at 4:38 AM
kelseyhightower.com
PostgreSQL, the open source database that continues to get better, is introducing oauth support. This should help with database automation and hopefully bring us one step closer to moving away from static credentials and copying usernames and passwords around. www.postgresql.org/about/news/p...
Security Features PostgreSQL 18 introduces oauth authentication, which lets users authenticate using OAuth 2.0 mechanisms supported through PostgreSQL extensions. Additionally, PostgreSQL 18 adds several features to validate and enforce FIPS mode behavior, and also adds the ssl_tls13_ciphers to let users configure which TLS v1.3 cipher suites the server can use. This release deprecates md5 password authentication in favor of using SCRAM authentication that was first added in PostgreSQL 10. md5 authentication will be fully removed in a future major version release. Additionally, PostgreSQL 18 adds support for SCRAM passthrough authentication with both postgres_fdw and dblink when authenticating to remote PostgreSQL instances.
May 12, 2025 at 10:52 PM
retr0.id
when most people read "this service requires postgresql" they think "ok I will set up postgresql"

I think "what if I rewrote it to use sqlite"
December 4, 2024 at 5:48 PM
kojimadayoo.bsky.social
PostgreSQL
April 19, 2026 at 3:06 PM
natalie.sh
you can simply rewrite postgresql
July 9, 2026 at 10:21 PM
isabelroses.com
sometimes your sysadmin is just stupid
$ sudo du -sh /srv/storage/postgresql/* 16G /srv/storage/postgresql/17 23G /srv/storage/postgresql/18 $ sudo rm -rf /srv/storage/postgresql/18
June 12, 2026 at 10:59 AM
jacob.gold
This blog post is a cautionary tale of the disaster that is trying to scale PostgreSQL beyond its limits.

I firmly expect to have someone cite it to me as an example of how PostgreSQL scales extremely well.
Scaling PostgreSQL to power 800 million ChatGPT users
By Bohan Zhang, Member of the Technical Staff
openai.com
January 23, 2026 at 4:56 AM
mackuba.eu
Today in database adventures… 😼
Recently Closed Reopen Last Closed Tab Reopen All Windows from Last Session Last opened pages: annotated.conf/postgresql.10.simple jberkus/annotated.conf PostgreSQL Documentation: effective_o_concurrency parameter PGTune - calculate configuration... a given hardware configuration eridani.mackuba.eu Munin PostgreSQL: Documentation: 17: 19.4. Resource Consumption How to Get the Most out of Postgres Memory Settings | Tembo iridium.mackuba.eu Munin PostgreSQL Memory Management - Stormatics Determining the optimal value for... PostgreSQL | AWS Database Blog Memory context: how PostgreSQL… | Services & Support The surprising logic of the PostgresQL.… mem setting, and how to tune it postgres find out how much work_mem a query needs - Google Search PostgreSQL: Documentation: 17: EXPLAIN PostgreSQL: PostgreSQL 17.2, 16....15, 13.18, and 12.22 Released!
December 1, 2024 at 6:32 PM
cyberciti.biz
PostgreSQL zero downtime migrations made easy with pgroll github.com/xataio/pgroll
GitHub - xataio/pgroll: PostgreSQL zero-downtime migrations made easy
PostgreSQL zero-downtime migrations made easy. Contribute to xataio/pgroll development by creating an account on GitHub.
github.com
October 19, 2025 at 2:30 AM
kelseyhightower.com
Just when I thought I've seen it all, a PostgreSQL extension shows up that allows you to embed a SQLite database inside a table. github.com/frectonz/pgl...
Example usage of embedding SQLite inside a Postgres database table.
November 19, 2024 at 2:19 PM
technotim.bsky.social
Today, I teach you how you can self-host a production-ready PostgreSQL cluster. I've even included all of the copy pasta commands!

#postgresql #database #selfhosting

www.youtube.com/watch?v=RHwg...
Self-hosting a Production-Ready PostgreSQL Cluster
YouTube video by Techno Tim
www.youtube.com
December 7, 2024 at 7:48 PM
yellowduck.be
🔗 Don't Do This in PostgreSQL

##best-practice ##database ##postgresql ##reading-list ##sql
Don't Do This in PostgreSQL
#best-practice #database #postgresql #reading-list #sql
wiki.postgresql.org
December 21, 2024 at 9:00 AM
cyberciti.biz
The Internals of PostgreSQL for DBAs and developers www.interdb.jp/pg/index.html

#postgresql #sysadmin #opensource
PostgreSQL is a well-designed, open-source multi-purpose relational database system which is widely used throughout the world.
www.interdb.jp
March 3, 2025 at 3:39 PM
piss.beauty
if these few guys ever stop maintaining postgres its so over, thank you petere
postgresql is the most important piece of infrastructure besides DNS lead postgresql maintainers github contributions
August 8, 2023 at 10:29 PM
okyawa.bsky.social
Supabase社が提供のPostgreSQLに対応したAgent Skill、良さそう

www.publickey1.jp/blog/26/aipo...
AIエージェントがPostgreSQL対応の優れたコードを書けるようになるAgent Skill「Postgres Best Practices」、Supabaseが公開
PostgreSQLをベースにしたBaaS（Backend as a Service）の「Supabase」を開発し提供しているSupabase社は、AIエージェントがPostgreSQLに対応した優れたコードを書けるようになるAgent ...
www.publickey1.jp
January 26, 2026 at 10:19 PM
eatonphil.bsky.social
PostgreSQL 18 is released!
September 25, 2025 at 1:54 PM
sebastienlorber.com
TIL you can get PostgreSQL to render HTML directly 😄

github.com/mkaski/pg_re...
January 16, 2025 at 9:27 AM
lea-linux.org
Dear PostgreSQL, Explain my bottleneck !
July 10, 2025 at 9:01 PM
maxiong.bsky.social
The PostgreSQL Server Info panel in DataCollie is ready too! It's a v1, so features are a bit lean, but it covers all the essential metrics.

#PostgreSQL #BuildInPublic
October 3, 2026 at 9:34 AM
andyatkinson.com
Got a surprise in the mail! Honored to have received a PostgreSQL 17 contributor coin!
PostgreSQL 17 contributor coin in package with accompanying note PostgreSQL 17 contributor coin showing logo and 2024-09-26 date
January 9, 2025 at 8:24 PM
starbuxman.joshlong.com
im in the mix with Dave Cramer, contributor to PostgreSQL and the PostgreSQL JDBC driver, NOW. bring your questions and learning hats!
www.youtube.com/watch?v=DSbu...
Dave Cramer, PostgreSQL and PostgreSQL JDBC engineeer extraordinairre
YouTube video by Coffee + Software
www.youtube.com
November 15, 2024 at 8:02 PM
nekomimi.pet
Trans women: REAL GENDER
Trans man: REAL GENDER
Non-Binary: REAL GENDER
PostgreSQL: MENTAL ILLNESS
September 23, 2025 at 2:22 AM
haskell.org
hpgsql, a PostgreSQL driver written in pure Haskell

discourse.haskell.org/t/ann-hpgsql...
[ANN] hpgsql, a pure Haskell PostgreSQL driver (no libpq)
It’s a pleasure to announce hpgsql, a PostgreSQL driver written in pure Haskell (no libpq), with an API largely inspired by the great postgresql-simple library, but featuring: Usage of PostgreSQL’s ...
discourse.haskell.org
May 13, 2026 at 8:07 PM
vscode.dev
🚀 Ready to supercharge your PostgreSQL workflow?

Meet the new Microsoft PostgreSQL extension for VS Code - packed with powerful tools like:
🤖 Agent mode integration
💡 Schema visualization
⚡ Instant Docker PostgreSQL
🔎 IntelliSense-powered queries

Learn more: aka.ms/Blog/Postgre...
May 23, 2025 at 5:46 PM
yellowduck.be
A good overview of things you really want to know about PostgreSQL by @hibachrach.com

##database ##postgresql ##reading-list
What I Wish Someone Told Me About Postgres
#database #postgresql #reading-list
challahscript.com
December 25, 2024 at 2:00 PM