Tag: databases

Episode 454: Thomas Richter on Postgres as an OLAP database

Filed in Episodes by on April 9, 2021 0 Comments
Episode 454: Thomas Richter on Postgres as an OLAP database

Thomas Richter, founder of Swarm64, discusses the internals of the Postgres open source database project. Host Adam Conrad spoke with Richter about an introduction to relational databases, comparisons of OLAP and OLTP structures, performance considerations, and advanced features of the Postgres architecture. Related Links Swarm64 Postgres homepage A quick explanation of OLAP and OLTP Postgres […]

Continue Reading »

Episode 444: Tug Grall on Redis

Filed in Episodes by on January 30, 2021 0 Comments
Episode 444: Tug Grall on Redis

Tug Grall of Redis Labs discusses Redis, its evolution over the years, and emerging use cases today. Host Akshay spoke with Tug about Redis’ fundamental data structures and their common uses, its module based ecosystem and Redis’ applicability in a wide range of applications beyond being a layer for caching data such as search, machine […]

Continue Reading »

Episode 433: Jay Kreps on ksqlDB

Filed in Episodes by on November 6, 2020 1 Comment
Episode 433: Jay Kreps on ksqlDB

Jay Kreps, CEO and Co-Founder of Confluent discusses ksqlDB which is a SQL engine for data in Apache Kafka. Jay talks about stream processing, Kafka and how the data can now be queried with push/pull queries with ksqlDB, similar to a relational database. Jay discusses some of the similarities and differences between SQL databases and […]

Continue Reading »

Episode 417: Alex Petrov on Database Storage Engines

Filed in Episodes by on July 17, 2020 0 Comments
Episode 417: Alex Petrov on Database Storage Engines

Alex Petrov, author of Database Internals explains the ins and outs of database storage engines. What are they? How do they differ?  What problems do they solve? Host Adam Gordon Bell spoke with Alex about these questions as well as how information is stored on disk, different strategies for building indexes and the difference between […]

Continue Reading »

Episode 397: Pat Helland on Data Management with Microservices

Filed in Episodes by on February 7, 2020 1 Comment
Episode 397: Pat Helland on Data Management with Microservices

Pat Helland, who has been working on building data management systems since 1978, talks to host Akshay Manchale about Data Management at scale with Microservices. Pat talks about trends in storage and computing, state management, immutable data storage, and idempotent computation. He also talks about various ways to look at data — “inside” vs. “outside,” “prescriptive” […]

Continue Reading »