Jailer 8.0

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

Tags front-end quality-assurance utilities java sql cross-plattform developers end-users
License Apache
State stable

Recent Releases

8.021 Sep 2018 08:25 minor feature: The new "PathFinder" feature allows elaborate finding of association paths between tables in complex data models.
7.11.106 Sep 2018 21:45 minor feature: Database analysis not only finds primary keys and foreign keys for tables, But also for views and synonyms by analyzing the underlying tables. a memory leak in data browser.
7.1101 Sep 2018 12:05 minor feature: Database analysis not only finds primary keys and foreign keys for tables, But also for views and synonyms by analyzing the underlying tables. a memory leak in data browser.
7.10.824 Aug 2018 11:05 minor feature: Data browser improvements New layout feature: "align table horizontally with predecessor" Improved layout strategy in the data browser. Improved row-to-row-link rendering performance. . New layout feature: "align table horizontally with predecessor". Improved layout strategy in the data browser. Improved row-to-row-link rendering performance. Feature Request "Improve the usability of the Data Model Editor" (partially). see https://sourceforge.net/p/jailer/feature-requests/43/.
7.10.717 Aug 2018 06:25 minor feature: Animated desktop layout in the data browser. Improved row-link rendering quality and performance. Zoom in / out using the mouse wheel in the data browser.
7.10.428 Jul 2018 03:25 minor feature: The estimated number of rows of the tables is displayed. Limited fetch size of statements to prevent an OOM exception when the default fetch size is too large (MySQL). Updated H2 DBMS from version 1.3.160 to 1.3.175.
7.10.321 Jul 2018 06:25 minor feature: for "Can't connect to SOCKS proxy:http" #8. Comprehensive usability improvements of the data browser. Animated row-to-row links. Increased rendering quality of row-to-row link. Automatic layouting of data browser desktop. Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks. Update of SQL keyword catalog to SQL 2003 standard. Added context menu to columns view of results table.
7.10.210 Jul 2018 19:25 minor feature: for "Can't connect to SOCKS proxy:http" #8. Comprehensive usability improvements of the data browser. Animated row-to-row links. Increased rendering quality of row-to-row link. Automatic layouting of data browser desktop. Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks. Update of SQL keyword catalog to SQL 2003 standard. Added context menu to columns view of results table.
7.10.106 Jul 2018 06:45 minor feature: Comprehensive usability improvements of the data browser. Animated row-to-row links. Increased rendering quality of row-to-row link. Automatic layouting of data browser desktop. Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks. Update of SQL keyword catalog to SQL 2003 standard. Added context menu to columns view of results table.
7.1021 Jun 2018 07:05 minor feature: Comprehensive usability improvements of the data browser. Animated row-to-row links. Increased rendering quality of row-to-row link. Automatic layouting of data browser desktop. Using working-table-scope "LOCAL_DATABASE" led to concurrency problems and connection leaks. Update of SQL keyword catalog to SQL 2003 standard.
7.9.409 Jun 2018 07:05 minor feature: Comprehensive usability improvements of the data browser. Animated row-to-row links. Increased rendering quality of row-to-row link. . Animated row-to-row links. Increased rendering quality of row-to-row link.
7.9.304 Jun 2018 06:25 minor feature: Feature to define the rendering position of a column. Rendering of row-to-row links as bezier curves. Data browser: prevented that context menu automatically gets if the item doesn't have the focus.
7.9.231 May 2018 09:25 minor feature: Feature to define the rendering position of a column. Rendering of row-to-row links as bezier curves.
7.915 May 2018 06:25 minor feature: Comprehensive usability improvements of the data browser. for "#25 Invalid SQL when exporting for H2 dialect"https://sourceforge.net/p/jailer//25/?limit=25#49d4. Minor.
7.8.201 May 2018 03:15 minor feature: The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries. Improved render quality on high resolution screens.
7.827 Apr 2018 06:57 major feature: The new feature "Analyze SQL" analyzes SQL statements and proposes association definitions. This allows to reverse-engineer the data model based on existing SQL queries.