Download Latest Version
Jailer-database-tools-17.2.msi (86.8 MB)
Get an email when there's a new version of Jailer
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| Jailer-database-tools-17.2.msi | < 18 hours ago | 86.8 MB | |
| jailer-database-tools_17.2-x64.deb | < 18 hours ago | 76.8 MB | |
| jailer-database-tools_17.2-x64.rpm | < 18 hours ago | 76.9 MB | |
| jailer_17.2.zip | < 18 hours ago | 72.1 MB | |
| README.md | 2026-07-16 | 2.3 kB | |
| Totals: 5 Items | 312.6 MB | 12 | |
- Export now reconstructs spatial (geometry/geography) column values with a dialect-specific SQL expression instead of losing type information.
- Spatial data preview: geometry/geography values are shown on an interactive map over
OpenStreetMap tiles - both in the Data Browser's cell preview and, for the SQL Console,
as a map overlay on the "Rows"/"Columns" result.
- Supports points, lines, polygons and their multi-/collection variant.
- Coordinate systems: WGS84 (SRID 4326/8307) and EPSG:3857 "Web Mercator" (the projection used by web maps / online portals).
- Navigation: drag to pan, mouse wheel to zoom (in the SQL Console the point under the cursor stays fixed), Shift+drag to zoom into a box.
- Geometries are drawn with a high-contrast outline/halo so they stay visible over any map tiles; points render as a colored ring with a white center. Hovering a geometry in the SQL Console highlights it and shows the row's data as a tooltip.
- Legend (SQL Console): color the geometries by the values of a chosen column, pick a color palette, adjust the legend text size, and move/resize the legend freely.
- "Save as image": save the current map as a PNG/JPG/BMP/GIF file or copy it to the clipboard (the move/resize handles are omitted from the exported image).
- "Analyze SQL": proposed associations are now checked for partially covered primary keys. If a proposal's join condition equates only some columns of a composite primary key on table "A" or "B", that cell is flagged with a warning icon and a tooltip listing the still-uncovered column(s).
- "Analyze SQL": AssociationProposer now understands "NATURAL JOIN" and "JOIN ... USING (col)" syntax and proposes associations for them, instead of silently ignoring those joins.
- Fixed: AssociationProposer could silently drop a column equality from a proposed join condition when the same table appeared twice in a query under different aliases (self-join), because equations from different aliases were incorrectly treated as duplicates.