OLTP mode (coming soon)

OLTP mode will add a managed PostgreSQL database beside your Sail cluster: a transactional database for apps that read and write single rows fast, which you can also query from Sail next to your lakehouse tables.

What it will be

• One PostgreSQL 17 database per Sail cluster, run as Azure Database for PostgreSQL Flexible Server.
• A switch on the cluster card. Off by default; turn it on when you create the cluster or later.
• A real transactional database. Reads and writes, transactions and indexes, for apps that need them.
• A connection panel with the host, port, database, user, password, a JDBC URL and a psql command, so any Postgres driver can connect. Connections require SSL.
• The same network access as the cluster. On Databasin Cloud: Private, Specific IPs or Open, as you set on the cluster.
• Always running. The database stays on, unlike Sail workers, which sleep when idle.

Two ways in

From Sail, the database will look like any other live source, and your access rules decide who can query it:

-- Coming soon: the OLTP database appears in Sail as the live catalog `oltp`
SELECT o.region, sum(o.amount) AS today, avg(h.daily_amount) AS typical_day
FROM oltp.public.orders o
JOIN sandbox.sales.daily_totals h ON h.region = o.region
WHERE o.created_at >= current_date
GROUP BY o.region;

At first, Sail reads from the database and your apps write to it. Writing to it from Sail comes later.

Sizes

Basic and Small are burstable, meant for apps and light use rather than sustained load. You'll be able to resize later; storage only grows.

How it will roll out

Where to go next