Podcast Postgresql terbaik (2024)

1
The Future of Postgres Upgrades | Scaling Postgres 341 14:15

2d ago14:15

14:15

In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/341-the-future-of-postgres-upgrades/ Want to learn more about Postgres per…

1
Rspack v1.1, MOST underrated JavaScript feature, new ESLint features and more EP08 JavaScript News 3:02

1d ago3:02

3:02

In today's episode of This Week in Javascript, We’ve got updates from Rspack, a JavaScript feature that's more powerful than you think, new ESLint updates, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this podcast with your friends!…

1
Denormalization 35:08

1d ago35:08

35:08

Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across recently. Here are some links to things they mentioned: Denormalization https://en.wikipedia.org/wiki/Denormalization Our episode on materialized views https://postgres.fm/episodes/materialized-views Our e…

1
Optimizing your Kafka environment with Superstream 27:41

8d ago27:41

27:41

In this episode, we talk to Yaniv Ben Hemo (Co-founder and CEO of Superstream) to discuss how his company got started and how they're helping optimize Kafka environment. Superstream's homepage (with links to blogs & documentation): https://superstream.ai/ If you have any feedback or suggestions for episodes, you can email us at podcast@pingcap.com.…

1
Do You Need A Vectorizer? | Scaling Postgres 340 16:39

9d ago16:39

16:39

In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/340-do-you-need-a-vectorizer/ Want to learn more about Postgres performance…

1
Claude AI now runs JavaScript, Python beats JavaScript on GitHub, new Node.js versions and more EP07 JavaScript News 3:52

8d ago3:52

3:52

In today's episode of This Week in JavaScript, We’ve got some big updates: Claude AI can now write and execute JavaScript code, Python has now become the #1 language on the GitHub charts, defeating JavaScript, new Node.js versions are out, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcas…

1
Postgres online communities 38:09

11d ago38:09

38:09

Nikolay and Michael discuss online Postgres communities — the ones they prefer, the types of conversations in each, and some other places to ask questions or follow news. Here are some links to things they mentioned: https://www.postgresql.org/community Mailing lists https://www.postgresql.org/list IRC https://www.postgresql.org/community/irc Slack…

1
Validate Everything 1:08:16

14d ago1:08:16

1:08:16

This week we discuss the common occurrence of over-engineered abstractions, digging into post-request logic without losing our minds, analytics, and securing digital assets. Show Links: Mergeloop - https://mergeloop.dev/ Zendesk Breach - https://therecord.media/internet-archive-alleged-zendesk-account-breach Heap Analytics - https://www.heap.io/…

1
Postgres Goes Parquet | Scaling Postgres 339 11:32

16d ago11:32

11:32

In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/339-postgres-goes-parquet/ Want to learn more about Postgres…

1
Generative AI in JavaScript? Microsoft GenAIScript, Svelte 5, Next.js 15 and more EP06 JavaScript News 3:39

15d ago3:39

3:39

In this episode of This Week in Javascript, We’ve got some game-changing updates on Microsoft’s GenAIScript, the long awaited Svelte 5 update, the latest Next.js 15 release, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this podcast with your friends!…

1
Advanced psql 52:37

18d ago52:37

52:37

Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres. Here are some links to things they mentioned: psql docs https://www.postgresql.org/docs/current/app-psql.html Our episode on psql vs GUIs https://postgres.fm/episodes/psql-vs-guis postgres_dba https://github.com/NikolayS/postgres_dba Our ep…

1
Episode 281: OneLake - The OneDrive for Data 31:39

21d ago31:39

31:39

As you start using Fabric, having a central location for your data is crucial. OneLake acts as this unified destination, offering a single, consolidated repository for all your data. In this podcast episode, we explore the core features of OneLake and its benefits with our guest, Mariano Kovo, and discuss how it efficiently handles large amounts of…

1
JSON Goodies In Postgres 17 | Scaling Postgres 338 17:03

23d ago17:03

17:03

In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/338-json-goodies-in-postgres-17/ Want to learn more about Postgres performance? J…

1
JavaScript JS0/JSSugar Proposals, Node.js 23, Next.js 15 RC2 and more EP05 JavaScript News 3:28

