On August 15, I presented a webcast about using the DBOS Transact library to compile application code into PostgreSQL stored procedures. The Good is

Stored Procedures: The Good, The Bad, and The Elegant

submited by

Style Pass

2024-10-26 22:30:04

On August 15, I presented a webcast about using the DBOS Transact library to compile application code into PostgreSQL stored procedures. The Good is that stored procedures can speed up application performance a lot. The Bad is that implementing and managing them can be prohibitively challenging. The Elegant is the way DBOS Transact eliminates those challenges, making it easier to build faster backends.

Here is the recording of the webcast, the slides I presented, and the answers to the questions asked by the live audience (below).

A:Yes you can. In DBOS Transact applications, @storedprocedure functions return a JSON object containing the outcome of the stored procedure and supporting details, like success and result, or error and error detail, etc. I explain this at the 35:00 mark in the webinar recording video.

A: This is fully explained in this DBOS vs. AWS Lambda performance benchmark. DBOS is 15x more cost-efficient than AWS Lambda when executing transactional applications that orchestrate interactions with back-end databases or remote functions. Unlike AWS Lambda, DBOS…