Dbex - A Hackable Database Explorer For Atom Editor
Dbex is an Atom package created to facilitate every developer who needs to work with multiple databases. It is not supposed to replace any professional tool, instead, it is a support package to avoid installing many database tools.
Resources
Engines
Dbex package does not make all the work alone, instead, it use 3rd party engines to make things happen. Everything that is related to the database is done by the engine as processing queries, controlling connection pools, retrieving structures and so on.
Engines can be created by anyone just by following the base template and filling the mandatory methods. Dbex will communicate with the installed engines to make things happen.
As soon as other engines are available it will be listed here. For now this is what we have:
| Engine | Description |
|---|---|
| Base Engine | Sample engine used as base structure. It does nothing, just an example |
| MySQL | Support to the basic aspects of MySQL resources, including v.5.x and v.8.x |
| MariaDB | Support to MariaDB resources |
| Cassandra | Cassandra support - BETA |
TODO
While many resources where implemented there are still some small issues to fix and also other resources that would be nice to have and probably will be implemented soon:
- Prevent "paste query" on query area to hide the result area. it is happening when result area is not visible yet;
- Show actions on right click instead of node icons;
- Edit result directly on table result (engine result must have a list of cols/references to send on confirm edit. ex.: mysql is the pk col name);
- Show divider between query and result (where we can see easily where to drag to resize);
- custom plugins for query area (ex.: action buttons, indentation);
- Custom plugins for result area (ex.: exporter);
- On edit connection, replace entry at same position instead of in the end;
- Draggable connections to reorder in tree;
- Auto complete on query area;
- Identify query executed from textEditor and replace or create new result tab (uuid or title), not on a generic tab;
- Add promise on dbex side to avoid engine blocking atom;
Warranty Disclaimer
The following disclaimer was written thinking in all professionals that works with data and know how important data is.
All work here is provided “AS IS” AND I CANNOT MAKE ANY EXPRESS OR IMPLIED WARRANTY OF ANY KIND. As this is a side project from myself and a non-commercial product, I cannot give any warranties about the correct and full functional product. I hereby declare to not be liable for any damages arising in use of or inability to use this software.
USE IT BY YOUR OWN RISK.
KEEP BACKUPS UPDATED.