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)
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: www.ultorg.com/releasenotes...
Download page: www.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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
A free trial of Ultorg is available at www.ultorg.com/download/ , with full release notes at www.ultorg.com/releasenotes... (5/5)
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)
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...
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)
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...
A free trial of Ultorg is available at www.ultorg.com/download/ , with full release notes at www.ultorg.com/releasenotes... (7/7)
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)
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)
DuckDB is the first open source column store engine that appears to have gone "mainstream" in the last few years (correct me if I'm wrong). Think of it like Redshift, Snowflake, or Vertica--but running on your own laptop. (4/7)
Column stores perform great with analytical queries, because (1) most database queries access only a subset of table columns and (2) large contiguous arrays of similar values can be stored and processed very efficiently. (3/7)
DuckDB is an extremely fast, open source database that runs from individual files of data on your local laptop, similar to SQLite. Unlike SQLite and PostgreSQL, it uses a "column store" architecture, meaning that table data is stored in columns rather than in rows. (2/7)
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...
