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.

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

29,409 subscribers

27,568 views • 1 year ago •via X (Twitter)

Education Science & Technology

Anya Rossi• Live Now

Private livecam show

3 Comments

Him1 year ago

Thank you for this.

GregTheDev1 year ago

Very helpful! Thanks.

Doni Rubiagatra1 year ago

@ameliaarahman mel bikin gini mel haha

Related Videos

Your Launchpad for Postgres: Get a Postgres connection URL in seconds, use your DB, claim it later. Perfect for building products like Netlify DB, OSS projects, and agents.

Your Launchpad for Postgres: Get a Postgres connection URL in seconds, use your DB, claim it later. Perfect for building products like Netlify DB, OSS projects, and agents.

Neon Postgres

21,019 views • 1 year 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 • 4 months ago

SpacetimeDB it can actually. video calls with Postgres

SpacetimeDB it can actually. video calls with Postgres

Nick Van Wiggeren

133,265 views • 3 months ago

📣 My next course, Introduction to Postgres, is going to be 100% free! The kind folks at Supabase are sponsoring it so that everyone can learn how to use Postgres confidently. But that's not all... I'm changing things up a bit. I'm making a bet. Watch the video to see more!

📣 My next course, Introduction to Postgres, is going to be 100% free! The kind folks at Supabase are sponsoring it so that everyone can learn how to use Postgres confidently. But that's not all... I'm changing things up a bit. I'm making a bet. Watch the video to see more!

Aaron Francis

332,441 views • 7 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

Code along with me as I show you how to build a full-stack Uber Clone with #ReactNative! 🔥 We tried Expo's latest API route features to integrate a Postgres db (Neon Postgres) with payments using Stripe, and it just works. It's very easy to use and get started without any issues so far. Evan Bacon 🥓 See the tutorial here! ➡️ 🚀

Code along with me as I show you how to build a full-stack Uber Clone with #ReactNative! 🔥 We tried Expo's latest API route features to integrate a Postgres db (Neon Postgres) with payments using Stripe, and it just works. It's very easy to use and get started without any issues so far. Evan Bacon 🥓 See the tutorial here! ➡️ 🚀

Adrian | JavaScript Mastery

14,514 views • 1 year 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 • 3 months ago

We built a no-signup Postgres tool 📸 - Get a Postgres URL in a second, from your browser or terminal - If you want to keep your database, transfer it to your Neon account It uses Cloudflare, React Router, and Drizzle ORM under the hood

We built a no-signup Postgres tool 📸 - Get a Postgres URL in a second, from your browser or terminal - If you want to keep your database, transfer it to your Neon account It uses Cloudflare, React Router, and Drizzle ORM under the hood

Neon Postgres

26,526 views • 1 year ago

I benchmarked 96 combinations of Postgres 17 and 18. There's a few surprising results, but overall Postgres 18 has some nice improvements. Read all about it at the link below.

I benchmarked 96 combinations of Postgres 17 and 18. There's a few surprising results, but overall Postgres 18 has some nice improvements. Read all about it at the link below.

Ben Dicken

11,395 views • 7 months ago

JSON columns in Postgres can be flexible, but too much flexibility can be risky as you might accidentally end up with malformed data. You can prevent this using the pg_jsonschema extension to easily define a schema for your JSON and JSONB columns!

JSON columns in Postgres can be flexible, but too much flexibility can be risky as you might accidentally end up with malformed data. You can prevent this using the pg_jsonschema extension to easily define a schema for your JSON and JSONB columns!

Tyler Shukert

17,480 views • 1 year 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,461 views • 4 months ago

Zero to database in record time, with Deno Deploy and Prisma Postgres Try it now at

Zero to database in record time, with Deno Deploy and Prisma Postgres Try it now at

Deno

21,004 views • 7 months ago

With PGlite + Electric sync you can build an issue tracker handling 100k issues + 500k comments, synced from Postgres to PGlite in the browser! Super fast UI updates with all writes going though the local database, and Postgres FTS in PGlite for search 🔥

With PGlite + Electric sync you can build an issue tracker handling 100k issues + 500k comments, synced from Postgres to PGlite in the browser! Super fast UI updates with all writes going though the local database, and Postgres FTS in PGlite for search 🔥

Sam Willis

55,402 views • 1 year ago

Excited to introduce the in-browser Postgres sandbox with AI assistance 🚀

Excited to introduce the in-browser Postgres sandbox with AI assistance 🚀

Greg Richardson

192,310 views • 1 year ago

using tools, Cursor Agent have the capability to reason about when it should - read & write code - search your codebase - call MCP servers - run terminal commands an example where it connects to a postgres database, runs a query and writes to file

using tools, Cursor Agent have the capability to reason about when it should - read & write code - search your codebase - call MCP servers - run terminal commands an example where it connects to a postgres database, runs a query and writes to file

eric zakariasson

34,917 views • 1 year 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 • 6 months ago

Claude Code Templates is now part of the Neon Postgres Open Source Program. One command to get a full Postgres setup for Claude Code. What you get: - 2 Skills (instant Postgres provisioning + best practices) - 5 Agents (schema design, auth, migrations, optimization, general) - 1 MCP (Neon management API) - 2 Statuslines (dev metrics + resource monitoring) 10 components with one command. Neon Database expert ready in 5 seconds

Claude Code Templates is now part of the Neon Postgres Open Source Program. One command to get a full Postgres setup for Claude Code. What you get: - 2 Skills (instant Postgres provisioning + best practices) - 5 Agents (schema design, auth, migrations, optimization, general) - 1 MCP (Neon management API) - 2 Statuslines (dev metrics + resource monitoring) 10 components with one command. Neon Database expert ready in 5 seconds

Daniel San

12,443 views • 4 months ago

Copy my dashboard - If you want ✨ Done with the dashboard for Propdock - Been using Cursor + v0 for almost the whole project. All components are from shadcn 🐐 ◆ Examples on how to use server actions ✨ ◆ Charts and stuff 📈 ◆ Feel free to copy it if you want 🔥 The project is Open-source so take what you want. Rest of the weekend im going to write issues for the community 🪄 Tech Stack: Vercel NextAuth.js Prisma Postgres shadcn Neon - Serverless Postgres Resend Tailwind CSS v0 #opensource #buildinpublic #proptech

Copy my dashboard - If you want ✨ Done with the dashboard for Propdock - Been using Cursor + v0 for almost the whole project. All components are from shadcn 🐐 ◆ Examples on how to use server actions ✨ ◆ Charts and stuff 📈 ◆ Feel free to copy it if you want 🔥 The project is Open-source so take what you want. Rest of the weekend im going to write issues for the community 🪄 Tech Stack: Vercel NextAuth.js Prisma Postgres shadcn Neon - Serverless Postgres Resend Tailwind CSS v0 #opensource #buildinpublic #proptech

CodeHagen

60,355 views • 1 year ago

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins

Replit Agent (launched today) built a startup landing page with waitlist and postgres db from start to finish in <4 mins

Aman Mathur

236,736 views • 1 year ago

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

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

PlanetScale

114,683 views • 4 months ago