Top all-time · #7820
Foxhound Systems
Company blog · foxhound.systems/blogprogrammingdata
Foxhound Systems is the company blog at foxhound.systems, writing about programming and data. Since 2021, 9 different Hacker News readers have linked it 15 times, most often “TSIDs strike the perfect balance between integers and UUIDs for most databases”. It is still writing: the last post was on 2025-06-27, and you can follow it by feed.
Too few sampled comments (1) to say how often HN recommends it.?
Why HN links it
Foxhound Systems posts on Haskell database work. The linked post covers grouping query results in Haskell with Esqueleto, avoiding n+1 queries and building nested JSON-style results.
Summarised by Claude from a sample of 1 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Foxhound Systems is a custom software development company in Chicago that specializes in building fast, reliable, and intuitive software systems for companies across industries, with solutions serving millions of users globally.
Most-linked posts?
- TSIDs strike the perfect balance between integers and UUIDs for most databases3 people · 3 mentions · first linked 2023-12-20
- Speeding up SQL queries by orders of magnitude using UNION2 people · 2 mentions · first linked 2021-03-19
- Essential elements of high performance applications: SQL indexes2 people · 2 mentions · first linked 2022-05-24
What Hacker News says?
> So if you have a companies table joined to a contacts table, you'd get a two element tuple with a list of companies and a list of contacts, and then you have to iterate to do the joins and turn it into a JSON tree. Esqueleto has a function to avoid n+1's and return a map now: https://hackage.haskell.org/package/esqueleto-3.5.3.0/docs/D... https://www.foxhound.systems/blog/grouping-query-results-has...
Comment linking /blog/grouping-query-results-haskell/
on “Haskell2020 Is Dead, but All Hope Is Not Lost (2019)”Submitted Speeding up SQL queries by orders of magnitude using UNION as a story · 402 points
HN discussionSubmitted Haskell is our first choice for building production software systems as a story · 269 points
HN discussionSubmitted Composable Data Validation with Haskell as a story · 68 points
HN discussionSubmitted Essential elements of high performance applications: SQL indexes as a story · 13 points
HN discussionSubmitted TSIDs strike the perfect balance between integers and UUIDs for most databases as a story · 3 points
HN discussionSubmitted Technical Debt is not real as a story · 3 points
HN discussionSubmitted Speeding up SQL queries by orders of magnitude using UNION as a story · 3 points
HN discussionSubmitted The AI Delegation Dilemma as a story · 2 points
HN discussionSubmitted The missing letter in 'MVP' (2023) as a story · 2 points
HN discussionSubmitted TSIDs strike the perfect balance between integers and UUIDs for most databases as a story · 2 points
HN discussionSubmitted Final tagless encodings have little to do with typeclasses as a story · 2 points
HN discussionSubmitted TSIDs strike the perfect balance between integers and UUIDs for most databases as a story · 1 points
HN discussionSubmitted The Missing Letter in 'MVP' as a story · 1 points
HN discussionSubmitted Essential elements of high performance applications: SQL indexes as a story · 1 points
HN discussion
