Video yükleniyor...

Video Yüklenemedi

Ana Sayfaya Dön

🚀 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...

alxshp's profile picture

alex shapalov

3,301 subscribers

80,664 görüntüleme • 2 ay önce •via X (Twitter)

Bilim & Teknoloji
LIVE

Anya Rossi• Live Now

Private livecam show

0 Yorum

Yorum bulunmuyor

Orijinal gönderinin yorumları burada görünecek

Benzer Videolar

🚨Introducing a new database: PGX 🐘 Postgres for AI agents. In Rust. One runtime. Thousands of Postgres databases. ⚡ Up to 100× less idle memory ⚡ 1,000 databases in just 659 MB RAM ⚡ Clone a 674 MB database in 85 ms ⚡ ~0.7 MB per idle database RUST. OPEN SOURCE. FREE. No containers per database. No heavyweight instances. No production baggage. Real Postgres. Built to be disposable.
0:14

🚨Introducing a new database: PGX 🐘 Postgres for AI agents. In Rust. One runtime. Thousands of Postgres databases. ⚡ Up to 100× less idle memory ⚡ 1,000 databases in just 659 MB RAM ⚡ Clone a 674 MB database in 85 ms ⚡ ~0.7 MB per idle database RUST. OPEN SOURCE. FREE. No containers per database. No heavyweight instances. No production baggage. Real Postgres. Built to be disposable.

alex shapalov

120,525 görüntüleme • 7 gün önce

+ almost crossed 1,000 GitHub stars combined in just two weeks! ⭐️⭐️⭐️⭐️ Two open source tools for PostgreSQL: → pgbot Postgres diagnostics for humans and AI agents (Go) → pgterm: a fast Postgres terminal written in Rust A huge thank-you to everyone who tried them, starred them, and shared feedback 🐘 Next stop: 2,000 ⭐ :)
0:12

+ almost crossed 1,000 GitHub stars combined in just two weeks! ⭐️⭐️⭐️⭐️ Two open source tools for PostgreSQL: → pgbot Postgres diagnostics for humans and AI agents (Go) → pgterm: a fast Postgres terminal written in Rust A huge thank-you to everyone who tried them, starred them, and shared feedback 🐘 Next stop: 2,000 ⭐ :)

alex shapalov

41,236 görüntüleme • 1 ay önce

🔥 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.
0:14

🔥 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.

alex shapalov

154,782 görüntüleme • 2 ay önce

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. →
0:16

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. →

alex shapalov

98,322 görüntüleme • 1 ay önce

Big tables in Postgres can be a real pain. This is true of many databases, but the reasons for this are very different in MySQL vs Postgres vs YOUR_FAVORITE_DB. This article by simeonGriggs beautifully covers all the common issues, and how to solve with partitioning and sharding. Combined with all the excellent visuals, a must-read for anyone using Postgres.
0:16

Big tables in Postgres can be a real pain. This is true of many databases, but the reasons for this are very different in MySQL vs Postgres vs YOUR_FAVORITE_DB. This article by simeonGriggs beautifully covers all the common issues, and how to solve with partitioning and sharding. Combined with all the excellent visuals, a must-read for anyone using Postgres.

Ben Dicken

44,107 görüntüleme • 2 ay önce

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
0:16

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

alex shapalov

98,554 görüntüleme • 2 ay önce

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app
0:18

What Postgres can’t do alone, it can tackle with DuckDB. The pg_duckdb extension shows how two databases can work hand in hand by querying analytical data with DuckDB and joining it with transactional data in Postgres. The extension embeds DuckDB directly into Postgres. DuckDB literally runs inside a Postgres process. How it works (see diagram): 1. An app sends a query to Postgres joining portfolio data (Postgres) with historical market data (lakehouse) 2. pg_duckdb detects lakehouse access and delegates execution to DuckDB 3. DuckDB pulls required market data from the lakehouse, queries Postgres tables, and performs the join 4. Postgres returns the final result to the app

Denis Magda

28,678 görüntüleme • 9 ay önce

You can now run open-source AI coding agents without paying for API keys 🤯 Cline CLI 2.0 just dropped with free access to Minimax M2.5. → Runs from your terminal → Parallel agents → Works with any editor Any model you want. 100% Open Source.
0:14

You can now run open-source AI coding agents without paying for API keys 🤯 Cline CLI 2.0 just dropped with free access to Minimax M2.5. → Runs from your terminal → Parallel agents → Works with any editor Any model you want. 100% Open Source.

Alvaro Cintas

162,119 görüntüleme • 8 ay önce

Go from single-node Postgres to highly-available Postgres in one click 🐘 NOT production ready. Every time you use it in production, the Product Engineer who built it starts sweating Try it out and give us feedback
0:19

Go from single-node Postgres to highly-available Postgres in one click 🐘 NOT production ready. Every time you use it in production, the Product Engineer who built it starts sweating Try it out and give us feedback

Mahmoud

24,976 görüntüleme • 7 ay önce

Watch git diff while the code is changing! 🤯 👁️ livediff — A real-time diff viewer for the terminal 💯 Watch file changes live as generators, formatters, migrations & refactors modify your code 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #git #terminal #devtools #opensource
0:19

Watch git diff while the code is changing! 🤯 👁️ livediff — A real-time diff viewer for the terminal 💯 Watch file changes live as generators, formatters, migrations & refactors modify your code 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #git #terminal #devtools #opensource

Orhun Parmaksız 👾

36,595 görüntüleme • 3 ay önce

Man, this looks beautiful 😍 🧲 superseedr — A full-featured BitTorrent client for the terminal. 🌐 Supports multi-torrent downloads, DHT, PEX, magnet links & rarest-first piece selection. 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #torrent #bittorrent #p2p #terminal #opensource
0:10

