News for hackers. Stuff that matters.

mattpope

Re:Building AI agents to query your databases on Tuesday March 18, 2025 @09:33AM (#43399255)
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.
Re:Ross Ulbricht was just granted a full pardon on Tuesday January 21, 2025 @10:28PM (#42788616)
He attended the convention. Is is for all intents and purposes representing them.
Re:Ross Ulbricht was just granted a full pardon on Tuesday January 21, 2025 @10:03PM (#42788462)
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.
Re:Ask HN: Songwriters, what software do you use? on Tuesday January 21, 2025 @09:43PM (#42788300)
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!
Re:Ask HN: Songwriters, what software do you use? on Tuesday January 21, 2025 @09:37PM (#42788255)
nvim. No distractions. AI classifies as a distraction from expression (to me).
Re:Ross Ulbricht was just granted a full pardon on Tuesday January 21, 2025 @09:32PM (#42788210)
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.
Re:Ross Ulbricht was just granted a full pardon on Tuesday January 21, 2025 @08:31PM (#42787633)
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?
Re: on Monday December 09, 2024 @09:35PM (#42373127)
Ah good catch, the most astute reader notices that I'm wrong twice!
Re: on Monday December 09, 2024 @11:58AM (#42367915)
Yes! All of the articles by this author are insightful and well written.
Re: on Monday December 09, 2024 @11:58AM (#42367909)
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)
Re: on Wednesday December 04, 2024 @08:00PM (#42323749)
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.