Email or username:

Password:

Forgot your password?
Top-level
Gregory

Oh for fuck's sake. Why are there places that
- don't have coordinates
- don't have an address
- don't have a country
- don't have a date when they were created?!
What's next, places that don't have a name?

4 comments
Gregory

Also what's this thing with throwing exceptions, especially a RuntimeException, when a value is not present? Just return a null ffs. It's not like it's a catastrophic event that warrants an exception that you can't even meaningfully catch.

Gregory

I feel like the more data is in the table, the longer it takes to insert new rows into it. And nope that 10.5 GB estimate wasn't right, it's more like 20-something because of the compression. I misled myself by opening one of the files in a hex editor, seeing meaningful strings, and assuming that it must be uncompressed.

Gregory

It's done now! The table is 26.67 GB, there are 106 620 768 rows.

dmitriid

@grishka

Fallacies programmers believe about places? :)

Go Up