hn.today

Ultorg: The User Interface for Relational Databases

ultorg.com142 points49 comments
Screenshot of Ultorg: The User Interface for Relational Databases

Ultorg is a desktop interface for exploring and editing relational data without writing SQL or building custom database applications. It presents database queries in a spreadsheet-like workspace, while generating SQL behind the scenes. It connects to PostgreSQL, SQL Server, MySQL, MariaDB, DuckDB, BigQuery, Access, Excel, Google Sheets, CSV/TSV files, and other JDBC sources; Oracle and several others are listed as beta. Data can remain on a user’s computer or corporate network, with no cloud service required.

The central feature is visual querying across tables: users can combine sources, apply joins, filters, formulas, sorting, calculations, and subqueries, then inspect the resulting data in one view. Ultorg emphasizes one-to-many relationships, which it displays without losing or duplicating rows, and lets users examine the underlying records behind grouped totals to check calculations. Automatic layout adjusts widths, labels, precision, and pagination for varied data, and can present records in nested tables, forms, or crosstabs. Users can also edit cells, select dropdown values, add rows, and review changes before committing them; simultaneous editing is supported. The product is aimed at analysts and operational teams who need flexible access to multi-table data, as well as database experts seeking a faster visual alternative to writing routine queries.

Read on ultorg.com49 comments on Hacker News

Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.

More in Programming

The daily digest

Today's best Hacker News stories, summarized and screenshotted, one email a day.