Changelog 4/08/22: Transaction mode and RETURNING in Postgres
Airplane lets you transform scripts, APIs, and SQL queries into apps for your team in minutes. If you have feature requests you'd like to see in future changelogs, reply and let us know!
This week we rolled out transaction mode and support for RETURNING in Postgres is now live.
With the introduction of transaction mode, you now have the ability to choose what kind of transaction (auto, read-only, read/write, no transaction) to use on your task. By default you can select "auto" and let Airplane decide, or you can explicitly choose a transaction mode. If a transaction is used, it is committed only if all queries successfully execute. You can see the effective transaction mode in the task logs.
You can read more about transaction mode in our SQL docs: Parameters and query arguments
RETURNING in Postgres
We now support RETURNING clauses in Postgres. Running INSERT, UPDATE, or DELETE queries with RETURNING clauses will now display the returned rows in the outputs.
Subscribe to new blog posts from Airplane: