Skip to content

v0.22.0

Choose a tag to compare

View all tags
@github-actions github-actions released this 03 Sep 01:21
· 65 commits to main since this release
v0.22.0
daa4e1c

Schemaic v0.22.0 — users and privileges, Excel import and export, and an AI assistant that can finally read the error your query returned.

Highlights

  • Users and privileges. A new browser off the SCHEMA gear: every account and role the server knows, what each one may do as the engine's own GRANT statements, and forms to create an account, grant or revoke privileges, grant a role and drop — all through the same SQL preview every other schema change goes through. MySQL, MariaDB and PostgreSQL.
  • Excel. Export any result to .xlsx with each cell carrying the type the server gave it, and import a workbook into a table with the same preview, column mapping and validation a CSV gets.
  • The assistant can see the error. A failed query's message now reaches Explain and Ctrl+K with the values taken out and the constraint, column and error class kept — so it can help below Full data access, where it used to be told only that something failed.

Performance

  • Previewing a 200k × 50 workbook: 2.8 s and 1 GB → 21 ms and 64 MB. Worksheets stream rather than being expanded into memory, which also means a malformed workbook can no longer take the app down when you pick it.
Assets 16
Loading