Chart standing · US
What changed · US
Listing changes AppTracker has observed for this app in this storefront — new versions, price moves, rating shifts, and store copy.
• Materialized views are here. Browse them alongside your tables and views, with a dedicated details panel showing columns, data, the SQL definition, indexes, and statistics (size, row count, and whether the view is populated). • Manage materialized views without leaving the app: create them, refresh (including concurrent refresh), edit the definition, rename, drop, add or remove indexes, and edit comments. • Full management for regular views too: create, edit the definition, rename, and drop — with a dedicated SQL Definition tab. • Export materialized view and view data to CSV. • Fixed DigitalOcean sign-in so connecting your cloud databases works reliably. • Updated underlying libraries and tooling for better stability.
Similar apps
Competitors and close alternatives, as estimated by AppTracker.
About
Desktop-Class Database Management in Your Pocket Transform your iPhone and iPad into a powerful PostgreSQL client with PG Orbit - the first mobile-first database management app designed for developers, DBAs, and data professionals who need secure database access on the go. Why Choose PG Orbit? Unlike desktop-only tools, PG Orbit brings professional database management to iOS with an intuitive touch interface that doesn't compromise on functionality or security. FREE FEATURES: • Browse & Query - Explore tables, views, and execute SELECT queries with advanced filtering • Advanced Filtering - Multi-column filters with AND/OR logic and custom operators • Table Designer - Create and modify database tables with intuitive visual editor • Secure Connections - SSL/TLS encryption and SSH tunneling with key management • SSH Key Management - Store and manage SSH private keys securely with passphrase support • Multiple Connections - Connect to and manage multiple databases simultaneously • Cloud Database Discovery - Automatically discover and connect to PostgreSQL databases across major cloud providers (AWS, Google Cloud, Azure, DigitalOcean, Linode) with one-tap setup • Interactive Data Viewing - Touch-optimized data browsing with responsive design • Mobile-First Design - Adaptive UI for iPhone, iPad, and iPad Pro with gesture navigation • Schema Explorer - Navigate databases, tables, views, functions, and sequences • Query Editor - Built-in SQL editor with syntax support and quick action chips PREMIUM FEATURES ($9.99): • Write Operations - Full INSERT, UPDATE, DELETE, CREATE, ALTER, DROP capabilities • CSV Export - Export query results and table data with progress tracking • Advanced Queries - Complex SQL features, stored procedures, and DDL operations • Cell Editing - Direct data editing with context menus and validation • Table Modifications - Apply table structure changes with preview and validation SECURITY FIRST: • Biometric Protection - Secure your app with Touch ID, Face ID, or Fingerprint • Auto-Lock Security - Automatic app lock when switching between apps • SSH Key Management - Securely store RSA, Ed25519, and OpenSSH private keys • Passphrase Protection - Encrypted storage of SSH key passphrases in iOS Keychain • Encrypted Storage - Industry-standard encryption using iOS secure storage • SSL/TLS Support - Secure database connections with certificate validation • SSH Tunneling - Enhanced security with password and key-based authentication • Local Storage - Your credentials stay on your device, never on external servers iOS OPTIMIZED: • Native iOS interface with familiar gestures and navigation patterns • Adaptive layouts for iPhone, iPad, and iPad Pro with split-screen support • Dark Mode support following iOS system preferences automatically • Enhanced Connection Monitoring - Stable SSH connections with network detection • Optimized performance for iOS hardware and battery life • Seamless integration with iOS sharing, Files app, and multitasking • Touch-friendly data tables with swipe gestures and context menus PERFECT FOR: • Database administrators managing PostgreSQL remotely • DevOps engineers using key-based authentication • Developers debugging queries on the go • Data analysts exploring datasets with export capabilities • Students learning SQL and database concepts • Teams needing secure mobile database access
What's new · 2.0.1
• Materialized views are here. Browse them alongside your tables and views, with a dedicated details panel showing columns, data, the SQL definition, indexes, and statistics (size, row count, and whether the view is populated). • Manage materialized views without leaving the app: create them, refresh (including concurrent refresh), edit the definition, rename, drop, add or remove indexes, and edit comments. • Full management for regular views too: create, edit the definition, rename, and drop — with a dedicated SQL Definition tab. • Export materialized view and view data to CSV. • Fixed DigitalOcean sign-in so connecting your cloud databases works reliably. • Updated underlying libraries and tooling for better stability.
Details