efromvt

8 ms·

91.
by efromvt 7mo ago
Oh that's great! I was finding fun tree collections and wanted to go see them - unfortunately not in SF so not likely - but your app has some nice data around me that I can check out! Are you primarily using OSM data? I was thinking o
92.
by efromvt 7mo ago
I had some ambitions of merging in other city tree data but hadn't gotten around to exploring it yet - NYC might be a good place to start!
93.
by efromvt 7mo ago
A visual explorer for the trees of San Francisco. https://greenmtnboy.github.io/sf_tree_reporting/#/ For all the places it's bad at, AI has been fantastic for making targeted data experiences a lot more acces
94.
by efromvt 7mo ago
I'd be interested in just the data layer of this being extractable - will poke around at that. (frontend is fun, though!).
95.
by efromvt 7mo ago
A belated - nice to see this, I think an intermediate IR is the right way to gate access rather than raw SQL (full disclosure; also hacking on open-source solutions in that space) - how are you balancing expressiveness vs control? Some of t
96.
by efromvt 8mo ago
There's a lot of useful autonomous things that don't require unrestricted outbound communication, but agreed that the "safe" claw configuration probably falls quite a bit short of the popular perception of a full AI assi
97.
by efromvt 8mo ago
Carcinization - now for your drinks AND your AI
98.
by efromvt 8mo ago
Experimenting with visual/audio combinations to explore aspects of a space dataset I’ve been having lots of fun with. Added in a LLM chat view with Duck DB WASM as well to try out tool use - text to SQL seems to be relatively solved wi
99.
by efromvt 9mo ago
I'd really love a minimalist version, I'm not sure how small it's feasible for them to shrink it. As long as it doesn't get bigger and devices keep getting faster, I suppose?
100.
by efromvt 9mo ago
DuckDB can't get enough love! Beyond being a really performant database, being so friendly [sql and devx] is really underrated and hard to pull off well and is key to it being so fun - you get a compounding ecosystem because it's
101.
by efromvt 10mo ago
Still experimenting with data productivity tooling that doesn't rely on YAML. Been refocused on CLI tooling as a good interface for agentic use recently since Claude Code has gotten so good. Need to do some empirical evaluation on MCP&
102.
by efromvt 11mo 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&#x27
103.
by efromvt 11mo 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
104.
by efromvt 11mo ago
Hah, light or dark mode?
105.
Show HN: Trilogy Studio, open-source browser-based SQL editor and visualizer(trilogydata.dev)
19 points by efromvt 11mo ago|6 comments
106.
by efromvt 1y ago
This is true, but you can get combinatorial complexity explosions, especially with the data modeling patterns for efficiency common at some companies - eg a mix of latest dimensions and historical snapshots, without always having clear deli
107.
by efromvt 1y ago
Been exploring the amazing GCAT space dataset - it’s been a good way to drive some dashboard feature experimentation using fun data. Still need to work on my dashboard design skills, though. GCAT: https://planet4589.org/spac
108.
by efromvt 1y ago
Very much agree that to this is the direction data orchestration platforms should go towards - the basic DAG creation can be straightforward, depending on how you do the authoring - (parsing SQL is always the wrong answer, but is tempting)
109.
by efromvt 1y ago
This has been super annoying! I just tell it to make sure the artifact is updated and it usually fixes it, but it's annoying to have to notice/keep an eye on it.
110.
by efromvt 1y ago
MDX really did it well, at the cost of being impenetrable to the average user - the drilldown flow you could get is still hard to beat. Shameless plug for the list, though - I work on https://github.com/trilogy-data/pyt
111.
by efromvt 1y ago
Yeah, minimizing the gap between the semantic layer authoring and adhoc is what you need to do to close that - there has to be a progressive model both for consumption (take this semantic layer, slightly extend/tweak it in an adhoc fas
112.
by efromvt 1y ago
Still iterating on Trilogy, a SQL variant with an embedded semantic layer that removes the need for joins and better typing/functions. Spent some time last month improving array handling + error messages and UX and adding an MCP server
113.
by efromvt 1y ago
Continuing to plug away at Trilogy, a better SQL for data consumption and analytics. Getting closer to core feature completeness, at which point can pivot to focus on integrated visualizations + pre-processing/ETL. Most recently have b
114.
Show HN: Open-Source "Semantic SQL" Web IDE for Analytics (DuckDB/BigQuery)(trilogydata.dev)
2 points by efromvt 1y ago|0 comments
115.
by efromvt 1y ago
(Shameless plug) writing the same joins over and over (and refactoring when you update stuff) was one of my biggest boilerplate annoyances with SQL - I’ve tried to fix that while still keeping the rest of SQL in https://trilogyda
116.
by efromvt 1y ago
A open-source Looker/Data Studio alternative, supporting Bigquery/Snowflake/DuckDB. Has a custom SQL dialect with embedded semantic layer to make reusable and interactive visuals easier. Can be self-hosted, but a public versi
117.
by efromvt 2y ago
JSON generation against a semantic layer and validation loops is definitely the easiest way to get high 9s success for going directly to a correct query from text. For the human in the loop cases, going directly to SQL can be fun - I’ve toy
118.
by efromvt 2y ago
Ah thanks for the response! That makes sense - I gloss over it a bit in the demo intentionally, but that's a miss. The semantic definition flow is pretty much identical to what I think I'm reading with plisqin - there's an in
119.
by efromvt 2y ago
In trying to tackle this in the past, I've attempted to break down the things that SQL does well (and it does a lot well, I really like SQL) and how they could be individually more composable/reusable. Semantic Information: - Expr
120.
by efromvt 2y ago
Shameless plug if you've tried a range of alternatives: I've tried building a version (Trilogy) targeted at analytics, and I'd be curious about how it stacks up to your experience with other attempts at this - can read more

More ›