Another Ultorg release, this time simplifying formulas that involve calculations on dates and times, and improving the display of time durations. Also, by popular request: Highlight the current row, to help users maintain sanity when reading very wide tables. (1/2)

New in Ultorg 2.1.0: You can now quickly share the current perspective (visual database query), by creating a link to it. Links may be opened by other Ultorg users, or used as a way to store queries in company wikis, git repos, or similar. (1/3)

Ultorg 2.0 is released, with several user-requested features! With conditional formats, you can color rows or cells, or "strike through" a row, based on values or an arbitrary formula condition. (1/6)

Ultorg 1.9.4: The new "Compile to SQL" action generates a SQL query from the current perspective. The query is similar to those used internally by Ultorg, but has predictable outer column names, and is better suited for use in external applications. (1/3)

Ultorg 1.9.2: For simple data edits, Undo now works even after you have committed the edits to the database.

When Undo is invoked for an already-committed data edit, Ultorg creates a new pending edit that would revert the prior change (similar to "git revert") (1/3)

Write-to-Excel in Ultorg 1.9.0! You can now build a complete relational database from scratch, as tabs in an Excel file. Then, use Ultorg to query and edit the data. Here is a demo of a simple CRM database, with a couple of joins and one-to-many relationships. (1/5)
www.youtube.com/watch?v=IQJq...

Support for @DuckDB in Ultorg 1.9.0! You can now connect Ultorg to a DuckDB database file, and use Ultorg's full visual query interface to explore your data. (1/7)

www.youtube.com/watch?v=jzOV...

Making a fast, responsive UI for a slow external process is a bit of an art. In Ultorg's case, the user builds database queries through a spreadsheet-like UI. Queries are compiled to SQL and executed remotely--but the UI doesn't actually wait for the results! (1/5) www.youtube.com/watch?v=1-Bs...

Quick demo: New "Filter Only" and "Filter Exclude" actions in Ultorg 1.8.0. If the value you want to filter on is already visible on the screen (very common!), you can set the filter in a single click or keystroke, without going through the Filter popup. www.youtube.com/watch?v=PLCV...

@jay.bsky.team Bluesky feature requests: (1) bookmarks, so I can save posts from mobile that i want to open later on my laptop, (2) show bluesky logo somewhere discretely on the mobile app screen so I know I’m not on X or Threads.