Release v0.21.0 · fadion/schemaic

Schemaic v0.21.0 — TLS connections, running .sql scripts, importing connections from other clients, and creating databases.

Highlights

TLS/SSL connections. Connect over TLS on MySQL and PostgreSQL, with a per-connection mode, client certificate and CA paths, and verification against your operating system's trust store.
Run a .sql file. Execute a script statement by statement from a database's Import — with a confirmation naming the destructive statements it found, and a Stop that cancels the statement actually running.
Import connections from other clients. Bring in saved connections from DBeaver, DataGrip and CLI config files, or paste a connection URL.
Create and drop databases. From the schema tree's gear, with the generated DDL shown for review before it runs.

Kept results. Pin a result and it stays in a results strip while you run the next query.
A connection can carry its own database, and new tabs open in it rather than at the server root.
Refresh a materialized view from the schema tree's context menu.
Query history rows have a right-click menu — open in a new tab, or delete the entry.
Databases your role cannot open are hidden, and one that failed to load puts its error behind a View control instead of in the tree.

SQL export writes multi-row INSERTs, so a dump is smaller and reloads faster.
Large .sql files split in linear time rather than slowing as they grow.
The schema's maintenance probe stops as soon as the answer can no longer change.

A hand-picked import file no longer picks up your .pgpass password, and a skipped entry no longer shows a password in its name.
A write in manual-transaction mode can be cancelled instead of trapping you until it finishes.
The client's DELIMITER token is no longer sent to the server.
A long connection name or endpoint stays inside the connection switcher, with hosts aligned to its right edge.
Import is dimmed on a read-only connection.
Non-ASCII text and a leading byte-order mark no longer break the import parsers or a script file.