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