PG Orbit - Postgres Client

**Cloud Database Discovery** Connecting to cloud databases has never been easier. PG Orbit now automatically discovers your PostgreSQL instances across major cloud providers, so you can connect with a single tap. - **Multi-Cloud Support**: Instantly find databases on Amazon Web Services (AWS), Google Cloud, Microsoft Azure, DigitalOcean, and Linode. - **Effortless Discovery**: Securely sign in to your cloud provider and let PG Orbit handle the rest. No more manual configuration. - **One-Tap Connections**: Add new database connections from the discovered list in seconds. **General Improvements** - Fixed biometric authentication requiring an app restart to fully work. - We've squashed some bugs and made performance improvements for a faster, more reliable experience.

Row Insertion & Table Editing - Add New Row (Premium): insert rows via a dedicated dialog with optimistic updates - Table Structure Editor: fixed incorrect data type display; improved apply/preview reliability Purchases & Pricing - Premium price updated to $9.99 General Improvements - Faster, more stable database browsing and query execution - UI polish (premium badge, theme tweaks, sequence details) - Dependency upgrades and numerous bug fixes

- Added support to AWS Aurora DSQL Postgres compatible databases.

Added - Supabase as a supported cloud provider, including OAuth sign-in and manual password capture when importing databases. - New inspector panel in the query grid that shows the active cell value with row controls and an in-place editor for premium users. - Database browser can now create and delete databases, including an optional force-drop flow. - Added a restore purchases button on the paywall and settings screens so users can easily regain premium access after reinstalls. - Create Table dialog redesigned with mobile-friendly tab navigation, responsive action buttons, and improved SQL preview layout. - It's now possible to delete tables, including an optional drop with cascade. Fixed - SELECT current_time; showed binary output, it correctly show the datetime now. - Show NULL on null numbers instead of 0. - Improved connection edit action buttons. - Better error messages when query results are empty. - Better success messages when query has no return values. - General improvements to stability and security.

- Can now clone a connection for faster setup. - Reuse persistent PostgreSQL connections across query editor, schema/browser flows, and admin operations for snappier round-trips while releasing them automatically on close.

New: - Supercharged query editor autocomplete: instant PostgreSQL keyword hints, one-tap table suggestions with schema context, and inline column/type recommendations that stay visible even when the keyboard is up. Fixed: - Decode binary-encoded PostgreSQL `oid` and boolean values so system catalog queries (e.g. `SELECT * FROM pg_roles;`) show readable results in the inspector. - Connection create/edit forms now disable autocorrect on technical fields so hostnames, usernames, and ports stay untouched while the connection name remains editable with suggestions.

Fixed query history initialization so history, favorites, and stats load without errors after running queries

Added: - SSL mode selector in connection form with options: require and verify-full. - CA Certificate field for pasting PEM certificates when using Verify-Full SSL mode - Advanced SSL Options section for client certificate and private key (mutual TLS authentication) General bug fixes and improvements.

- Hardened schema loading to qualify `pg_namespace` OIDs and gracefully fall back when descriptions are unavailable, so browsing works on databases that hide system OIDs.

Much more reliable editing and insertion of JSON/JSONB values — smart quotes and tricky characters now work smoothly without errors Better reconnection handling: the app automatically recovers when switching servers or after network interruptions Switching servers no longer causes table selection glitches or stale data Updated CSV export to the latest format for better compatibility General stability & dependency updates

Tables and views with the same name in other schemas no longer appear multiple times when browsing a schema

Columns in the Structure tab no longer appear multiple times when the same table or view name exists in other schemas

Database listing no longer fails on Heroku-managed Postgres (and other shared hosting) when the server contains databases the user lacks permission to access. Inaccessible databases are filtered out, and a subtle note shows how many were hidden.

Filter panel and toolbar no longer disappear when a filter returns no results.

- Full internationalization (i18n) support with English and Spanish. - Language picker in Settings to switch between System, English, and Español. - Cut/Copy/Paste toolbar now appears when long-pressing in the SQL query editor. - Scroll position is now preserved when navigating back from a table to the database/connection list. Previously the list would reset to the top.

A real PostgreSQL client on your phone. Browse schemas, run queries, and fix data from your iPhone or iPad with PG Orbit — the PostgreSQL client built for developers, DBAs, and data professionals who get paged away from their desk. NEW IN 2.0: SYNC ACROSS DEVICES • One account — Sign in with Apple, Google, or an email code • Connections and saved queries follow you to every device, including the new Mac app • Passwords, SSH keys, and passphrases NEVER sync — they stay in your device's keychain • Query history sync is opt-in and off by default • Desktop-class workspace on iPad: pinned sidebar, object tabs and SQL tabs, keyboard shortcuts (Cmd+T, Cmd+1–9) FREE FEATURES: • Browse & Query — explore tables and views, run SELECT queries with advanced filtering • Advanced Filtering — multi-column filters with AND/OR logic and custom operators • Schema Explorer — databases, tables, views, materialized views, functions, and sequences; works on hardened hosts like Heroku shared plans • SQL Editor — real autocomplete with schema context, find & replace, comment toggle, saved queries, and history with favorites • Secure Connections — SSL/TLS (Require and Verify-Full with client certificates) and SSH tunneling • SSH Key Management — import and store RSA and Ed25519 private keys with passphrase support, or generate an RSA key on device • Multiple Connections — connect to and manage several databases at once • Cloud Discovery — sign in to AWS, Google Cloud, Azure, DigitalOcean, Linode, or Supabase and import your instances with one tap PREMIUM ($9.99, ONE-TIME — YOURS FOREVER): • Write Operations — INSERT, UPDATE, DELETE, CREATE, ALTER, DROP • In-Place Editing — edit cells directly with a tap, set NULL, insert and delete rows • Visual Table Designer — modify table structure with a preview of the exact DDL before it runs • CSV Export — export query results and table data with progress tracking • Sequence Management — inspect and update sequences easily SYNC (OPTIONAL SUBSCRIPTION): • $1.99/month or $14.99/year, auto-renewing — cancel anytime in the App Store • Syncs connection settings and saved queries; secrets never leave your device • Delete your account (and all synced data) from settings at any time SECURITY FIRST: • Biometric protection with Face ID or Touch ID, and auto-lock on app switch • Credentials stored in the iOS Keychain with industry-standard encryption • Your queries run directly from your device to your database — table data never passes through our servers PERFECT FOR: • DBAs managing PostgreSQL remotely • Developers debugging production from anywhere • DevOps engineers who live behind SSH bastions • Data analysts exploring and exporting datasets • Students learning SQL Free forever for read-only. Premium is $9.99, once. SUBSCRIPTION TERMS Sync is an auto-renewing subscription: $1.99 per month or $14.99 per year. Payment is charged to your Apple Account at confirmation of purchase. It renews automatically unless cancelled at least 24 hours before the end of the current period, and your account is charged for renewal within 24 hours before that period ends. Manage or cancel in your Apple Account settings. Premium ($9.99) is a one-time purchase, not a subscription. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Service terms: https://pgorbit.com/terms-of-service Privacy Policy: https://pgorbit.com/privacy-policy