A weekly podcast about all things PostgreSQL
…
continue reading
Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.
…
continue reading
Talking Postgres is a podcast for developers who love Postgres. Formerly called Path To Citus Con, guests join Claire Giordano each month to discuss the human side of PostgreSQL, databases, and open source. With amazing guests such as Boriss Mejías, Melanie Plageman, Simon Willison, Floor Drees, and Andres Freund, Talking Postgres is guaranteed to get you thinking. Recorded live on Discord by the Postgres team at Microsoft, you can subscribe to our calendar to join us live on the parallel te ...
…
continue reading
Learn from your favorite indie hackers as they share hard-earned lessons and tall tales from their data model journeys! Brought to you by Xata — the only serverless data platform for PostgreSQL.
…
continue reading
A podcast series where we discuss community, database, open source, and other topics. Email us at podcast@pingcap.com for your feedback or suggestions.
…
continue reading
This week's JavaScript news, in 5 min or less.
…
continue reading
Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
…
continue reading
The Midwest Artisan Podcast brings you insights and discussions on all things Laravel, with a healthy dose of general web development and tech talk. Join Andy Hinkle and Dalton McCleery, two passionate Laravel developers from the Midwest, as they share their expertise, explore the latest trends, and dive into the world of coding. Whether you're a seasoned developer or just getting started, this podcast offers something for everyone who loves tech and Laravel. Connect with us: Andy Hinkle - X ...
…
continue reading
Software Engineering Best Practices, System Design, High Scale, Algorithms, Math, Programming Languages, Statistics, Machine Learning, Databases, Front Ends, Frameworks, Low Level Machine Structure, Papers and Computing, Computer Science Book Reviews - Everything!
…
continue reading
1
The Future of Postgres Upgrades | Scaling Postgres 341
14:15
14:15
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Rspack v1.1, MOST underrated JavaScript feature, new ESLint features and more EP08 JavaScript News
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!…
…
continue reading
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…
…
continue reading
1
Optimizing your Kafka environment with Superstream
27:41
27:41
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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.…
…
continue reading
1
Do You Need A Vectorizer? | Scaling Postgres 340
16:39
16:39
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Claude AI now runs JavaScript, Python beats JavaScript on GitHub, new Node.js versions and more EP07 JavaScript News
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…
…
continue reading
1
Postgres online communities
38:09
38:09
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Validate Everything
1:08:16
1:08:16
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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/…
…
continue reading
1
Postgres Goes Parquet | Scaling Postgres 339
11:32
11:32
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Generative AI in JavaScript? Microsoft GenAIScript, Svelte 5, Next.js 15 and more EP06 JavaScript News
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!…
…
continue reading
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…
…
continue reading
1
Episode 281: OneLake - The OneDrive for Data
31:39
31:39
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
JSON Goodies In Postgres 17 | Scaling Postgres 338
17:03
17:03
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
1
A conversation with TiDB Future App Hackathon winners from Indonesia
37:29
37:29
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
77 Times Faster In Postgres 17 | Scaling Postgres 337
14:19
14:19
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
New TC39 JavaScript Features, TypeScript 5.7 Beta, Node.js v20.18.0 and more EP04 JavaScript News
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…
…
continue reading
1
How I got started as a developer (& in Postgres) with Tom Lane
1:39:18
1:39:18
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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:…
…
continue reading
1
Database design and modeling with PostgreSQL and MySQL
34:27
34:27
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Episode 280: A Focus on Microsoft Fabric
18:56
18:56
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
WDW Passport w/ Doug Sisk
1:03:09
1:03:09
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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 …
…
continue reading
1
More Postgres 17 Highlights | Scaling Postgres 336
12:54
12:54
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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!…
…
continue reading
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 …
…
continue reading
1
Building for Clients or Ourselves? Sticky & Static
1:08:37
1:08:37
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Postgres 17 Released! | Scaling Postgres 335
18:32
18:32
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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 …
…
continue reading
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!…
…
continue reading
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…
…
continue reading
1
Local API Mocking, Flux & Accessibility, PostgreSQL, Web Dev Battles
1:00:20
1:00:20
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Optimizing For Analytics | Scaling Postgres 334
21:55
21:55
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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!…
…
continue reading
1
Episode 279: SQL Server Migrations Demystified
1:03:07
1:03:07
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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 …
…
continue reading
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…
…
continue reading
1
Becoming a Postgres committer with Melanie Plageman
1:22:38
1:22:38
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Operational Data Store with TiDB
28:44
28:44
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
When Select Writes! | Scaling Postgres 333
13:38
13:38
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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…
…
continue reading
1
57 Million Reasons to Love Laravel
1:02:02
1:02:02
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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’…
…
continue reading
1
Sometimes It Is Slow? | Scaling Postgres 332
15:10
15:10
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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.…
…
continue reading
1
The real jackpot is the Laravel community
53:35
53:35
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
1
Is pg_dump A Backup Tool? | Scaling Postgres 331
17:31
17:31
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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…
…
continue reading
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.…
…
continue reading
1
Those aren't NBA players, just a bunch of nerdy developers
1:05:04
1:05:04
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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 …
…
continue reading
1
Splicing Elephant & Duck DNA | Scaling Postgres 330
14:58
14:58
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading
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…
…
continue reading
1
The gap between the last Standard Plan and Enterprise
1:06:49
1:06:49
Daha Sonra Çal
Daha Sonra Çal
Listeler
Beğen
Beğenildi
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…
…
continue reading