Ultorg

@nitroargo Thanks! Yeah, for screenshots and projection, or user preference, we might add a "high contrast" mode (simulated below) that makes the separator lines more prominent. Separators are quite subtle by default, which is more optimal at 1:1 resolution than in scaled-down figures.

@ultorg I think this single screenshot captures the value prop more than anything else. Great job! Have a suggestion - change the line color or some other feature to clearly demarcate each order because it is not that clear at the moment. Took me at least 3 mins to figure it out

New documentation site! Ultorg, the missing user interface for relational databases, is now discussed in detail with over 400 screenshots. Topics include: data source connections, query building, formulas, automatic layouts, data editing, SQL-equivalence. ultorg.com/docs/intro/wha…

Also, handle the SQL INTERVAL type, and tables in Google BigQuery with mandatory partition filters. Download Ultorg 2.1.2 here: ultorg.com/download/ Full release notes at #version-2_1_2" target="_blank" rel="nofollow noopener">ultorg.com/releasenotes/#… (2/2)

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)

Full release notes for Ultorg 2.1.0: #version-2_1_0" target="_blank" rel="nofollow noopener">ultorg.com/releasenotes/#… Download page: ultorg.com/download/

End-to-end encryption: The data in perspective definitions, such as column names and selected filter values, is stored on Ultorg's server in encrypted form only. The encryption key is stored in the “hash” portion of the link (#...), which is never exposed to the server. (2/3)

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)

Full release notes and download page for Ultorg 2.0 available here: #version-2_0_0" target="_blank" rel="nofollow noopener">ultorg.com/releasenotes/#…

A bonus feature for some very specific use cases: Text cells can now render inline LaTeX math. (Eventually we should add support for more common markup languages...) (5/6)

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)

@julianhyde @jonathoda Hmm, or maybe that UI is not actually text-only. I detect proportional fonts!

@julianhyde Ultorg has JSON output or "flattened" CSV for export purposes, though UI interactions are always driven from the graphical nested table layout. I think @jonathoda has a more terminal-like UI for nested relations, though! x.com/hytradboi/stat…

Data in @morel_lang isn’t always tabular (lists or bags of records) but it often is. So I think it’s time to add a mode so that tables look like tables. github.com/hydromatic/mor…

@MaineFrameworks Nested relations get flattened with joins. But sometimes this would lead to a combinatorial explosion of rows, in which case Ultorg shows a warning and suggests how to modify the perspective. For its own use, Ultorg evaluates such perspectives using multiple SQL queries.

@ultorg I'm assuming you cannot generate all the nested relations at once but rather this applies to whatever level of nesting one is currently in?

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)

Other improvements and bugfixes are listed in the release notes at #version-1_9_4" target="_blank" rel="nofollow noopener">ultorg.com/releasenotes/#… Download the latest Ultorg version here: ultorg.com/download/ (3/3)

This release also makes it easier to work with cells containing long text or JSON values. You can press Ctrl/⌘+Enter to see the contents of the currently selected cell in a dedicated text editor, where keys such as Enter and Page Down will not disturb the cell selection. (2/3)

Full release notes at #version-1_9_2" target="_blank" rel="nofollow noopener">ultorg.com/releasenotes/#… and download page at ultorg.com/download/ (3/3)

Also, the dropdown that appears when editing foreign keys can now be constrained to show only specific, relevant options. For example, a dropdown showing Cities may be constrained to show only cities from the country that is selected in an adjacent Country field. (2/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)