See how internal tools maximize operational efficiency in data-sensitive environments

Changelog 4/08/22: Transaction mode and RETURNING in Postgres

Changelog 4/08/22: Transaction mode and RETURNING in Postgres

Madhura Kumar
Head of Growth
Apr 8, 2022
1 min read

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.

Transaction mode

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.

Share this article:
Madhura Kumar
Head of Growth
Madhura Kumar is the Head of Growth and a founding team member at Airplane. Prior to Airplane, she led product and strategic initiatives at Palantir.

Subscribe to new blog posts from Airplane.