Show HN: Trilogy Studio, open-source browser-based SQL editor and visualizer

trilogydata.dev

19 points by efromvt 3 days ago

SQL-first analytic IDE; similar to Redash/Metabase. Aims to solve reuse/composability at the code layer with modified syntax, Trilogy, that includes a semantic layer directly in the SQL-like language.

Status: experiment; feedback and contributions welcome!

Built to solve 3 problems I have with SQL as my primary iterative analysis language:

1. Adjusting queries/analysis takes a lot of boilerplate. Solve with queries that operate on the semantic layer, not tables. Also eliminates the need for CTEs.

2. Sources of truth change all the time. I hate updating reports to reference new tables. Also solved by the semantic layer, since data bindings can be updated without changing dashboards or queries.

3. Getting from SQL to visuals is too much work in many tools; make it as streamlined as possible. Surprise - solve with the semantic layer; add in more expressive typing to get better defaults;also use it to wire up automatic drilldowns/cross filtering.

Supports: bigquery, duckdb, snowflake.

Links [1] https://trilogydata.dev/ (language info)

Git links: [Frontend] https://github.com/trilogy-data/trilogy-studio-core [Language] https://github.com/trilogy-data/pytrilogy

Previously: https://news.ycombinator.com/item?id=44106070 (significant UX/feature reworks since) https://news.ycombinator.com/item?id=42231325

siddbudd a day ago

I tried to open the link in 2 browsers, both times the step "Establishing connection" resulted in "Dashboard Load Failed Reset operation timed out after 60 seconds"

  • efromvt 15 hours ago

    Ugh sorry about that - was trying to bundle the duckdb packages in the docker image and accidentally included them in the prod deploy, and my static hosting is too slow to server those in time. (works in github CI though, of course - I'll need an extra post-deploy validation on the serve latency).

    Reverted, should load now if you have a chance!

chaz6 3 days ago

After dismissing the tips I am greeted with errors:-

  {
    "message": "NetworkError when attempting to fetch resource.",
    "error": true,
    "running": false
  }
If I check the console, it appears to be due to CORS failures.
  • efromvt 2 days ago

    Hey! So sorry about that - thanks for saying something. That's on the initial load of the dashboard link? What's the URL you see it on in console? If you're using the public resolver it will do some CORS validation but should pass for the trilogydata site - are you running locally?

justingrosvenor 3 days ago

Color palette on your visualizations is fire.

  • efromvt 3 days ago

    Hah, light or dark mode?