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

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

Apr 8, 2022
Madhura Kumar

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:

Subscribe to new blog posts from Airplane:

Changelog 8/12/22: Notification Inbox, universal search, and faster task execution

Changelog 8/12/22: Notification Inbox, universal search, and faster task execution

Aug 12, 2022
Madhura Kumar
Since our last changelog, we've rolled out universal search, added notifications to the Inbox, and rolled out faster task execution.
Changelog 7/1/22: HIPAA compliant, Redshift and BigQuery support, and JavaScript templates in environment variables

Changelog 7/1/22: HIPAA compliant, Redshift and BigQuery support, and JavaScript templates in environment variables

Jul 1, 2022
Madhura Kumar
We're excited to announce that Airplane is now HIPAA compliant! This week we rolled out Redshift and BigQuery support in addition to the ability to use JavaScript templates when defining environment variables for your task.
go to home