News for hackers. Stuff that matters.
Re:Optimizing Large-Scale OpenStreetMap Data with SQLite by sitkack on Saturday July 06, 2024 @03:11PM (#40892497)
I went through a similar process when I converted wikipedia xml dumps into sqlite.

https://news.ycombinator.com/item?id=28013347

Re:Optimizing Large-Scale OpenStreetMap Data with SQLite by jtarchie on Monday July 08, 2024 @07:12PM (#40910775)
This is almost the same. We both do compression. The compression layer it transparent to the application via VFS.

I have tried this trick with Wikipedia too. It don’t have the numbers. I’ll push up the code when I can.