Tootfinder

from my link log —
PostgreSQL lock conflicts quick reference.
https://pglocks.org/
saved 2025-05-18 https://dotat.at/:/GI763.html

@… This is very cool!
I did something similar for PostgreSQL last month.
https://codeberg.org/ooble/tremuloides

Updating my CloudNativePG Clusters to postgresql:17.5 broke wal archiving to my Ceph S3 Object Store. Here's a new blog post describing the fix:
https://www.beyondwatts.com/posts/debugging-barman-xamzcontents…

beyondwatts | Debugging Barman XAmzContentSHA256Mismatch error after upgrading to postgresql:17.5
In an effort to keep my home cluster up to date, I upgraded CloudNativePG to v1.26 and the associated database clusters to cloudnative-pg/postgresql:17.5. All seemed ok with the upgrade until a couple of days later when the cluster primary instance PVCs started to run out of space. wal archiving had stopped working with the error message:

Any good resources out there on building secure (but easy for someone who’s messing with javascript/typescript for the 1st time) login systems with nodejs and postgresql?
I think I’ve seen someone on fedi mention that bcrypt wasn’t really safe a while ago?
#nodejs

from my link log —
Three cases against IF NOT EXISTS / IF EXISTS in PostgreSQL DDL.
https://postgres.ai/blog/20211103-three-cases-against-if-not-exists-and-if-exists-in-postgresql-ddl
saved 2021-11-12

Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL | Postgres AI

What is this about?

Many DDL statements in PostgreSQL support modified IF EXISTS / IF NOT EXISTS. For example:

 test=# create table if not exists mytable(); CREATE TABLE test=# drop table if exists mytable; DROP TABLE 

I recommend using `IF EXISTS` / `IF NOT EXISTS`…

Hola #MastondonCR ha salido una nueva versión del software Mastodon y con vamos a instalarlo en nuestra comunidad de Mastodon.CR
Esta es la publicación de Mastodon donde cuentan las nuevas características y mejoras: https://

Today I learned a nice #PostgreSQL snippet to generate a random timestamp: `select now()::date (random() * interval '1 day');`

Azure Database for PostgreSQL Blog author and Microsoft employee "JoshMSFT" shares details on Microsoft's new PostgreSQL extension for Visual Studio Code.
Feature set includes:
1. Schema Visualization
2. Database aware GitHub Copilot
3. Database Explorer
4. Query History
5. Query Editing with Context-aware IntelliSense
 
"Announcing a new IDE for PostgreSQL in VS Code from Microsoft"

Snowflake agrees to acquire Crunchy Data, a cloud-based database service that helps businesses and government agencies use PostgreSQL, a source says for ~$250M (Belle Lin/Wall Street Journal)
https://www.wsj.com/articles/snowflake-to-buy-crunchy…

Thanks to @…, I've deleted my toot on #PostgreSQL 18 since after verification, it claimed "unverified" capabilities.
…

PostgreSQL ist aufgrund seiner Robustheit, Flexibilität Modularität sehr beliebt – und komplex. Das kann schnell zu Fehlkonfigurationen führen. Mit unserer Checkliste und Beispiel-Konfiguration gelingt dir eine Basisabsicherung. – https://datadisrupted.tech/checkliste-

Lyon ditching Microsoft.
#microsoft

French city of Lyon ditching Microsoft for open source office and collab tools
: Ingredients of future software salade Lyonnaise will include Linux, PostgreSQL, and OnlyOffice

SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications
Jinyang Li, Xiaolong Li, Ge Qu, Per Jacobsson, Bowen Qin, Binyuan Hui, Shuzheng Si, Nan Huo, Xiaohan Xu, Yue Zhang, Ziwei Tang, Yuanshuai Li, Florensia Widjaja, Xintong Zhu, Feige Zhou, Yongfeng Huang, Yannis Papakonstantinou, Fatma Ozcan, Chenhao Ma, Reynold Cheng

SWE-SQL: Illuminating LLM Pathways to Solve User SQL Issues in Real-World Applications
Resolution of complex SQL issues persists as a significant bottleneck in real-world database applications. Current Large Language Models (LLMs), while adept at text-to-SQL translation, have not been rigorously evaluated on the more challenging task of debugging SQL issues. To address this gap, we introduce BIRD-CRITIC, a new SQL issue debugging benchmark comprising 530 PostgreSQL tasks (BIRD-CRITIC-PG) and 570 multi-dialect tasks (BIRD-CRITIC-Multi), distilled from authentic user issues and rep…

from my link log —
A language server protocol (LSP) implementation for PostgreSQL.
https://github.com/supabase-community/postgres-language-server
saved 2025-03-29

GitHub - supabase-community/postgres-language-server: A Language Server for Postgres
A Language Server for Postgres. Contribute to supabase-community/postgres-language-server development by creating an account on GitHub.