search

ultorg / public_issues

Public issue tracker for the Ultorg Desktop application
12 stars 0 forks source link

how to refresh db schema? #58

Closed wizzard0 closed 8 months ago

wizzard0 commented 1 year ago

right now I'm restarting Ultorg so it would redetect the schema, but I really miss the "refresh schema" from DataGrip

Manual query console would also be great (in particular, to define custom columns on fields extracted from JSON)

eirikbakke commented 1 year ago

If you right-click the data source in the Folders pane, there's a "Refresh Table Metadata" action which should reload the list of tables, columns etc.

For database connections (e.g. PostgreSQL), this will also briefly disconnect and reconnect the connection so that cached permissions and such are refreshed.

refresh

What's the "define custom columns on fields extracted from JSON" use case you mentioned? Could you give an example?

eirikbakke commented 8 months ago

There's a new Ultorg version available now, which exposes the Refresh Table Metadata action in the main menu (under the "Data" menu). This should make it more discoverable.

Untitled

As for extracting fields from JSON data, there was actually a feature added in Ultorg 1.2.9 for this purpose:

expandJSONfields

The latest Ultorg version is available at https://www.ultorg.com/download/ , with all trial periods having been reset for this release. See the Release Notes for a full list of improvements.