JarvisQL v0.2.0

What's new in 0.2.0

• MySQL: SSL with CA, client cert and key files, and connections through an SSH tunnel.
• Databases: pick a database on a server and open it as its own connection. Create or drop databases.
• Tables: clone and truncate, with a foreign key checks option for truncate and drop.
• Import and export: big files stream, with progress and a Cancel button.
• Safer editing: rows are matched by primary key, big numbers stay exact, binary cells show a hex preview.
• Nicer app: the status bar shows the server, SSH and TLS version, loading indicators, a scrollable connection dialog.

JarvisQL v0.1.0

First release of JarvisQL.

• SQLite: open local files, with saved connections, groups, tags and colours.
• SQLite over SSH: edit a database on a server and upload it back with a conflict check.
• Browse tables with paging, sorting and filters. Edit cells in place and review all pending changes before you save.
• Structure, index, trigger and DDL views.
• SQL editor with autocomplete, query tabs, saved queries, history and a query log.
• Import and export for CSV, JSON and SQL.
• Light, dark and system themes, font settings and updates inside the app.

Installers for Windows, macOS and Linux.