Top all-time · #7432
Felipe Hoffa
Personal blog · hoffa.medium.comdataprogramming
Felipe Hoffa's personal blog at hoffa.medium.com covers data and programming. Since 2021, 11 different Hacker News readers have linked it 17 times, most often “Snowflake tables on Cloudflare R2 for global data lakes”. It is still writing: the last post was on 2026-06-01, and you can follow it by feed.
Too few sampled comments (5) to say how often HN recommends it.?
Why HN links it
HN readers link Felipe Hoffa's Medium posts on BigQuery usage, query cost and clustering, and GitHub repository statistics. Commenters cite them as sources or examples, and one praises them.
Summarised by Claude from a sample of 5 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Most-linked posts?
- /400-000-github-repositories-1-billion-files-14-terabytes-of-code-spaces-or-tabs-7cfe0b5dd7fd2 people · 2 mentions · first linked 2021-09-21
- Snowflake tables on Cloudflare R2 for global data lakes2 people · 2 mentions · first linked 2023-03-27
What Hacker News says?
I can’t remember the exact blog post or video that drew me in, but Felipe Hoffa has written/recorded many excellent examples of using BigQuery which use one of their public datasets. I was very impressed when I first played around with it on the free tier back in 2015. The pricing seemed really reasonable and I was amazed with how quick it was on large datasets. An example article: https://hoffa.medium.com/static-ja…
Comment linking /static-javascript-code-analysis-within-bigquery-ed0e3011732c
on “Ask HN: Best dev tool pitches of all time?”Submitted Open source boards and tenure terms: The FSF has stalled as a story · 7 points
HN discussionThis suggests that spaces are more popular. https://hoffa.medium.com/400-000-github-repositories-1-billi... The only exceptions being C, where tabs are slightly more common, and Go, where tabs are the official style.
Comment linking /400-000-github-repositories-1-billion-files-14-terabytes-of-code-spaces-or-tabs-7cfe0b5dd7fd
on “What's the deal with tab size (8 spaces) in the GitHub UI?”Submitted Loading all Hacker News comments into Snowflake (in less than 1 minute) as a story · 3 points
HN discussionAs others have pointed out, it's pretty easy to learn that typically using LIMIT doesn't affect query cost. That said, one surprising side effect of adding clustering is that LIMIT actually works as you'd expect it to. See this post by Felipe Hoffa, formerly of Google: https://hoffa.medium.com/bigquery-optimized-cluster-your-tab... .
Comment linking /bigquery-optimized-cluster-your-tables-65e2f684594b
on “BigQuery pricing model cost us $10k in 22 seconds”Submitted The Most Popular Languages on Reddit after analyzing 1M comments as a story · 3 points
HN discussionTo echo a comment on the post, the numbers on this would be really interesting to see. The comments are all on bigquery if anyone wants to write a blog post to confirm the trend. https://hoffa.medium.com/hacker-news-on-bigquery-now-with-da...
Comment linking /hacker-news-on-bigquery-now-with-daily-updates-so-what-are-the-top-domains-963d3c68b2e2
on “Mastodon links are now more common than Twitter/X on HN”Submitted Optimizing the Snowflake Query Optimizer as a story · 2 points
HN discussionThanks for checking it out. Right now aider doesn't even try and deal with files larger than the context window. For gpt-4, that's 8k tokens or about 32kbytes. Which is pretty reasonable. According to the data in [1], the average source file in github is less than 14KB. It's worth noting that they explicitly discarded small files with less than 10 lines. So the true average is probably much lower. Regardless, I have…
Comment linking /400-000-github-repositories-1-billion-files-14-terabytes-of-code-spaces-or-tabs-7cfe0b5dd7fd
on “AI-powered coding, free of charge with Colab”Submitted Explore the World with Foursquare Places on Snowflake as a story · 2 points
HN discussionSubmitted SQL to track startups, IPOs and more: Crunchbase Enterprise with Snowflake as a story · 2 points
HN discussionSubmitted Snowflake makes the dbt Python models shine as a story · 1 points
HN discussionSubmitted Snowflake tables on Cloudflare R2 for global data lakes as a story · 1 points
HN discussionSubmitted Snowflake tables on Cloudflare R2 for global data lakes as a story · 1 points
HN discussionSubmitted From BigQuery Director to Snowflake User – With Dan Delorey, VP of Data at SoFi as a story · 1 points
HN discussionSubmitted Leading with commas – ugly or efficient? An investigation over 320 GB of SQL as a story · 1 points
HN discussionSubmitted Funnel Analytics with SQL: Match_recognize() as a story · 1 points
HN discussion