Changelog

Sync across devices

• Connections and saved queries sync across your devices, with per-entity merging, manual “Sync now”, and auto sync. Pull-to-refresh on the connections list runs a sync too.
• Only metadata syncs — host, port, database, user, SSH settings, and saved queries. Passwords, private keys, and passphrases never leave your device's keychain.
• Query-history sync is available as an opt-in toggle, off by default, with a privacy notice — history contains your raw SQL and error text.
• Sync is an optional auto-renewing subscription: $1.99/month or $14.99/year, with plans and prices visible before you sign in.
• Delete your account from Sync settings to remove the server account and all synced data.

One account, every platform

• Sign in with Apple, Google, or an email code — all three work on iOS, Android, and macOS (Apple sign-in uses the web flow on Android).

Desktop workspace and macOS

• PG Orbit ships on macOS as a signed, sandboxed app with a full menu bar, a unified titlebar, and in-app purchases.
• The connection workspace is now the interface on all devices: a pinned sidebar of open connections, object tabs and SQL query tabs (Cmd+T, Cmd+W, Cmd+1–9), adapting from phone to tablet to desktop width.
• Right-click context menus on connection cards, the schema tree, data grid cells, and the SQL editor; double-click a cell to edit it; keyboard shortcuts everywhere with platform-correct labels (⌘ on macOS).
• SQL editor find and replace (Cmd+F), comment toggle (Cmd+/), and save-and-load named queries.
• Import SSH private and public keys from a file on disk.
• New UI density setting (Compact / Standard) on all platforms.

Under the hood

• StoreKit 2; minimum OS raised to iOS 15 and macOS 12.
• Plenty of fixes: CSV export from the query editor no longer crashes, view definition edits target the right database, generated SSH keys report their passphrase state correctly, and more.

• Materialized views are first-class objects: their own group in the schema tree and a dedicated details view with columns, data, SQL definition, indexes, and statistics.
• Create, refresh (concurrently or with no data), edit, rename, and drop materialized views and regular views; export their data to CSV. Writes are Premium.

• Full hardware keyboard support in the SQL editor: type on any external keyboard, navigate autocomplete with the arrow keys, and press Enter or Tab to insert the highlighted suggestion.
• Smarter autocomplete that updates live as you delete characters.

• Full internationalization: PG Orbit now speaks English and Español, with a language picker in Settings.