3 ms·

I’ve been using ultorg for a couple years now, very happy to see it reach broader audiences Its’s a game changer tool for me, providing an intuitive graphical

by dhash 3y ago

I’ve been using ultorg for a couple years now, very happy to see it reach broader audiences Its’s a game changer tool for me, providing an intuitive graphical query construction interface (via a simple stacked table header, very sum-product like) and cross-db joins. The multi-column report style layouting is also really useful for looking at wide queries with lots of data. I’ve shamelessly ripped of some of eirik’s ideas and wowed people from (especially) the financial world IMO its one of the truest advancements in SQL clients that i’ve seen in a while.

throwaway290 3y ago
How does generating queries work with other sources like CSV?
- hahn-kev 3y ago
  Good question, if I were to do it I'd just import into an in memory SQLite db and let you query that
- eirikbakke 3y ago
  Ultorg has a bundled internal PostgreSQL database that is used for query execution over Excel/GSheets/CSV/MS Access sources. The tables are automatically dumped into PostgreSQL in an efficient manner when necessary. If you hit the Refresh button in the toolbar (F5 or Ctrl+R), Ultorg checks if there are changes in the original sources and refreshes the extracts if necessary. The same mechanism kicks in if you join tables from different data sources in a single visual query. E.g. you might join a table in a remote PostgreSQL database with a table in a local CSV file. Both tables end up getting extracted locally. There's a "Generated Extracts" folder in the sidebar where you can see a list of table extracts that were auto-generated on the local machine. The process is otherwise seamless, and queries in fact often perform much better locally than being executed on a remote database. The latter is due to no network latency, powerful laptops, and a custom PostgreSQL configuration on the local database that is tuned for single-user ad hoc queries.
  - throwaway290 3y ago
    Thanks, cool stuff!

by dhash 3y ago

throwaway290 3y ago

How does generating queries work with other sources like CSV?

hahn-kev 3y ago
Good question, if I were to do it I'd just import into an in memory SQLite db and let you query that
eirikbakke 3y ago
Ultorg has a bundled internal PostgreSQL database that is used for query execution over Excel/GSheets/CSV/MS Access sources. The tables are automatically dumped into PostgreSQL in an efficient manner when necessary. If you hit the Refresh button in the toolbar (F5 or Ctrl+R), Ultorg checks if there are changes in the original sources and refreshes the extracts if necessary. The same mechanism kicks in if you join tables from different data sources in a single visual query. E.g. you might join a table in a remote PostgreSQL database with a table in a local CSV file. Both tables end up getting extracted locally. There's a "Generated Extracts" folder in the sidebar where you can see a list of table extracts that were auto-generated on the local machine. The process is otherwise seamless, and queries in fact often perform much better locally than being executed on a remote database. The latter is due to no network latency, powerful laptops, and a custom PostgreSQL configuration on the local database that is tuned for single-user ad hoc queries.
- throwaway290 3y ago
  Thanks, cool stuff!