Stored Procedures The Good, The Bad, and The Elegant скачать в хорошем качестве

Stored Procedures The Good, The Bad, and The Elegant

Stored procedures can speed up application performance by an order of magnitude by executing logic directly inside the database, eliminating communication overhead. But what a pain to use! ‍You write them in a special language. They don’t version like your source code does. Lacking in debugging tools. Completely separate deployment procedure from your application. As a result, many PostgreSQL application developers underutilize them. ‍DBOS engineer, Harry Pierson will show you how the open source DBOS Transact framework automatically compiles your data access logic as stored procedures from directly within your source code. Topics: Stored procedures - the good and the bad Building Postgres back-ends with the DBOS Transact framework The elegant - generating & debugging stored procs with DBOS Transact Performance benchmarks Q&A