22d ago3:28

3:28

In this episode of This Week in Javascript, We’ve got a bunch of exciting updates for you, including the latest Node.js release, a controversial proposal about splitting JavaScript, some killer tools, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this pod…

1
Postgres Gotchas 40:19

25d ago40:19

40:19

Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way. Here are some links to things they mentioned: Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown Postgres Gotchas (list by Ian Barwick) https://sql-info.de/postgresql/postgres-gotchas…

1
A conversation with TiDB Future App Hackathon winners from Indonesia 37:29

27d ago37:29

37:29

In this episode, we talk to two winning team members from the TiDB Future App Hackathon 2024. They are Ahmad Nurfadilah who worked on the Zapfeed project (https://devpost.com/software/zapfeed) plus Ayu Sudi Dwijayanti and Luthfi Arifin who worked on the Hangout AI project (https://devpost.com/software/hangout-ai). All three of them are from Jakarta…

1
77 Times Faster In Postgres 17 | Scaling Postgres 337 14:19

30d ago14:19

14:19

In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over slots and a discussion on Patroni. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/337-77-times-faster-in-po…

1
New TC39 JavaScript Features, TypeScript 5.7 Beta, Node.js v20.18.0 and more EP04 JavaScript News 3:42

29d ago3:42

3:42

In this episode of This Week in Javascript, we talk about the biggest changes coming to JavaScript from the TC39 Conference, Deno 2's Official Release, Typescript 5.7 Beta, some awesome new tools, updates to Bun and Node.js, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly up…

1
How I got started as a developer (& in Postgres) with Tom Lane 1:39:18

1M ago1:39:18

1:39:18

It was not Tom Lane’s plan to become a computer person. Tom’s plan was to be a pinball machine designer. And yet for the last 26 years Tom has been one of the most prolific engineering contributors to Postgres. In this episode of Talking Postgres with Claire Giordano, PostgreSQL luminary Tom Lane walks us through how he got his start as a developer…

1
Advanced EXPLAIN 48:47

1M ago48:47

48:47

Nikolay and Michael discuss some more advanced topics around EXPLAIN, including some tips for complex query plans, some recent improvements, and an idea or two that might make it even better. Here are some links to things they mentioned: Michael’s solo episode on EXPLAIN basics https://postgres.fm/episodes/explain Our episode on auto_explain https:…

1
Database design and modeling with PostgreSQL and MySQL 34:27

1M ago34:27

34:27

In this episode, we talk with Alkin Tezuysal (Director of Services at Altinity) and Ibrar Ahmed (a Principal Engineer at pgEdge) about their recent book "Database Design and Modeling with PostgreSQL and MySQL" and how databases like TiDB help address challenges for modern applications. * Link for the book: https://www.amazon.com/dp/1803233478?ref=p…

1
Episode 280: A Focus on Microsoft Fabric 18:56

1M ago18:56

18:56

At the Microsoft Build Conference in May 2023, Microsoft announced the new Fabric, where you could slice and dice all your data harmoniously within the environment. A few months later, Kevin, Eugene, and I discussed this evolution of the Azure Data platform in episode 267, and our thoughts on the vision for it's future, our expectations, and predic…

1
WDW Passport w/ Doug Sisk 1:03:09

1M ago1:03:09

1:03:09

This week, we’re excited to welcome Doug Sisk, the creator of WDW Passport, a Laravel-powered application designed to help users plan their Disney World trips. Doug shares his journey from developing the app to 'scratch his own itch' and turning it into a successful tool for Disney enthusiasts. We dive into the technical side of things, discussing …

1
More Postgres 17 Highlights | Scaling Postgres 336 12:54

1M ago12:54

12:54

In this episode of Scaling Postgres, we discuss more about the features released with Postgres 17, an example of performance improvements, things to watch out for, and the start of Postgres 18. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/336-more-postgres-17-highlights/ Want to lear…

1
VoidZero, ESLint, Tauri 2.0, MongoDB 8.0 and more EP03 JavaScript News 3:25

1M ago3:25

3:25

In this episode of This Week in Javascript, we talk about VoidZero’s unified JavaScript toolchain, new ESLint features, Tauri 2.0, MongoDB 8.0, and more. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this podcast with your friends!…

1
Patroni 45:33

1M ago45:33

45:33

Michael and Nikolay are joined by Alexander Kukushkin, PostgreSQL contributor and maintainer of Patroni, to discuss all things Patroni — what it is, how it works, recent improvements, and more. Here are some links to things they mentioned: Alexander Kukushkin https://postgres.fm/people/alexander-kukushkin Patroni https://github.com/patroni/patroni …

1
Building for Clients or Ourselves? Sticky & Static 1:08:37

1M ago1:08:37

1:08:37

This week, we follow up on last week’s local fakes discussion and explore what it would take for us to fully embrace Statamic. We also tackle the big question: Do clients even use a CMS after it’s built? Maybe it’s just us, but the answer seems to be a majority time of no. YAGNI, anyone? And, in exciting news, Dalton drops not one but TWO new produ…

1
Postgres 17 Released! | Scaling Postgres 335 18:32

1M ago18:32

18:32

In this episode of Scaling Postgres, we discuss the release of Postgres 17, b-tree performance gains, logical replication enhancements and different levels of performance tuning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/335-postgres-17-released/ Want to learn more about Postgres …

1
Deno 2.0, Storybook 8.3, PostgreSQL 17 and more EP02 JavaScript News 3:34

1M ago3:34

3:34

In this episode of This Week in Javascript, we talk about the updates from Deno 2.0, Storybook 8.3 updates, Solid 1.9 improvements, PostgreSQL 17 features. Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this podcast with your friends!…

1
Postgres 17 42:03

2M ago42:03

42:03

Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some considerations for upgrading. Here are some links to things they mentioned: Postgres 17 release notes https://www.postgresql.org/docs/17/release-17.html transaction_timeout episode https://postgres.fm/episodes…

1
Local API Mocking, Flux & Accessibility, PostgreSQL, Web Dev Battles 1:00:20

2M ago1:00:20

1:00:20

In this episode, we cover the launch of Caleb’s Flux UI component library, and dive into the benefits of mocking APIs locally for faster development. We also highlight Aaron Francis’ new Postgres course, and wrap things up with the web dev battle YouTube channel and how a foodie app we built, QuizKnows, played a role in landing our first jobs. Show…

1
Optimizing For Analytics | Scaling Postgres 334 21:55

2M ago21:55

21:55

In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/334-optimizing-for-analytics/ Want to learn more about P…

1
TypeScript v5.6, Bun v1.1.28, Fastify and more EP01 JavaScript News 3:20

2M ago3:20

3:20

In this episode of This Week in Javascript, we talk about the updates from TypeScript 5.6, how Bun lets you compile C code directly in JavaScript, new updates with Fastify and more! Visit ThisWeekinJavaScript.com to subscribe to our Newsletter. Make sure you subscribe to the podcast for weekly updates and share this podcast with your friends!…

1
Episode 279: SQL Server Migrations Demystified 1:03:07

2M ago1:03:07

1:03:07

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another database into SQL Server. No matter which way you slice it, SQL Server migrations can be daunting, not to mention complex and time-consuming. While we …

1
Planning time 42:17

2M ago42:17

42:17

Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and some tips for avoiding issues. Here are some links to things they mentioned: Query Planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.html Are there limits to partition counts? (Blog pos…

1
Becoming a Postgres committer with Melanie Plageman 1:22:38

2M ago1:22:38

1:22:38

If you could work on anything, would you quit your job to pursue it? Postgres committer and major contributor Melanie Plageman joined Claire Giordano on this episode of the Talking Postgres podcast (formerly Path To Citus Con) to share her story about becoming a Postgres committer. Melanie pivoted from IT consulting to open-source development, driv…

1
Operational Data Store with TiDB 28:44

2M ago28:44

28:44

In this episode, we talk to Brian Foster (Director of Content Marketing at PingCAP) about the recent InfoWorld article titled "Operational Data Store with TiDB." We discuss our engagement with the periodical, what an Operational Data Store is, and why TiDB is a good database as an Operational Data Store. Link to the InfoWorld article: https://www.i…

1
When Select Writes! | Scaling Postgres 333 13:38

2M ago13:38

13:38

In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/333-when-select-writes/ Want to learn more about Postgres performance? Join my FREE training called Postgr…

1
Slow count 43:25

2M ago43:25

43:25

Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are some links to things they mentioned: Aggregate functions (docs) https://www.postgresql.org/docs/current/functions-aggregate.html PostgREST https://github.com/PostgREST/postgrest Get rid of count by default in Pos…

1
57 Million Reasons to Love Laravel 1:02:02

2M ago1:02:02

1:02:02

In this episode, Andy and Dalton dive into a wide array[] of topics, from Laravel's exciting $57 million funding to the buzz around FluxUI’s pricing drama and the much-anticipated features coming in Inertia 2.0. Along the way, they explore the need for a modernized PHP documentation (shoutout to Tim McDonald for his work!), a fun chat about Dalton’…

1
Sometimes It Is Slow? | Scaling Postgres 332 15:10

2M ago15:10

15:10

In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/332-sometimes-it-is-slow/ Want to learn more about Postgres performance? J…

1
Skip scan 57:49

2M ago57:49

57:49

Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to PostgreSQL over versions 17 and 18. Here are some links to things they mentioned: Peter Geoghegan https://postgres.fm/people/peter-geoghegan Peter’s previous (excellent) interview on Postgres TV https://www.youtube.…

1
The real jackpot is the Laravel community 53:35

2M ago53:35

53:35

This week, we're diving into all things post-Laracon! Andy shares his wild adventure just getting to Dallas with a few unexpected twists and turns along the way. We break down the highlights from Laracon, including the exciting announcements about Laravel Cloud and the amazing talks that left us inspired and ready to code. But what truly makes Lara…

1
Is pg_dump A Backup Tool? | Scaling Postgres 331 17:31

2M ago17:31

17:31

In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/ Want to learn more about Postgres perfor…

1
Postgres Emergency Room 45:27

2M ago45:27

45:27

Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. Here are some links to things they mentioned: Site Reliability Engineering resources from Google https://sre.google GitLab Handbook SRE https://handbook.gitlab.com/job-families/engineering/infrastructure/site-reli…

1
Migration Playbook 31:08

3M ago31:08

31:08

In this episode, we sit down with Brain Walters (Head of Solution Engineering at PingCAP ) and Kyle Cao (Solution Engineer at PingCAP) to discuss the Database Migration Playbook their team has been developing. HTAP Summit: https://www.pingcap.com/htap-summit/ If you have any feedback or suggestions for episodes, you can email us at podcast@pingcap.…

1
Those aren't NBA players, just a bunch of nerdy developers 1:05:04

3M ago1:05:04

1:05:04

We dive into NullStar 2024, the ultimate basketball showdown between Team Laravel and the Terminal Boys. We share our admiration for Caleb Porzio (who’s definitely on Team Laravel!). Plus, we explore staying productive in development, Andy's ambitious idea to track all Laravel events, and Dalton's latest package release—Remote Models. If you're at …

1
Splicing Elephant & Duck DNA | Scaling Postgres 330 14:58

3M ago14:58

14:58

In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics and building a search engine. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/330-splicin…

1
Get or Create 50:19

3M ago50:19

50:19

Michael and Nikolay are joined by Haki Benita, a technical lead and database enthusiast who writes an excellent blog and gives popular talks and training sessions too, to discuss the surprisingly complex topic of trying to implement “get or create” in PostgreSQL — handling issues around idempotency, concurrency, and bloat. Here are some links to th…

1
The gap between the last Standard Plan and Enterprise 1:06:49

3M ago1:06:49

1:06:49

This week, we dive into A/B testing and the challenges that come with the jump from the highest non-enterprise plan to full enterprise. We also discuss some Laravel shop talk, sharing the tools we've been using recently. Plus, Andy introduces his new podcast idea, where he plans to interview Laravel community members and explore their unique develo…

Podcast Layak Disimak

Postgresql Podcast

Podcast Layak Disimak

Panduan Referensi Cepat