Skip to content
Monghoul
What's new

Monghoul 2.1.0

View on GitHub

Monghoul 2.1.0 lets you change a SQL table's structure without writing the statement yourself. On PostgreSQL, SQLite and ClickHouse, dialogs create a table, add a column or create an index. Each one shows the statement it builds and runs it through the write review. A table's menu also starts a new table like it, copies it as SELECT, INSERT or UPDATE, and runs maintenance such as Analyze, Vacuum and Optimize. ClickHouse drafts can add and materialize skip indexes. Refresh All lists every open level of a connection again from the server, and the tree lists itself again after a CREATE or DROP. The Interface settings now cover every engine.

New

  • Create Table, Add Column and Create Index dialogs — On PostgreSQL, SQLite and ClickHouse a dialog builds the statement from its fields, shows it as you type, and runs it through the write review or opens it as a draft.
  • Create Table Like This — A table's menu opens Create Table with that table's columns, defaults, primary key and options, and says what the copy leaves out.
  • Copy as SELECT, INSERT and UPDATE — A table's menu copies each statement with the engine's own parameters, ready for the draft's values.
  • Maintenance from the tree — Analyze and Vacuum on PostgreSQL, Optimize on ClickHouse and Analyze on SQLite run from a table's menu, with Stop for a long run.
  • ClickHouse skip indexes — A draft and the Create Index dialog run ALTER TABLE ADD INDEX, and MATERIALIZE INDEX as a mutation that asks first.
  • Refresh All — A connection's menu and Shift+F5 list every open level of the connection again, and the palette's "Refresh all open connections" does it for each open one.

Improved

  • Interface settings cover every engine — Each Interface switch names the engines it hides a part on, a Show list filters by engine, and SQL and Redis parts such as Copy DDL and Maintenance can be hidden too.
  • No browser suggestions under text fields — A text field no longer opens a list of entries typed before, which covered the app's own suggestions.

Fixed

Sidebar

  • The tree after ANALYZE, VACUUM or OPTIMIZE — A maintenance command no longer leaves every open level of a SQL connection on "Cached list", and after a CREATE or DROP the tree lists them again.

Downloads for v2.1.0

Installers published with this release.