News for hackers. Stuff that matters.
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by vovavili on Wednesday March 18, 2026 @03:45PM (#47430512)
Replacing an 11.6GB Parquet file every 5 minutes strikes me as a bit wasteful. I would probably use Apache Iceberg here.
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by ai-inquisitor on Wednesday March 18, 2026 @03:54PM (#47430631)
It's not doing that. If you look at the repository, it's adding a new commit with tiny parquet files every 5 minutes. This recent one only was a 20.9 KB parquet file: https://huggingface.co/datasets/open-index/hacker-news/commi... and the ones before it were a median of 5 KB: https://huggingface.co/datasets/open-index/hacker-news/tree/...

The bigger concern is how large the git history is going to get on the repository.

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by btown on Wednesday March 18, 2026 @04:16PM (#47430878)
I recall that this became a big problem for the Homebrew project in terms of load on the repo, to the extent that Github asked them not to recommend/default-enable shallow clones for their users: https://github.com/Homebrew/brew/issues/15497#issuecomment-1...

This is likely to be lower traffic, and the history should (?) scale only linearly with new data, so likely not the worst thing. But it's something to be cognizant of when using SCM software in unexpected ways!

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by roncesvalles on Wednesday March 18, 2026 @04:32PM (#47431061)
How would shallow clone be more stressful for GitHub than a regular clone?
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by enchilada on Wednesday March 18, 2026 @04:45PM (#47431221)
Shallow clones (and the resulting lack of shared history data) break many assumptions that packfile optimisations rely on.

See also: https://github.com/orgs/Homebrew/discussions/225

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by vovavili on Wednesday March 18, 2026 @04:04PM (#47430738)
This makes more sense. I still wonder if the author isn't just effectively recreating Apache Iceberg manually here.
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by tomrod on Wednesday March 18, 2026 @04:05PM (#47430751)
Are they paying for the repo space, I wonder?
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by cyanydeez on Wednesday March 18, 2026 @04:25PM (#47430971)
someones paying to keep name dropping Iceberg(tm)
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by mulmen on Wednesday March 18, 2026 @06:40PM (#47432304)
Weird accusation. Iceberg is an Apache project. I don’t think anyone gets paid when you use it so not sure what the benefit of shilling would be. It is just a table format that’s well suited for this purpose. I would expect any professional to make a similar recommendation.
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by tamnd on Thursday March 19, 2026 @06:47AM (#47437294)
I intentionally kept it lightweight. Just Parquet files + simple partitioning + commits on Hugging Face. That already covers most of what I need, without introducing a heavier stack or extra dependencies.

Also, I wanted something that is easy to consume anywhere. With this setup, you can point DuckDB or Polars directly at the data and start querying, no catalog or special tooling required.

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by sureglymop on Thursday March 19, 2026 @06:09AM (#47437058)
So they are sharding by time/day?

I have a similar project right now where I am scraping a dataset that is only ever offering the current state. I am trying to preserve the history of this dataset and was thinking of using the same strategy. If anyone has experience or pointers in how to best add time as a dimension to an existing generic dataset, I'd love to read about it.

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by zerocrates on Wednesday March 18, 2026 @03:56PM (#47430642)
"The dataset is organized as one Parquet file per calendar month, plus 5-minute live files for today's activity. Every 5 minutes, new items are fetched from the source and committed directly as a single Parquet block. At midnight UTC, the entire current month is refetched from the source as a single authoritative Parquet file, and today's individual 5-minute blocks are removed from the today/ directory."

So it's not really one big file getting replaced all the time. Though a less extreme variation of that is happening day to day.

Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by tomrod on Wednesday March 18, 2026 @04:06PM (#47430761)
Parquet is a very efficient storage approach. Data interfaces tend to treat paths as partitions, if logical.
Re:Show HN: Hacker News archive (47M+ items, 11.6GB) as Parq... by fabmilo on Wednesday March 18, 2026 @03:47PM (#47430548)
Was thinking the same thing. probably once a day would be more than enough. if you really want a minute by minute probably a delta file from the previous day should be more than enough.