Zippa DB 0.1.2

What's new

Query editor

• Implicit LIMIT: a lone SELECT (or WITH … SELECT) with no bound of its own now goes out with LIMIT 500 by default, so a quick look at a big table doesn't read all of it. It's a setting (Editor › Running), and the status bar carries a Limit checkbox and row count that override it for one tab, saved with the tab.
• :name and $name query variables, prompted for in an editor dialog
• A query formatter for SQL tabs
• Settings for script transactions and for sharing one connection across buffers

Results

• CSV/JSON export for query results
• A failed query run now shows its error in the tab's own result pane, not just the status bar, so each tab keeps its own failure

Schema and structure

• Create tables from the schema editor and databases from the database picker
• A view's CREATE VIEW statement on Inspect structure
• ER diagrams: tables drawn with their columns and key rows, foreign keys routed between the rows they join, and a focus mode that lays out one table's neighborhood (table picker + depth)

Connections and management

• User management for Postgres and MySQL
• Saved queries in the sidebar; tabs remember the saved query they came from and update it in place

Interface

• Title bar, sidebar, and query/table toolbars redesigned around labelled controls: a searchable database picker, sidebar commands behind one menu, labelled Run/Export buttons, segmented result tabs, and a Database menu
• The menu bar now draws in-window on Linux and Windows, and is merged into the title bar there
• Tooltips and ellipses pass across the app, and the query editor toolbar is cleaned up
• Sidebar tabs collapse to icons when too narrow
• The command palette ranks by relevance with fuzzy matching

Fixes and polish

• A cleanup pass: ER diagram edges on Postgres, passwords kept out of the console log, Escape closes the create-database, user, and variables dialogs, and an unreadable saved-queries file is preserved instead of overwritten

Full Changelog: v0.1.1...v0.1.2

Zippa DB 0.1.1

What's new

Query editor

• VS Code/Zed-style shortcuts: copy/cut line with no selection (⌘C/⌘X), delete line (⌘⇧K), move lines (⌥↑/↓), duplicate lines (⌥⇧↑/↓), next/previous occurrence (⌘D/⌘⇧D), select line (⌘L), smart Home
• Cross-database autocomplete — tables and columns from other databases, including aliased tables
• SELECT-list aliases offered in completion
• Comment toggle shortcut
• WITH … SELECT queries allowed on read-only connections

Connections

• SSL modes and SSH tunnels for Postgres and MySQL
• Connection health: acquire timeout, plain-language errors, Reconnect, statement timeout
• Each query tab now runs on its own pinned connection

Data

• Postgres geometry, range, hstore, and macaddr8 types display properly
• Script runs with transactions and failure handling
• MySQL statements the prepared protocol refuses now send as text

Interface

• New Sola theme sets: Twilight, Mirage, Dawn
• Draggable title bar, saved custom tab order, editor/result pane scaling, user color dots on connection tabs

Under the hood

• gpui-kit 0.7.1, dependency updates, and a polish audit (crash/hang/lost-data fixes)

Zippa DB 0.1.0

The first beta release of Zippa DB is here!

Zippa DB is a lightning-fast, native desktop database client for web developers. It brings PostgreSQL, MySQL, and SQLite together in one app. Built in Rust with GPUI, it ships as a single binary—no Electron, JVM, or web views.

---

Features

• Query console: Write queries with syntax highlighting and revisit them through query history.
• Virtualized data grid: Scroll smoothly through large result sets.
• Inline row editor: Edit data with built-in validation.
• Schema editor: Make schema changes with generated ALTER statements.
• Query analysis: Explore execution plans with the EXPLAIN ANALYZE visualizer.
• Database diagnostics: Inspect the process list, kill processes, view server variables, and examine query digests.
• SQLite maintenance: Run VACUUM, integrity checks, and WAL checkpoints.
• Flexible exports: Export results as CSV, JSON, or SQL.
• Secure credential storage: Keep credentials in your operating system’s keychain.
• Quick switcher: Jump between connections and databases with a Ctrl/Cmd+K-style workflow.
• Light and dark themes: Use the interface that fits your setup.

---

Compatibility and downloads

Zippa DB v0.1.0 supports:

• macOS: Apple Silicon .dmg
• Linux: x86_64 AppImage and amd64 .deb
• Windows: x64 installer

It can also be installed from source on any gpui-supported platform:

cargo install zippa-db

---

Notes

• The macOS and Windows builds are currently unsigned. Gatekeeper or SmartScreen warnings may appear on first launch; this is a known beta limitation.
• SSH tunneling is on the roadmap and coming soon.
• Found a bug or have an idea? Feedback is welcome through GitHub Issues.

v0-dev

Current development packages