Jailer, a unique open-source database tool

Re:Jailer, a unique open-source database tool by igammarays on Tuesday August 08, 2023 @06:58AM (#37047154)

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?

[ Parent | on HN ]

Re:Jailer, a unique open-source database tool by dotdi on Tuesday August 08, 2023 @07:02AM (#37047176)

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

[ Parent | on HN ]

Re:Jailer, a unique open-source database tool by jailertool2 on Tuesday August 08, 2023 @07:05AM (#37047192)

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)

[ Parent | on HN ]

Re:Jailer, a unique open-source database tool by SOLAR_FIELDS on Tuesday August 08, 2023 @09:13AM (#37048483)

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?

[ Parent | on HN ]

Re:Jailer, a unique open-source database tool by pbowyer on Tuesday August 08, 2023 @10:31AM (#37049549)

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

[ Parent | on HN ]

Re:Jailer, a unique open-source database tool by mmsimanga on Tuesday August 08, 2023 @09:20AM (#37048564)

+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.

[ Parent | on HN ]