Lightnews — Scholar-powered news

Eirik Bakke @ultorg.bsky.social · 24d

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)

Eirik Bakke @ultorg.bsky.social · Jul 23

Full release notes for Ultorg 2.1.0: www.ultorg.com/releasenotes...
Download page: www.ultorg.com/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...

Eirik Bakke @ultorg.bsky.social · Jul 23

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)

Eirik Bakke @ultorg.bsky.social · Jul 23

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)

1 1 2

Eirik Bakke @ultorg.bsky.social · Jun 18

Full release notes and download page for Ultorg 2.0 available here:
www.ultorg.com/releasenotes...

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...

Eirik Bakke @ultorg.bsky.social · Jun 18

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)

Eirik Bakke @ultorg.bsky.social · Jun 18

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)

Eirik Bakke @ultorg.bsky.social · Jun 18

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)

Eirik Bakke @ultorg.bsky.social · Jun 18

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)

Eirik Bakke @ultorg.bsky.social · Jun 18

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)

1 1 3

Eirik Bakke @ultorg.bsky.social · Mar 11

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 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...

Eirik Bakke @ultorg.bsky.social · Mar 11

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)

Eirik Bakke @ultorg.bsky.social · Mar 11

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)

Eirik Bakke @ultorg.bsky.social · Feb 10

Full release notes at ultorg.com/releasenotes... and download page at ultorg.com/download/ (3/3)

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...

ultorg.com

Eirik Bakke @ultorg.bsky.social · Feb 10

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)

Eirik Bakke @ultorg.bsky.social · Feb 10

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)

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...

Eirik Bakke @ultorg.bsky.social · Jan 22

A free trial of Ultorg is available at www.ultorg.com/download/ , with full release notes at www.ultorg.com/releasenotes... (5/5)

Ultorg - Download

Eirik Bakke @ultorg.bsky.social · Jan 22

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)

Joining a Database with Supplemental Data from Excel ("Pricing Experiments" example)

Eirik Bakke @ultorg.bsky.social · Jan 22

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...

YouTube video by Ultorg

www.youtube.com

Eirik Bakke @ultorg.bsky.social · Jan 22

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)

Excel as a Relational Database in Ultorg 1.9.0 (CRM Example)

Eirik Bakke @ultorg.bsky.social · Jan 22

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...

YouTube video by Ultorg

www.youtube.com

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...

Eirik Bakke @ultorg.bsky.social · Jan 22

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

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...

Eirik Bakke @ultorg.bsky.social · Jan 22

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

duckdb.org

Eirik Bakke @ultorg.bsky.social · Jan 22

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)