Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

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 views • 5 months ago •via X (Twitter)

Education Science & Technology

Anya Rossi• Live Now

Private livecam show

0 Comments

No comments available

Comments from the original post will appear here

Related Videos

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 views • 3 months ago

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 views • 7 months ago

PlanetScale now supports Postgres.

PlanetScale now supports Postgres.

PlanetScale

934,048 views • 1 year ago

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 views • 7 months ago

Introducing dba: The Autonomous AI Agent for Postgres

Introducing dba: The Autonomous AI Agent for Postgres

Tembo

26,537 views • 1 year ago

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 views • 10 months ago

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 views • 9 months ago

`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 views • 4 months ago

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 views • 1 year ago

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 views • 8 months ago

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 views • 1 month ago

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 views • 5 months ago

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 views • 1 year ago

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 views • 1 month ago

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 views • 7 months ago

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 views • 1 year ago

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 views • 1 month ago

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 views • 5 months ago

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 views • 1 year ago

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 views • 6 months ago