For professional purpose, i’m using CrateDB since several years. i was using a little self-made SQL Client (not really releasable :p). So i started, few months ago, to develop (once more) , from scratch, a new Admin Client for CrateDB databases to easily handle my datas. It’s a sort of HeidiSQL Client Clone dedicated to Crate databases. It’s a standalone Windows application (in .NET) which also works with Wine on Linux and MacOS X.
It’s a portable application which don’t need any admin rights on computer. You only need a CrateDB server, and CrateDBAdmin executable.
I want to make it available for everyone in few days, to promote CrateDB, in which I believe since many years. It will be released as a freeware (with a donation link if you want to support it).
There’s still a lot of work, but actually it supports :
Crate Connection through a HTTP Proxy
CrateDB basic authentication (if authentication is activated on server)
Create/Alter tables and parameters with a simple window (supports Nested objects etc…)
SQL Queries with SQL reformatter/beautifier feature and data grid rendering with live data modifications inside grid (also supports JSON nested object modification, GEO_POINT arrays, etc…)
SQL Queries auto-completion for schema, tables, columns, and nested columns
Blob tables with digest preview (based on file signatures) + browse file easily to upload blob if necessary
Filter through all schema and tables names for quick access
Welcome to the community forum
Looks really nice on the first view and cool, that you want to make it available to the community!
… to promote CrateDB, in which I believe since many years.
We are always keen to here from first hand experience as well. So if that works for you, I would also be happy to schedule a call, where you might also walk me through the tool … feel free to pm me
Seeing the name of Wes McKinney in the second screenshot made me smile!
Having visualization and charting features look nice! One minor comment: 3D doesn’t add much to the bar charts, it might even distract.
PS: Having some kind of plug-in/add-on system for such a tool would be great, e.g. for defining different kind of visualizations, etc. Do you consider that?
For the charting feature, it’s a small feature that i have not explored in depth for the moment. I have a lot of things to do to make it more comfortable to use
For the moment, i’m working on GUI import/export features (CSV, XLSX, SQL, JSON …) which is a must-have for a dev team in professional environment.
But i will consider an add-on system which should be nice indeed !
Hi there, out of curiosity, are you in need for a Crate Admin tool? is there any specific feature of the current released admin tool in port 4200 that doesn’t fit your bill?
Honestly nothing specific - you guys have done a great job on the admin tool. But when learning a new technology, I’ve found that often using different tools can expose different bits of data - some of which might give you a clue to diagnosing a problem/understanding it better. So it was more out of curiosity to see if it surfaced anything additional.
