The New year 2023 brings also the new version of DbGate - 5.2.0, with huge improvements.
See the latest news about DbGate
The New year 2023 brings also the new version of DbGate - 5.2.0, with huge improvements.
The newest version brings quite unique feature for MongoDB - query builder. Well, it works very differently from SQL query designer, but you can select data from more collections and join them together, as in normal SQL query builder.
This version brings small, but important improvements of SQL editor usability.
Although 5.1.1 is marked as minor version release, it brings very important change - perspectives (added in last version) have now a new designer. It look similar like query designer, but it has not query designer constraints - as the result is not single flat query, but hiearchical perspective view.
I am proud to announce new feature release with one big highlight - perspectives. Table perspectives feature is subset of visual query language defined by Eirik Bakke in his PhD work PhD work. It offers very comfortable and intuitive way to explore data in tables with complex relations. This feature works very well with foreign keys, but when you have database without foreign keys, you could define custom joins and define relations, which you need for the perspective.