[_xnmw]

The browsing-through-relationships features looks very, very, cool. One-click "see related rows" would save me a ton of time every day, as I use TablePlus, where I often find myself manually copying foreign keys as I switch between related tables. Anyone know of any other apps that do this, as this is Windows only?

[mmsimanga]

+1. I work with data from different applications dumped into one database. Analytics. Often you cannot enforce foreign key relations and you need to define these relationships. Jailer allows you to define these relationships and then you can explore the data by following you defined relationships. This is so useful when working in analytics. I have never actually used jailer to subset but to explore data and to demo data to users. You can quickly find a piece of data by filtering on the field and then retrieve related rows in other tables. This is way faster than writing the SQL out.

Thank you to the author(s). Great underated tool that takes a bit of effort to understand.

[jailertool2]

I'm glad you like it. It is not only available for Windows, but also for macOS/linux and others. (It is a Java application)

[SOLAR_FIELDS]

Is this supposed to be a generic drop in replacement for cross platform admin tools like Dbgate or Dbeaver? Or is it more of a specialized tool to do a specific thing?

[pbowyer]

Not being familiar with Java apps, can any reader tell me the best way to run this on macOS? From the CLI?

[dotdi]

This has a Linux build too. The releases contain a .deb file.