| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| Jailer-database-tools-17.3.msi | < 5 hours ago | 92.4 MB | |
| jailer-database-tools_17.3-x64.deb | < 5 hours ago | 82.3 MB | |
| jailer-database-tools_17.3-x64.rpm | < 5 hours ago | 82.4 MB | |
| jailer_17.3.zip | < 5 hours ago | 78.9 MB | |
| README.md | < 5 hours ago | 3.1 kB | |
| Totals: 5 Items | 335.9 MB | 0 | |
- SQL Console: new result tab "Pivot" next to "Chart". It shows a cross table of the rows:
- The fields are chosen in a side bar. Row fields and column fields can be nested (e.g. DEPTNO, then JOB), with subtotals per group. "Totals of single-element groups" also shows subtotals of groups with only one subgroup.
- Several values, each with its own aggregate function: Count, Count distinct, Sum, Avg, Min or Max. "(rows)" counts the rows.
- Totals are computed from the rows themselves, so that they are also correct for Avg and Count distinct.
- The values of a row or column field can be filtered (filter button next to the field). Filtered rows are not counted, also not in the totals.
- Double-clicking a cell selects its rows in the "Rows" tab and sorts the rows accordingly.
- "Chart" shows the pivot table as chart (the groups, without subtotals and totals).
- "SQL..." generates the SQL statement that computes the pivot table.
- "Copy" copies the pivot table with header to the clipboard, "Save as CSV..." saves it as CSV file.
- "Save as Excel..." saves an Excel workbook (.xlsx, can also be opened with LibreOffice) with an Excel PivotTable, the pivot table as formulas over the rows (with collapsible groups and AutoFilter), and the rows themselves.
- Fixed: SQL scripts exported for SQLite, HSQLDB, Firebird, Sybase, Informix, Derby or Cloudscape could not be imported reliably if a text value contained line breaks. Inside such a value, a line ending with ";" broke the statement, and blank lines, leading and trailing blanks and lines starting with "--" got lost. Carriage returns (CR) were dropped as well. For SQLite, HSQLDB, Firebird, Sybase and Informix, line breaks are now exported as char(10)/char(13) expressions, so each value stays on one line of the script. The import now keeps multi-line string literals unchanged, including carriage returns. This also makes scripts exported for Derby and Cloudscape, and scripts exported with earlier versions, importable.
- Content viewer for BLOB/CLOB values:
- New button "Format" shows JSON and XML content indented. "Save to file..." and "Open externally" still use the original content.
- Long lines are wrapped. Line numbers are then shown, so that it can be seen where a line actually begins.
- New tool "Check Normalization" (menu "Data Model", also in the Data Browser): finds possible violations of the normal forms 1NF to 5NF and foreign keys whose type differs from the referenced column. If connected, 2NF/3NF findings are verified against the data. Findings can be opened in the extraction model editor or in the Data Browser.
- The shortcut of "Save as..." in the extraction model editor is now Ctrl+Shift+S instead of Ctrl+A, which conflicted with "Select all".
