Larry Ellison was Right (kinda)! TypeScript Stored Procedures for the Modern Age (James Cowling)

James Cowling presents "SQL or Death," a seminar filmed at Carnegie Mellon University, focusing on attempts to replace SQL and improve it through query optimizers. Cowling argues for revisiting database stored procedures, specifically using TypeScript, to address the shortcomings of current database interactions for application developers. He critiques the traditional API service model and the more recent serverless approach, advocating for functions that run directly within the database in a transaction. The talk covers the history and drawbacks of PL/SQL, proposes a rethinking of stored procedures with TypeScript, and introduces the Convex Runtime as an implementation. He also touches on transactionality, concurrency control, query language, caching, subscriptions, and the potential of LLMs in writing queries as code, followed by a Q&A session.