Tag: SQL
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 […]
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 […]
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 […]
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 […]
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 […]
SE Radio Alerts
