HNHacker News
TopNewBestAskShowJobs

mattpope

31 karma · joined December 2, 2024

submissionscomments
mattpope··on Building AI agents to query your databases
I feel like this misses the most useful technique for this (or really glossed over any techniques at all): flat denormalized schemas. If you have an ENUM column, much like a human the LLM won't have enough context to query it. And much like a human, 4 way JOINs get tricky. Having one large sparse maxtrix-like table with many boolean columns like `is_sale_complete`, `is_sale_cancelled` data warehouse style is straight up the key to effectively use an LLM to generate SQL.
mattpope··on Ross Ulbricht granted a full pardon
He attended the convention. Is is for all intents and purposes representing them.
mattpope··on Ross Ulbricht granted a full pardon
We're talking about Libertarians and not Republicans, atleast that is what the parent comment was referring to. I don't know what Republicans what or believe vs what they say. The action to pardon directly addresses the Libertarian ideals.
mattpope··on Ask HN: Songwriters, what software do you use?
I went to a Slipknot concert back in 2022. They had a "junk set", a bunch of trashcans and kegs that they hit with aluminum bats. Not completely the same, but it did have a dissonant sound!
mattpope··on Ask HN: Songwriters, what software do you use?
nvim. No distractions. AI classifies as a distraction from expression (to me).
mattpope··on Ross Ulbricht granted a full pardon
It isn't clear from your original statement that those voters aren't from Pennsylvania. I interpret your statement as discounting the weight of their vote on actions they care about. There are many perspectives, and the values of those who did vote in that direction are being addressed in some way.
mattpope··on Ross Ulbricht granted a full pardon
It seems like the voters that were being referred to value restoring rights. How can something immediately achievable be balanced with "the economy", a thing so broad and deeply systemic?
mattpope··on Bringing the Instructions to the Data
Ah good catch, the most astute reader notices that I'm wrong twice!
mattpope··on Bringing the Instructions to the Data
Yes! All of the articles by this author are insightful and well written.
mattpope··on Bringing the Instructions to the Data
This is the first time I've seen this. It looks quite promising for taking care of a logical planning phase. But you still need an execution engine like Calcite or Datafusion (or an LLVM IR based executor)
mattpope··on Bringing the Instructions to the Data
A great idea but the last time I worked with WASM, using something like Wasmtime's shared host functions https://github.com/bytecodealliance/rfcs/blob/main/accepted/... they had quite the overhead. Maybe things have changed and have become less heavy.

Thank you for the styling tip, I'll see what I can do it does look wonky.