PostGrip v0.2

PostGrip v0.2

The PostgreSQL client that gets out of your way.

What's New

Monitoring Panel

• Full-pane monitoring view with 9 server metric cards (CPU, RAM, Cache Hit, TPS, Connections, Uptime, DB Size, Deadlocks, Temp Files)
• Checkpoints & buffers, connection breakdown, locks, blocked queries
• Long-running transactions, table statistics, unused indexes, replication lag

Backup & Restore

• On-demand backups with full pg_dump options (format, scope, compression, schema/table selection)
• Scheduled backups with day/time picker — runs automatically while the app is open
• Backup history with expandable rows showing full metadata
• In Progress / Successful / Failed status tracking with animated progress
• Configurable backup directory
• Restore from SQL, custom dump, or tar files

Help System

• Built-in markdown user guide (Help > Help)
• About dialog with version and platform info

UI Improvements

• Proper dropdown menus positioned under buttons
• File Explorer and Git integration in sidebar
• .sql files open in SQL Editor
• Resizable result grid columns
• Light theme for menu bar and panels
• Connection import from ~/.pgpass

Performance

• Connection pooling (pg.Pool)
• Eliminated pg_sleep blocking — uses cross-poll deltas
• Combined stats queries into single round trip
• Polling pauses when window is hidden

191 unit tests covering all major features