Tech Talk: Ultorg at the 2022 HYTRADBOI Database Conference

An edited 9-minute presentation and demo of Ultorg, presented at the first online Have You Tried Rubbing a Database On It (HYTRADBOI) conference on April 29, 2022. Ultorg is a general-purpose, graphical database app that connects to existing data in PostgreSQL, CSV files, and other data sources.

Quick Demo: Joining a Database with Excel

This demo shows how an Excel spreadsheet can be joined with data in an external relational database, and used to edit supplemental data that influence the result of the current query.

The example is a database of products and orders, where the user is experimenting with the effects of hypothetical pricing adjustments.

Quick Demo: Using an Excel Workbook as a Relational Database

In this demo, we show how you can build a complete relational database from scratch using only Ultorg and an Excel workbook (available here). As an example, we build a small “customer relationship management” database that tracks customers and customer interactions.

By connecting Ultorg to the Excel file, you can query and edit the data as if it was a real, SQL database with an associated CRUD app built on top of it. Google Sheets is also supported.

Condensed Demo: Ultorg in 3 Minutes

A shorter demo of showing query building, auto-formatting, and data editing on a PostgreSQL database using Ultorg's spreadsheet-like visual interface.

Tech Talk: Ultorg—A General-Purpose User Interface for Relational Databases

A longer talk about the Ultorg project, hosted during the pandemic by MIT CSAIL Alliances. "Ultorg's founder and CEO Eirik Bakke proposes a solution to arbitrary relational databases through a single, general-purpose user interface that non-programmers can use to interact with arbitrary relational databases."

Demo: Which Banks are Still Processing PPP Applications?

In this demo, we use Ultorg to analyze public data about the U.S. government's Paycheck Protection Program, a stimulus package for small businesses. With the program's end date quickly approaching, small businesses will want to apply through banks that are processing applications quickly. We use Ultorg to join data about eligible financial institutions with data about approved PPP applications, to find the banks that approved the most applications in the program's last months, and which might still be accepting applications.

Demo: Queries from “SQL for Data Scientists”

In this demo, we connect Ultorg to the example database from SQL for Data Scientists by Renée Teate. We then recreate queries from the book using Ultorg's visual query interface.