Tag: SQL

Episode 504: Frank McSherry on Materialize

Filed in Episodes by on March 22, 2022 0 Comments
Episode 504: Frank McSherry on Materialize

Frank McSherry, chief scientist at Materialize, talks about the Materialize streaming database, which supports real-time analytics by maintaining incremental views over streaming data. Host Akshay Manchale spoke with Frank about various ways in which analytical systems are built over streaming services today, pitfalls associated with those solutions, and how Materialize simplifies both the expression of […]

Continue Reading »

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 »