Eirik Bakke
banner
ultorg.bsky.social
Eirik Bakke
@ultorg.bsky.social
Building Ultorg, the missing user interface for relational databases. www.ultorg.com
Also, handle the SQL INTERVAL type, and tables in Google BigQuery with mandatory partition filters. Download Ultorg 2.1.2 here: www.ultorg.com/download/ Full release notes at www.ultorg.com/releasenotes... (2/2)
Ultorg - Download
Ultorg is a general-purpose, user-friendly database app that connects to your existing data, in spreadsheets or relational databases. Query and edit data across tables and relationships, without manua...
www.ultorg.com
September 18, 2025 at 4:52 PM
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)
July 23, 2025 at 6:42 PM
Full release notes and download page for Ultorg 2.0 available here:
www.ultorg.com/releasenotes...
Ultorg - Release Notes
Ultorg is a general-purpose, user-friendly database app that connects to your existing data, in spreadsheets or relational databases. Query and edit data across tables and relationships, without manua...
www.ultorg.com
June 18, 2025 at 3:40 PM
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)
June 18, 2025 at 3:40 PM
You can now resize table columns by dragging the edge of their header. Double-click to restore auto-sizing. And, print layouts will repeat table headers on every page. (4/6)
June 18, 2025 at 3:40 PM
When staging data edits across multiple tables, you can now insert rows under other inserted rows, even when the join is on an auto-generated primary key. Ultorg will work out the dependencies when you commit. (3/6)
June 18, 2025 at 3:40 PM
The Compile to SQL action now orders and formats its output columns in a more usable manner. Google BigQuery is also now supported as a data source (with all date/time data types, formula functions, Expand JSON Fields etc.). (2/6)
June 18, 2025 at 3:40 PM
Other improvements and bugfixes are listed in the release notes at www.ultorg.com/releasenotes...
Download the latest Ultorg version here: www.ultorg.com/download/ (3/3)
Ultorg - Release Notes
Ultorg is a general-purpose, user-friendly database app that connects to your existing data, in spreadsheets or relational databases. Query and edit data across tables and relationships, without manua...
www.ultorg.com
March 11, 2025 at 3:17 PM
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)
March 11, 2025 at 3:17 PM
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)
February 10, 2025 at 3:23 PM
Similar functionality is also available for Google Sheets connections. You can query the data from Ultorg and save changes back to the underlying sheet. (4/5)
January 22, 2025 at 3:15 PM
Here's another demo, where we join a database of products/orders with an Excel sheet containing proposed pricing adjustments, to see the impact on revenues. We can make edits to the pricing adjustments and have Ultorg write them back to the underlying XLSX file. (3/5)
www.youtube.com/watch?v=f_oe...
Joining a Database with Supplemental Data from Excel ("Pricing Experiments" example)
YouTube video by Ultorg
www.youtube.com
January 22, 2025 at 3:15 PM
Excel sheets are also useful when you need to provide some supplemental data for a query against a larger external database. Use the Custom Join action to join your Excel sheet against a database table. Then continue editing the supplemental data from within Ultorg. (2/5)
January 22, 2025 at 3:15 PM
A free trial of Ultorg is available at www.ultorg.com/download/ , with full release notes at www.ultorg.com/releasenotes... (7/7)
Ultorg - Download
Ultorg is a general-purpose, user-friendly database app that connects to your existing data, in spreadsheets or relational databases. Query and edit data across tables and relationships, without manua...
www.ultorg.com
January 22, 2025 at 2:45 PM
For now, Ultorg assumes that you already have a DuckDB file available, populated with data. You'd need to install DuckDB's command-line tool and import data there (duckdb.org/docs/data/ov...). Future Ultorg versions might integrate DuckDB further, to avoid these extra steps. (6/7)
Importing Data
The first step to using a database system is to insert data into that system. DuckDB provides can directly connect to many popular data sources and offers several data ingestion methods that allow you...
duckdb.org
January 22, 2025 at 2:45 PM
DuckDB, as suggested by some users, turned out to be rather easy to support from Ultorg. Its dialect of SQL is reasonably similar to that of PostgreSQL, and it has all the standard data types available (date, time, datetime, integer, numeric, json, uuid...) (5/7)
January 22, 2025 at 2:45 PM