Man, this looks beautiful 😍 🧲 superseedr — A full-featured BitTorrent client for the terminal. 🌐 Supports multi-torrent downloads, DHT, PEX, magnet links & rarest-first piece selection. 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #torrent #bittorrent #p2p #terminal #opensource

Orhun Parmaksız 👾

19,851 görüntüleme • 1 yıl önce

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.
0:10

Big moment for Postgres! Search has always been Postgres' weak spot, and everyone just accepted it. If you needed a real relevance-ranked keyword search, the default answer was to spin up Elasticsearch or add Algolia and deal with the data sync headaches forever. The problem isn't that Postgres can't do text search. It can. But the built-in `ts_rank` function uses a basic term frequency algorithm that doesn't come close to what modern search engines deliver. So teams end up: - Running a separate Elasticsearch cluster just for search - Building sync pipelines that inevitably drift out of consistency - Paying for managed search services that charge per query - Accepting mediocre search relevance because "good enough" ships faster But this is actually a solvable problem. You can realistically bring industry-standard search ranking directly into Postgres, which eliminates the need for external infra entirely. This exact solution is now available with the newly open-sourced pg_textsearch by Tiger Data - Creators of TimescaleDB, a Postgres extension that brings true BM25 relevance ranking into the database. BM25 is the algorithm behind Elasticsearch, Lucene, and most modern search engines. Now it runs natively in Postgres. Here's what pg_textsearch enables: - True BM25 ranking with configurable parameters (the same algorithm powering production search systems) - Simple SQL syntax: `ORDER BY content 'search terms'` - Works with Postgres text search configurations for multiple languages - Pairs naturally with pgvector for hybrid keyword + semantic search That last point matters a lot for RAG apps. The video below shows this in action, and I worked with the team to put this together. You can now do hybrid retrieval (combining keyword matching with vector similarity) in a single database, without stitching together multiple systems. The syntax is clean enough that you can add relevance-ranked search to existing queries in minutes. pg_textsearch is fully open-source under the PostgreSQL license. You can find a link to their GitHub repo in the next tweet.

Akshay 🚀

215,868 görüntüleme • 9 ay önce

The whole reason Jason Seibel and I rewrote Postgres in Rust is we wanted a way to prevent the types of bugs you see in C One guarantee we were able to encode in Rust is that an allocation can't outlive the memory context it was created in. Postgres has no safeguards to prevent this, but in pgrust, Rust will prevent this from happening
0:11

The whole reason Jason Seibel and I rewrote Postgres in Rust is we wanted a way to prevent the types of bugs you see in C One guarantee we were able to encode in Rust is that an allocation can't outlive the memory context it was created in. Postgres has no safeguards to prevent this, but in pgrust, Rust will prevent this from happening

Michael Malis

10,820 görüntüleme • 1 ay önce

Claude Code is now in Rust! 🦀🎉 🤖 claude-code-rust — A native TUI for Claude Code 💯 Streaming chat, tool calls, permissions, diffs, MCP, subagents & more! 🐀 Built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #terminal #claudecode
0:11

Claude Code is now in Rust! 🦀🎉 🤖 claude-code-rust — A native TUI for Claude Code 💯 Streaming chat, tool calls, permissions, diffs, MCP, subagents & more! 🐀 Built with Ratatui ⭐ GitHub: #rustlang #ratatui #tui #terminal #claudecode

Orhun Parmaksız 👾

25,016 görüntüleme • 24 gün önce

New version of Ratty is out! 🎉🧀 🐀 Ratty — A GPU-rendered terminal emulator with inline 3D graphics. 💯 Now supports SSH-friendly object payloads, transform control and keyboard scrollback navigation! 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #terminal #ratty #ratatui #opensource
0:18

New version of Ratty is out! 🎉🧀 🐀 Ratty — A GPU-rendered terminal emulator with inline 3D graphics. 💯 Now supports SSH-friendly object payloads, transform control and keyboard scrollback navigation! 🦀 Written in Rust & built with Ratatui ⭐ GitHub: #rustlang #terminal #ratty #ratatui #opensource

Orhun Parmaksız 👾

14,893 görüntüleme • 5 ay önce

You can now create read-only database users for Laravel MySQL databases in Laravel Cloud. Great for granting access to agents or even for humans tbh.
0:10

You can now create read-only database users for Laravel MySQL databases in Laravel Cloud. Great for granting access to agents or even for humans tbh.

Taylor Otwell

60,320 görüntüleme • 1 ay önce

today i discovered INDEXES for databases sorry post bridge users that it took me this long to start optimizing the SPEED of the platform first optimizations are out now! - dashboard pages loads much faster - database queries for posts 10x faster + calendar view bug fixes
0:13

today i discovered INDEXES for databases sorry post bridge users that it took me this long to start optimizing the SPEED of the platform first optimizations are out now! - dashboard pages loads much faster - database queries for posts 10x faster + calendar view bug fixes

jack friks

859,664 görüntüleme • 1 yıl önce

Supabase now has Agent Skills! Install it on your favorite AI agent/ editor to have it follow the best practices for handling Postgres! $ npx skills add supabase/agent-skills
0:17

Supabase now has Agent Skills! Install it on your favorite AI agent/ editor to have it follow the best practices for handling Postgres! $ npx skills add supabase/agent-skills

Tyler Shukert

109,148 görüntüleme • 9 ay önce

Wouldn't it be nice if your terminal had a file tree? 🌲 - Browse and open files in your current directory - Copy paths for terminal commands - Drag files into your input for agent queries
0:18

Wouldn't it be nice if your terminal had a file tree? 🌲 - Browse and open files in your current directory - Copy paths for terminal commands - Drag files into your input for agent queries

Warp

926,058 görüntüleme • 10 ay önce