Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

๐Ÿš€ 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 Aufrufe โ€ข vor 2 Monaten โ€ขvia X (Twitter)

Wissenschaft & Technologie
LIVE

Anya Rossiโ€ข Live Now

Private livecam show

0 Kommentare

Keine Kommentare verfรผgbar

Kommentare vom Original-Post werden hier angezeigt

ร„hnliche Videos

๐Ÿšจ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 Aufrufe โ€ข vor 7 Tagen

+ 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 Aufrufe โ€ข vor 1 Monat

๐Ÿ”ฅ 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 Aufrufe โ€ข vor 2 Monaten

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 Aufrufe โ€ข vor 1 Monat

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 Aufrufe โ€ข vor 2 Monaten

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 Aufrufe โ€ข vor 2 Monaten

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 Aufrufe โ€ข vor 9 Monaten

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 Aufrufe โ€ข vor 8 Monaten

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 Aufrufe โ€ข vor 7 Monaten

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 Aufrufe โ€ข vor 3 Monaten

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 Aufrufe โ€ข vor 1 Jahr

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 Aufrufe โ€ข vor 9 Monaten

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 Aufrufe โ€ข vor 1 Monat

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 Aufrufe โ€ข vor 24 Tagen

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 Aufrufe โ€ข vor 5 Monaten

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 Aufrufe โ€ข vor 1 Monat

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 Aufrufe โ€ข vor 1 Jahr

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 Aufrufe โ€ข vor 9 Monaten

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 Aufrufe โ€ข vor 10 Monaten