alex shapalov's banner
alex shapalov's profile picture

alex shapalov

@alxshp • 3,059 subscribers

Building Postgres for agents + OSS Postgres Bot → https://t.co/rbsinUITD8 Branches → https://t.co/OH8lt1RciD Terminal → https://t.co/ii8QrPHC9h

Shorts

🔥 is cooking your Postgres tables 🐘 One command to quickly find the tables that are too big, too busy, or wasting space. pgbot tables See your top 30 tables by: → dead rows % → sequential scans → index scans → size → rows No dashboard. Just your terminal. Free. Open source.

🔥 is cooking your Postgres tables 🐘 One command to quickly find the tables that are too big, too busy, or wasting space. pgbot tables See your top 30 tables by: → dead rows % → sequential scans → index scans → size → rows No dashboard. Just your terminal. Free. Open source.

152,433 просмотров

is eating the Postgres stack 🤖 Now you can cover these workflows for FREE: → pganalyze - $149–$399/mo → Datadog DBM - $70/database host/mo → DrawSQL - $19–$179/mo → pg_activity - live sessions → pgBadger - log analysis → migration linters - CI safety → custom SQL - everything else With pgbot: pgbot inspect pgbot queries pgbot indexes pgbot waits pgbot why --duration 10s pgbot logs --follow pgbot migration-check pgbot diagram Local. Open source. $0/month. →

is eating the Postgres stack 🤖 Now you can cover these workflows for FREE: → pganalyze - $149–$399/mo → Datadog DBM - $70/database host/mo → DrawSQL - $19–$179/mo → pg_activity - live sessions → pgBadger - log analysis → migration linters - CI safety → custom SQL - everything else With pgbot: pgbot inspect pgbot queries pgbot indexes pgbot waits pgbot why --duration 10s pgbot logs --follow pgbot migration-check pgbot diagram Local. Open source. $0/month. →

97,961 просмотров

Launched today: 📕 Postgres Book, one topic at a time! No 1000 page manual. Pick a topic, understand how it works, and try the examples yourself. Learn: • Indexes • Transactions • JSONB • Window functions • Row-level security • Vacuum • Locks • Replication $ pgbook read locks Free and open source. No signup required. →

Launched today: 📕 Postgres Book, one topic at a time! No 1000 page manual. Pick a topic, understand how it works, and try the examples yourself. Learn: • Indexes • Transactions • JSONB • Window functions • Row-level security • Vacuum • Locks • Replication $ pgbook read locks Free and open source. No signup required. →

100,919 просмотров

🚀 Launching today: Postgres terminal written in Rust 🦀🐘 One terminal for all your Postgres databases. → Add any database in one command → Monitor health, queries, indexes & activity → Switch between databases instantly → Connect with pgbot for deeper diagnostics → Runs locally Free & open source Think htop for Postgres, but built for developers + AI agents. GitHub ↓

🚀 Launching today: Postgres terminal written in Rust 🦀🐘 One terminal for all your Postgres databases. → Add any database in one command → Monitor health, queries, indexes & activity → Switch between databases instantly → Connect with pgbot for deeper diagnostics → Runs locally Free & open source Think htop for Postgres, but built for developers + AI agents. GitHub ↓

80,664 просмотров

Just launched today 🤖🐘 Postgres intelligence for agents & apps. Free. Open source. Written in Go. Nobody wants to stare at PostgreSQL dashboards all day. So I built a bot that does it for you. → finds what’s wrong → explains what changed → tells you what to fix first Metrics are data. pgbot gives you answers pgbot can: +PostgreSQL health monitoring +Query performance analysis +Slow query and regression detection +Locks and blocking query insights +Table and index analytics +Vacuum and autovacuum visibility +Database growth tracking +AI root-cause analysis +AI-powered recommendations +Direct connection or agent-based private access

Just launched today 🤖🐘 Postgres intelligence for agents & apps. Free. Open source. Written in Go. Nobody wants to stare at PostgreSQL dashboards all day. So I built a bot that does it for you. → finds what’s wrong → explains what changed → tells you what to fix first Metrics are data. pgbot gives you answers pgbot can: +PostgreSQL health monitoring +Query performance analysis +Slow query and regression detection +Locks and blocking query insights +Table and index analytics +Vacuum and autovacuum visibility +Database growth tracking +AI root-cause analysis +AI-powered recommendations +Direct connection or agent-based private access

98,554 просмотров

Postgres 19 handles traffic spikes the way infrastructure should. Not with one fixed I/O pool sized for an imaginary average day. But dynamically. → Traffic spikes → The I/O queue grows → PostgreSQL notices → More workers launch → The queue clears → Extra workers disappear when demand drops No manual intervention. No permanent overprovisioning. No tiny worker pool choking under production traffic. PostgreSQL is becoming infrastructure that adapts instead of infrastructure you babysit.

Postgres 19 handles traffic spikes the way infrastructure should. Not with one fixed I/O pool sized for an imaginary average day. But dynamically. → Traffic spikes → The I/O queue grows → PostgreSQL notices → More workers launch → The queue clears → Extra workers disappear when demand drops No manual intervention. No permanent overprovisioning. No tiny worker pool choking under production traffic. PostgreSQL is becoming infrastructure that adapts instead of infrastructure you babysit.

96,131 просмотров

Postgres 19 can query relationships like a GRAPH NOT with a long manual join chain. With a path: customer → bought → product product ← bought ← similar customer similar customer → follows → brand That is a recommendation system in one readable pattern. SQL/PGQ finds the relationship. COLUMNS decides what comes back. Postgres keeps eating the backend stack.

Postgres 19 can query relationships like a GRAPH NOT with a long manual join chain. With a path: customer → bought → product product ← bought ← similar customer similar customer → follows → brand That is a recommendation system in one readable pattern. SQL/PGQ finds the relationship. COLUMNS decides what comes back. Postgres keeps eating the backend stack.

56,099 просмотров

is slowly getting everywhere 👀 FreeBSD + Arch Linux + Omarchy + Nix = ✅ npm + Docker + Go + homebrew= ✅ In progress: Ubuntu, Debian, Fedora, Alpine 🐘 Some of these packages were created by the community which makes this even cooler. What’s next? What Linux distro / OS are you using?

is slowly getting everywhere 👀 FreeBSD + Arch Linux + Omarchy + Nix = ✅ npm + Docker + Go + homebrew= ✅ In progress: Ubuntu, Debian, Fedora, Alpine 🐘 Some of these packages were created by the community which makes this even cooler. What’s next? What Linux distro / OS are you using?

19,002 просмотров

Videos

Больше нет контента для загрузки