April 2022 Summaries

The article discusses the SQL vs ORM dilemma and proposes a third option that combines the strengths of both without their weaknesses. It breaks down the debate into several major discussion points such as schema representation, migrations, query syntax, result structure, language integration, performance, and power. The author introduces EdgeDB, an open-source database with its own query language called EdgeQL, designed to solve some of SQL's more unintuitive design aspects. It is a full-fledged query language that is rapidly approaching feature parity with SQL and offers a third path for developers to consider in the SQL vs ORM debate.

Ted Neward's 2006 blog post "The Vietnam of Computer Science" draws an analogy between the challenges of using object-relational mapping (ORM) tools and the U.S. involvement in the Vietnam War, highlighting the diminishing returns and entrapment both scenarios can lead to. The ongoing debate between using SQL versus ORMs is described as an ideological conflict with no clear winner, emphasizing the need for a solution that combines the strengths of both approaches. This text explores the key arguments in this debate, such as schema representation, query syntax, and performance, and introduces EdgeDB as a potential third option. EdgeDB, an open-source database built on Postgres, offers a query language called EdgeQL, which aims to overcome SQL's unintuitive aspects by providing a more object-oriented and composable syntax. By leveraging Postgres's robust features, EdgeDB seeks to address performance issues inherent in ORMs while providing a powerful and intuitive framework for developers. The text concludes by suggesting that EdgeDB offers a new path forward, inviting developers to explore its capabilities.