SE Radio 623: Michael J. Freedman on TimescaleDB

SE Radio 623: Michael J. Freedman on TimescaleDB

Author: team@se-radio.net (SE-Radio Team) July 3, 2024 Duration: 1:05:43

Michael J. Freedman, the Robert E. Kahn Professor in the Computer Science Department at Princeton University, as well as the co-founder and CTO of Timescale, spoke with SE Radio host Gavin Henry about TimescaleDB. They revisit what time series data means in 2024, the history of TimescaleDB, how it integrates with PostgreSQL, and they take the listeners through a complete setup. Freedman discusses the types of data well-suited for a timeseries database, the types of sectors that have these requirements, why PostgreSQL is the best, Pg callbacks, Pg hooks, C programming, Rust, their open source contributions and projects, data volumes, column-data, indexes, backups, why it is common to have one table for your timeseries data, when not to use timescaledb, IoT data formats, Pg indexes, how Pg works without timescaledb, sharding, and how to manage your upgrades if not using Timescale Cloud. Brought to you by IEEE Computer Society and IEEE Software magazine.


For developers who build the world's most critical systems, Software Engineering Radio offers deep, substantive conversations that move beyond the hype cycle. This isn't about quick tips or news flashes; it's a dedicated audio library for career engineers seeking to solidify their foundational knowledge and explore advanced concepts. Each episode is crafted as an enduring resource, featuring either a comprehensive tutorial breaking down a specific technology or methodology, or a detailed interview with a leading practitioner shaping the field. You'll hear focused discussions on everything from low-level systems architecture and programming language design to team dynamics and project management, all through the lens of professional software creation. The content is exclusively produced for this podcast, ensuring thoughtful, in-depth analysis you won't find simply repackaged from conference talks. If your work demands a rigorous understanding of the craft, this is the podcast for you.
Author: Language: en-us Episodes: 100

Software Engineering Radio - the podcast for professional software developers
Podcast Episodes
SE Radio 647: Praveen Gujar on Gen AI for Digital Ad Tech Platforms [not-audio_url] [/not-audio_url]

Duration: 52:01
Praveen Gujar, Director of Product at LinkedIn, joins SE Radio host Kanchan Shringi for a discussion on how generative AI (GenAI) is transforming digital advertising technology platforms. The conversation starts with a l…
SE Radio 646: Matthew Skelton on Team Topologies [not-audio_url] [/not-audio_url]

Duration: 57:08
Matthew Skelton joins host Giovanni Asproni to talk about team topologies—an approach to organizing teams for fast flow of value. The episode starts with a description of the underlying principles before exploring the ap…
SE Radio 645: Vinay Tripathi on BGP Optimization [not-audio_url] [/not-audio_url]

Duration: 59:22
Vinay Tripathi, a senior network engineer in Google Backbone Engineering and an 18-year network engineering veteran, discusses BGP optimization, a technique that's critical in achieving top goals in distributed applicati…
SE Radio 644: Tim McNamara on Error Handling in Rust [not-audio_url] [/not-audio_url]

Duration: 1:09:12
Tim McNamara, a well-known Rust educator, author of Rust in Action (Manning), and a recipient of a Rust Foundation Fellowship in 2023, speaks with SE Radio host Gavin Henry about error handling in Rust. They discuss the…
SE Radio 643: Ganesh Datta on Production Readiness [not-audio_url] [/not-audio_url]

Duration: 53:15
Ganesh Datta, co-founder of Cortex.io, joins host Robert Blumen for a conversation about production readiness. The conversation covers the history of production readiness; its relationship to microservice architecture; t…
SE Radio 642: Simon Wijckmans on Third-Party Browser Script Security [not-audio_url] [/not-audio_url]

Duration: 1:07:32
Simon Wijckmans, founder of c/side -- a company that focuses on monitoring, securing, and optimizing third-party JavaScript -- joins SE Radio host Kanchan Shringi for a conversation about the security risks posed by thir…
SE Radio 641: Catherine Nelson on Machine Learning in Data Science [not-audio_url] [/not-audio_url]

Duration: 48:19
Catherine Nelson, author of the new O'Reilly book, Software Engineering for Data Scientists, discusses the collaboration between data scientists and software engineers -- an increasingly common pairing on machine learnin…
SE Radio 640: Jonathan Horvath on Physical Security [not-audio_url] [/not-audio_url]

Duration: 59:19
Jonathan Horvath of Z-bit discusses physical access control systems (PACS) with host Jeremy Jung. They start with an overview of PACS components and discuss the proprietary nature of the industry, the slow pace of migrat…
SE Radio 639: Cody Ebberson on Regulated Industries [not-audio_url] [/not-audio_url]

Duration: 39:20
Cody Ebberson, CTO of Medplum, joins host Sam Taggart to discuss the constraints that working in regulated industries add to the software development process. They explore some general aspects of developing for regulated…