Repository navigation
dbui v0.2.6
This build is unsigned. It is not notarized by Apple, so macOS will
refuse to open it until you clear the quarantine flag. See
Installing below. The in-app updater will not offer this
release — install it by hand.
Two halves of one complaint: the window laid itself out in whatever order the
server sent, and it never said when it was holding more than it showed.
Columns move
A column is carried by its heading and lands where it is dropped. The rows
follow it, because what moved is the order the grid draws in and not the order
the result arrived in.
Where you put them is remembered by name, so it survives the next page, the
next reload and the next launch. A column the table has since dropped takes its
place with it; a new one arrives at the end, where the server put it.
A press that never travels is still a click, and a click on a heading still
sorts.
Tabs move
The same, along the strip, and the order is part of what a restart puts back.
Right-clicking a tab gives it the rest: Close, Close Others, Close to
the Right, Close All — the same four in ⌘⇧P, aimed at the tab in front.
A close that takes several tabs at once asks once, for the batch, instead of
once per tab and calling four answers consent.
Query results sort
A table's sort is a clause the server runs. A query's is not: its order is
whatever its own ORDER BY says, and re-reading it with one bolted on would be
rewriting your SQL behind your back.
Clicking a header on a query result reorders the page already in hand and
leaves the statement exactly as written. A third click puts the server's own
order back.
Numbers sort as numbers, so 9 comes before 10 rather than after it — money
included, which is kept as text all the way to the screen so it never picks up
a rounding error on the way. NULL sorts last ascending and first descending,
the way Postgres orders it.
Scrollbars
A container that scrolls used to draw nothing to say so, and a table taller
than its pane looked exactly like a table that ended there. The only way to
find out otherwise was to try the wheel.
Every pane that scrolls has a bar now — the grid both ways, the schema tree,
the row detail, the SQL editor, the palette, the connection picker, the staged
changes. Each says how much of the content is on screen and where in it you
are, and each can be dragged.
The SQL editor scrolls sideways
A statement wider than the pane ran off the right edge and stayed there: no
bar, no wheel, and typing carried on writing where it could not be read.
It pans now, and the caret stays in view — while typing, on a click, and when
autocomplete puts a name in.
⌘⇧E, for when the shape is the hard part
Twelve statements worth a starting point: a filtered SELECT, a page, a
COUNT, a GROUP BY with HAVING, both joins, an upsert spelled the way the
connected engine spells it, a CTE. When a table is open its name is filled in,
quoted for that engine.
They are shapes, not answers — every one names a column you have to replace,
because the point is which side of a LEFT JOIN keeps its rows and where
HAVING goes, not the identifiers.
UPDATE and DELETE arrive with their WHERE already written. A template
that hands you DELETE FROM t; and trusts you to add the clause before ⌘↵ is a
template that eventually empties a table.
Installing
This release is not signed or notarized, so Gatekeeper blocks it on first
open. After dragging dbui to Applications:
xattr -dr com.apple.quarantine /Applications/dbui.appThen open it normally. Alternatively, try to open it once, then go to System
Settings → Privacy & Security and click Open Anyway.
Signed and notarized builds will return in a later release. Until then the
in-app updater will not offer this version — it requires a notarized build
carrying the same Team Identifier as the copy you are running, and it refuses
anything that fails that check.
Verify your download against SHA256SUMS:
shasum -a 256 -c SHA256SUMS