Skip to content

Comment on Ask HN: Storing and Processing Large Amounts of Temporal-Spatial Data

Comments

Both MySQL and Postgres support some GIS features, I would definitely recommend taking a look. I bookmarked this book about postGIS but I haven't read it: http://www.postgis.us/ .

If the databases can handle your queries efficiently then it could save you a lot of work and you won't have to do anything nasty.

From a quick back-of-the-envelope calculation, you should have under 20GB of data, so if you need to perform an inefficient computation with low latency storing it all in RAM isn't out of the question.

Postgres seems like a good option. Thanks!

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.