正在加载视频...

视频加载失败

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

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 次观看 • 5 个月前 •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,277 次观看 • 3 个月前

Postgres databases now come with LLM-powered index recommendations. Indexes are crucial for database performance, and these recommendations help ensure your queries are executing optimally.

Postgres databases now come with LLM-powered index recommendations. Indexes are crucial for database performance, and these recommendations help ensure your queries are executing optimally.

PlanetScale

38,328 次观看 • 7 个月前

PlanetScale now supports Postgres.

PlanetScale now supports Postgres.

PlanetScale

934,048 次观看 • 1 年前

From the archives of our internal Postgres hack week this past spring.

From the archives of our internal Postgres hack week this past spring.

PlanetScale

15,296 次观看 • 7 个月前

Introducing dba: The Autonomous AI Agent for Postgres

Introducing dba: The Autonomous AI Agent for Postgres

Tembo

26,537 次观看 • 1 年前

This week at PlanetScale, we lowered the price of your Postgres clusters, shipped new extensions, added support for event triggers, and more 👇

This week at PlanetScale, we lowered the price of your Postgres clusters, shipped new extensions, added support for event triggers, and more 👇

PlanetScale

33,699 次观看 • 10 个月前

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,333 次观看 • 9 个月前

`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 次观看 • 4 个月前

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values

Hussein Nasser

143,151 次观看 • 1 年前

Some recent updates to PlanetScale include the release of Vitess 23, dedicated replica PgBouncers, IP restrictions for Postgres, TimescaleDB extension support, plus $5 single nodes and $50 Metal coming soon. We'll also be at KubeCon next week. Stop by booth 643 to chat!

Some recent updates to PlanetScale include the release of Vitess 23, dedicated replica PgBouncers, IP restrictions for Postgres, TimescaleDB extension support, plus $5 single nodes and $50 Metal coming soon. We'll also be at KubeCon next week. Stop by booth 643 to chat!

PlanetScale

30,765 次观看 • 8 个月前

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

14,888 次观看 • 1 个月前

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,473 次观看 • 5 个月前

Whop is building the #1 global creator marketplace. Jack Sharkey, Whop co-founder and CTO, covers how they migrated their 800GB Postgres database to PlanetScale with no downtime and no interruption to site traffic.

Whop is building the #1 global creator marketplace. Jack Sharkey, Whop co-founder and CTO, covers how they migrated their 800GB Postgres database to PlanetScale with no downtime and no interruption to site traffic.

PlanetScale

19,313 次观看 • 1 年前

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

54,848 次观看 • 1 个月前

How do Postgres and MySQL achieve data durability? Our very own Chris Sinjakli spoke at SREcon about how this works and the many engineering challenges it presents.

How do Postgres and MySQL achieve data durability? Our very own Chris Sinjakli spoke at SREcon about how this works and the many engineering challenges it presents.

PlanetScale

11,568 次观看 • 7 个月前

All Create apps now ship with a built-in Postgres database (powered by Neon Postgres) • zero setup. just chat about your app • migrations and queries, added automagically • edit data like a spreadsheet in our viewer • 1 GB free storage Build full stack apps that scale big

All Create apps now ship with a built-in Postgres database (powered by Neon Postgres) • zero setup. just chat about your app • migrations and queries, added automagically • edit data like a spreadsheet in our viewer • 1 GB free storage Build full stack apps that scale big

Anything

70,058 次观看 • 1 年前

All types of databases, Redis, Postgres, Clickhouse, Mysql etc. now display important stats and metrics aswell as most run queries in the Maple service map

All types of databases, Redis, Postgres, Clickhouse, Mysql etc. now display important stats and metrics aswell as most run queries in the Maple service map

Makisuo

243,776 次观看 • 1 个月前

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 次观看 • 5 个月前

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Finish the week with a Postgres video 🌟 All about using JSON in Postgres: - when you should use it - how to use it efficiently - how JSONs actually get stored in postgres.

Gwen (Chen) Shapira

27,599 次观看 • 1 年前

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 次观看 • 6 个月前