Tag: SQL

Episode 485: Howard Chu on B+tree Data Structure in Depth

Filed in Episodes by on November 9, 2021 1 Comment
Episode 485: Howard Chu on B+tree Data Structure in Depth

Howard Chu, CTO of Symas Corp and chief architect of the OpenLDAP project, discusses the key features of B+tree data structures, which are the default selection for efficient and predictable storage of sorted data. Host Gavin Henry spoke with Chu about B+tree data structures; why they allow searches, insertions, and deletions in logarithmic time; what […]

Continue Reading »

Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework

Filed in Episodes by on November 17, 2020 0 Comments
Episode 435: Julie Lerman on Object Relational Mappers and Entity Framework

Julie Lerman discusses Object Relational Mappers and Entity Framework with Jeremy Jung. They talk about why we use relational databases with object oriented languages; the benefits of ORM query languages; how specialized databases are reducing the need for ORMs; alternatives to ORMs; using views, stored procedures, and raw SQL with ORMs; the importance of profiling […]

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 413: Spencer Kimball on CockroachDB

Filed in Episodes by on June 17, 2020 0 Comments
Episode 413: Spencer Kimball on CockroachDB

Spencer Kimball, Co-Founder and CEO of Cockroach Labs talks about CockroachDB, an open source distributed database system. Host Akshay Manchale spoke with Kimball about his past experience with relational databases that convinced him of the need for a better open source distributed database. . Spencer talks about challenges involved in using a sharded single node […]

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 »