Hamilton Ulmer
@hamiltonulmer
đī¸đđī¸ @motherduck product design & engineering. Interested in tools and infra for data analysis, decision-making, and deep work
510 Following 4.7K Followers
Today we're launching prompt_jev(), which brings Jev, a new kind of AI model from @typesafeai, to MotherDuck SQL.
Jev makes text classification super fast, dirt cheap, and as easy as prompting an LLM. In our tests, it ran at 50x the speed and 1% the cost of comparable frontier models, with similar or better accuracy.
For analytics, this opens up scoring and labeling workflows that used to be too slow or costly. Classify all your data, rerun when your labels change, or filter on meaning in a WHERE clause while doing exploratory data analysis.
Live now in MotherDuck!
Show more
We re-worked my Jev/DuckDB example, and boy, was my original vibecoded extension excruciatingly inefficient. At LEAST 20x-40x faster now, often way more.
Jev is going to revolutionize analytics.
Something very cool to share tomorrow :)
Show more
@identityTorn @typesafeai totally ~ when doing EDA I really don't want to have to label anything. Heck, for a quick-and-dirty regular task, I don't want to either. This hits a very major sweet spot for me
Show more
I made a DuckDB extension where you can use @typesafeai 's Jev to do quick classification of rows in any csv/parquet file or duckdb table
about 10sec for 1k rows ~ better than using an LLM, way more ergonomic than a classifier
game-changing for data analysis!
Show more
