10月7日的PG Orbit - Postgres Client应用程序分析

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.