正在加载视频...

视频加载失败

加载此视频时出现问题。这可能是由于临时网络问题，或视频可能不可用。

Introducing pg_strict for Postgres. Our new extension adds a safety net to Postgres, catching dangerous queries before they run.

PlanetScale

38,147 subscribers

114,704 次观看 • 8 个月前 •via X (Twitter)

教育科学技术

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

Introducing Database Traffic Control: a Postgres traffic management system built into PlanetScale. Enforce flexible budgets on your database traffic to protect against unexpected and dangerous workloads.

Introducing Database Traffic Control: a Postgres traffic management system built into PlanetScale. Enforce flexible budgets on your database traffic to protect against unexpected and dangerous workloads.

PlanetScale

161,872 次观看 • 6 个月前

PlanetScale now supports Postgres.

PlanetScale now supports Postgres.

PlanetScale

953,874 次观看 • 1 年前

768 Postgres servers. A petabyte of data. One connection string.

768 Postgres servers. A petabyte of data. One connection string.

PlanetScale

109,706 次观看 • 1 个月前

Today we introduce TIN: a powerful and reliable full-text search extension for Postgres. TIN works with complicated WHERE clauses, replication, backups, and maintains correct transaction visibility. It's also mind-blowingly fast.

Today we introduce TIN: a powerful and reliable full-text search extension for Postgres. TIN works with complicated WHERE clauses, replication, backups, and maintains correct transaction visibility. It's also mind-blowingly fast.

PlanetScale

500,125 次观看 • 8 天前

PlanetScale Postgres starts at $5/month, but you don't have to buy a new one for every project. Filling a single cluster with many logical databases is the move.

PlanetScale Postgres starts at $5/month, but you don't have to buy a new one for every project. Filling a single cluster with many logical databases is the move.

PlanetScale

14,684 次观看 • 3 个月前

Postgres: process-per-connection MySQL: thread-per-connection Learn more about processes, threads, connection pooling, and how they impact database performance in our latest interactive article.

Postgres: process-per-connection MySQL: thread-per-connection Learn more about processes, threads, connection pooling, and how they impact database performance in our latest interactive article.

PlanetScale

349,579 次观看 • 1 年前

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!

`bunx pg-here` global one-liner to run a standalone postgres instance with all data within the current folder throw-away postgres anytime anywhere. cli args for version/user/pass/db configs. docs: stop using docker just to launch a postgres!!

murat 🍥

50,537 次观看 • 7 个月前

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.

🚀 launched today: 🐘 Postgres branches for every AI agent. → build a Postgres branch in ~3 seconds → production-like data → isolated database for every agent → sensitive data automatically masked → branch → work → delete Already ~100 Postgres branches/week before public launch. Now we're building the Postgres runtime for agents.

alex shapalov

92,876 次观看 • 9 天前

Even the most powerful artificial minds need infrastructure to understand the world. We've launched a radical project to change the way we build AI Agents. A graph layer that uses up to 34x less RAM than neo4j. To start: pgGraph (Full Open Souce, Rust), is a postgres extension that lets you run complex graph queries, like finding shortest paths using standard SQL. Directly in postgres. Coming next: Polygres, give your postgres a warp drive by combining pgGraph & pgVector into an all-in-one database. We're building the foundation of intelligence evokoa Links below ↓

Even the most powerful artificial minds need infrastructure to understand the world. We've launched a radical project to change the way we build AI Agents. A graph layer that uses up to 34x less RAM than neo4j. To start: pgGraph (Full Open Souce, Rust), is a postgres extension that lets you run complex graph queries, like finding shortest paths using standard SQL. Directly in postgres. Coming next: Polygres, give your postgres a warp drive by combining pgGraph & pgVector into an all-in-one database. We're building the foundation of intelligence evokoa Links below ↓

dale

15,067 次观看 • 3 个月前

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Let Postgres own the Iceberg catalog and delegate analytics to DuckDB. The result => transactional lakehouse updates with fast analytical queries. This isn’t a concept. It’s exactly what pg_lake delivers today. pg_lake combines a set of extensions and components that let you query and modify Iceberg tables (and other lakehouse formats) directly from Postgres. DuckDB is used to accelerate analytical queries and runs in a sidecar process called pgduck_server, which communicates with Postgres during query execution. How it works (diagram below): 1. An application sends a query to Postgres to calculate unrealized PnL (Profit and Loss) for the Disney ticker. 2. Postgres parses the query and identifies the part that computes the average price from historical lakehouse data. 3. That part is forwarded to pgduck_server for accelerated execution. 4. pgduck_server delegates execution to DuckDB, which queries the lakehouse (reusing cached data if available). 5. DuckDB computes the average price and returns it to Postgres. 6. Postgres joins the result with local portfolio data and computes the unrealized PnL. 7. The final result is returned to the application.

Denis Magda

28,597 次观看 • 7 个月前

At scale, you can only put off sharding for so long. YouTube scaled MySQL with Vitess, and now we're building the same for Postgres.

At scale, you can only put off sharding for so long. YouTube scaled MySQL with Vitess, and now we're building the same for Postgres.

PlanetScale

55,021 次观看 • 4 个月前

Just Use Postgres feat. Denis Magda Denis literally just published a book called “Just Use Postgres”. In this conversation, that turned out to be super fun, we talked about: • what MySQL got wrong w.r.t community • the recent explosion of Postgres development in the world (Supabase, Neon, Crunchy, ClickHouse) • when Postgres instead of Kafka • the significance of the meme “just use postgres” • Postgres for data analytics Chapters (00:00) Intro (04:26) The Just Use Postgres Movement (08:36) The Small Data Trend and Its Implications (15:49) The Shift from Distributed Systems to Simplicity (17:15) Updating your priors re: PG capabilities (20:28) MySQL's OSS community split & our experiences with such things (39:48) Postgres for Analytics (55:49) PG in the lake house (59:27) AI Marketing Slop (01:02:19) How you'd build a brand new app on Postgres (01:05:24) Speedrun through PG extensions (01:11:56) PG as a Message Queue

Stanislav Kozlovski

13,036 次观看 • 8 个月前

Why are there so many ways to connect to Postgres? Because each method has tradeoffs. The right choice depends on your architecture. Let's break down 5 connection methods including direct, PgBouncer, and Hyperdrive.

Why are there so many ways to connect to Postgres? Because each method has tradeoffs. The right choice depends on your architecture. Let's break down 5 connection methods including direct, PgBouncer, and Hyperdrive.

PlanetScale

16,681 次观看 • 9 个月前

15 years ago, Instagram outgrew a single Postgres server. Their fix was splitting data across many servers + a custom Django database abstraction. 15 years later, Neki allows you to manage this distribution with a single JSON file: the data topology.

15 years ago, Instagram outgrew a single Postgres server. Their fix was splitting data across many servers + a custom Django database abstraction. 15 years later, Neki allows you to manage this distribution with a single JSON file: the data topology.

PlanetScale

134,234 次观看 • 1 个月前