📋 #psql compatibility with familiar commands like \dt, \d, \dn, \l
📜 Persistent query history with fuzzy search
🍺 Easy install via #Homebrew, #Cargo or binary download

https://github.com/fcoury/tsql

@neptune22222

Didn't you find out it was less of a hassle doing it directly in #psql ?

So... most gnome apps are failing to open on my debian sid daily driver. So... pgadmin4 won't open to remotely edit my company database. So... I have learned how to add a column to a table in my remote database using psql locally. Yup, I'm a hacker.

#postgres #postgresql #pgadmin #pgadmin4 #psql #debian #sid #debiansid #hacker

Hey, I need help with #AWS #RDS.

I've this #Postgresql #RDS in private subnets.
I want to access it with the #psql cli (or any client really).

I see two ways.
One, which I find easy, with an #EC2 that acts as a #Bastion with #SSM so it remains private but requires a tunnel.
And one with a #RDSProxy exposed via a #NLB which is more involved but requires no tunnel.

Is there any other approach?
Something so obvious I missed it?

Thanks for your time and boosts in advance 🙇

EDIT: solution below

Tomorrow: @swisspug & @tbussmann invite us to a presentation (Rapperswil + Online) on #psql-chat - ask #PostgreSQL questions in natural language, an SQL query or PSQL command is generated for faster interactive data analysis https://www.swisspug.org/#meetup_2025-12

Today, trying to get the k3s cluster back to a working and smooth sailing state...

It has been somewhat unstable since the moving, and with little time to take care of it, outages were around every corner

Turns out, CNPG wasn't clearing out WAL on local replicas, inflating local disk usage, making them unavailable for scheduling...

Now that I understand why everything goes down, it is time to setup ntfy and link with with alertmanager+prometheus to get proper insights on the cluster in realtime

Now, back to rebuilding all Longhorn volumes because of those random outages *sight*

But underlining the importance of having good backups ! Because no data was lost, despite random downtimes

#k3s #devops #kubernetes #prometheus #alertmanager #cluster #cnpg #wal #postgres #psql #ntfy #longhorn #volume #backups #homelab #selfhosted

[Перевод] Как отследить трафик PostgreSQL

Недавно я изучал детали реализации взаимодействия клиента PostgreSQL с базой данных и был удивлён, насколько легко просматривать трафик PostgreSQL с помощью wireshark. Когда я поделился своим удивлением в социальной сети, меня попросили привести пример того, как это сделать.

https://habr.com/ru/companies/gnivc/articles/962184/

#wireshark #sniffer #psql #protocol #бд #базы_данных #постгрес #sql

I was reminded, unfortunately, today that I still despise #psql

It's like Microsoft Access f🤬d some old 1.0 version of mysql and from that jank, psql squelched out of the conjunction already completely batshit insane

That's my guess... 🦥

🌘 PostgreSQL 18 的 psql 指令列工具支援查詢佇列化：提升效能的祕密武器
➤ 體驗 psql 佇列化帶來的驚人速度飛躍
✤ https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html
本篇文章介紹 PostgreSQL 18 中 psql 指令列工具新增的查詢佇列化（pipelining）功能。此功能允許用戶端在不等待前一個查詢結果回傳的情況下，連續發送多個查詢，藉此大幅提升資料庫處理的吞吐量。作者透過實際的效能測試，展示了在不同網路環境下，啟用查詢佇列化後，INSERT ... ON CONFLICT 操作的處理速度能有數倍甚至數十倍的顯著提升。文章同時闡述了查詢佇列化的原理、其與舊有技術的比較，以及如何在實際應用中善用此新功能來優化資料庫效能。
+ 太棒了！一直覺得 psql 在處理大量 INSERT 時很慢，這個新功能聽起來很有潛力！
+ 感謝作者詳細的測試與解釋，對於需要批次處理資料的開發者來說，這絕對是個福音。
#資料庫 #PostgreSQL #psql #效能優化

Pipelining in psql (PostgreSQL 18)

https://postgresql.verite.pro/blog/2025/10/01/psql-pipeline.html

#HackerNews #Pipelining #psql #PostgreSQL #Database #Development #Tech #News

Пять возможностей PostgreSQL, о которых редко вспоминают

Привет, Хабр! Постгрес – не просто реляционная БД, а настоящий кладезь фич, о которых начинающий разработчик может и не догадываться. Всё началось с того, что PostgreSQL изначально писался на С/C++ и всегда тянуло к расширению стандартного SQL набора возможностей. Так однажды разработчики решили добавить в него JSONB , логику на уровне запросов и многое другое – что в итоге сделало его не хуже NoSQL-систем. Но вернёмся к малоизвестным фичам. Ниже – пять приёмов и возможностей, которые неожиданно полезны в повседневной работе.

https://habr.com/ru/companies/otus/articles/941456/

#psql #postgresql #базы_данных #оптимизация_запросов #права_доступа #диапазонные_типы #производительность

A simple but a useful pattern for reloading postgres SQL extensions during development #postgresql #postgres #pattern #psql

https://github.com/diraneyya/pgext_noop_pattern?tab=readme-ov-file

@theory I thought you may find this interesting

Great productivity tonight !

Upgraded Immich from 1.132.1 to 1.135.3
Migrated its database from pgvector.rs to VectorChord
Upgraded to VectorChord 0.4.3 from 0.3.0

That was actually relatively easy once I started taking my time and reading the migration documentation

Now everything is healthy and up to date, let's see how those performance improvements translate to realworld applications

#immich #selfhosted #homelab #kubernetes #vectorchord #pgvector #psql #cnpg #rtfm

"Just vacuum your database bro". This thing is almost 100GB... surely this won't take very long? Ha ha.

#psql #postgres