Загрузка видео...

Не удалось загрузить видео

На главную

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.

gwenshap's profile picture

Gwen (Chen) Shapira

29,409 subscribers

27,568 просмотров • 1 год назад •via X (Twitter)

ОбразованиеНаука и технологии
LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 3

Фото профиля Him
Him1 год назад

Thank you for this.

Фото профиля GregTheDev
GregTheDev1 год назад

Very helpful! Thanks.

Фото профиля Doni Rubiagatra
Doni Rubiagatra1 год назад

@ameliaarahman mel bikin gini mel haha

Похожие видео

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.
2:31

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,016 просмотров • 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
1:30:33

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 просмотров • 4 месяцев назад

SpacetimeDB it can actually. video calls with Postgres
1:29

SpacetimeDB it can actually. video calls with Postgres

Nick Van Wiggeren

133,265 просмотров • 3 месяцев назад

📣 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!
2:08

📣 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,409 просмотров • 7 месяцев назад

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
3:39

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 год назад

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! ➡️ 🚀
2:20

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 просмотров • 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!!
0:33

`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 просмотров • 3 месяцев назад

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
0:27

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 просмотров • 1 год назад

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.
0:32

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 просмотров • 7 месяцев назад

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!
6:25

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 просмотров • 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.
0:24

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,456 просмотров • 3 месяцев назад

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

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

Deno

21,004 просмотров • 7 месяцев назад

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 🔥
1:13

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 просмотров • 1 год назад

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

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

Greg Richardson

192,310 просмотров • 1 год назад

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
0:25

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 просмотров • 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.
1:45

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 просмотров • 6 месяцев назад

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
0:27

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 просмотров • 4 месяцев назад

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
0:57

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 просмотров • 1 год назад

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

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

PlanetScale

114,667 просмотров • 4 месяцев назад

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

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 просмотров • 1 год назад