Show HN: Trilogy Studio, open-source browser-based SQL editor and visualizer https://ift.tt/SYxe7o2

Show HN: Trilogy Studio, open-source browser-based SQL editor and visualizer 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://ift.tt/f0Fug7X (language info) Git links: [Frontend] https://ift.tt/kMIKO1c [Language] https://ift.tt/jZWy7ht Previously: https://ift.tt/0JcjQVu (significant UX/feature reworks since) https://ift.tt/Atr5a14 https://ift.tt/IGzbaU1 November 10, 2025 at 06:26AM

Komentar

Posting Komentar

Postingan populer dari blog ini

Show HN: Guish – A GUI for constructing and executing Unix pipelines https://ift.tt/HrXz5ub

Show HN: Guish – A GUI for constructing and executing Unix pipelines guish is a dynamic data pipeline UI that allows users to visually construct and execute complex command-line pipelines. It provides an intuitive interface for chaining together various Unix commands and custom plugins, making it easier to build and understand data processing workflows. It also features optional LLM support for updating pipelines with a natural language interface. https://ift.tt/2lsA0r5 August 2, 2024 at 10:00PM
Baca selengkapnya

Twin Peaks for All: Survey Results

Gambar
Twin Peaks for All: Survey Results By Benjamin Barnett Last month, the SFMTA and San Francisco Recreation and Parks Department released a survey seeking public feedback regarding  five proposed roadway options for Twin Peaks Boulevard . San Franciscans responded to the survey, ranked support for each alternative and shared opinions about how the different options met their needs.  The Twin Peaks for All survey was open for almost three weeks and received more than 1,700 responses. This number reflects the high level of interest for this San Francisco park and its future access.   Survey Background Conditions on Twin Peaks Boulevard between Portola Drive and Barnett Avenue before COVID street closures.   The Twin Peaks Boulevard gates were closed early in the pandemic to reduce crowding at the lookout point parking lot. The gates were closed on the north, at Burnett Avenue, and the south, at Portola Drive. Since then, Twin Peaks Park use by hikers, joggers and peopl...
Baca selengkapnya

Taken with Transportation Podcast: For the Love of Muni

Taken with Transportation Podcast: For the Love of Muni By A light rail train displays the sentiment that we hear from scores of our riders. So many things make San Francisco unique and beloved, including the hills, the cool summers and the Golden Gate Bridge. You also can add our public transit system to that list. From buses to light rail lines to the iconic cable cars, residents and visitors alike love Muni. The latest episode of our Taken with Transportation podcast celebrates that love. Our customers embrace Muni In “For the Love of Muni,” riders discuss what the system means to them and how they express their appreciation. Artist Kurt... Published March 24, 2025 at 07:00AM https://ift.tt/zxrJwv9
Baca selengkapnya