Aren’t time series databases like Prometheus pretty good at storing this kind of data?
I don’t believe Prometheus supports geospatial data. Two minutes of googling though, so I could be wrong.
They’re just storing doubles in their own format too. I’m not sure if they even need any spatial lookups on the data, they didn’t mention anything about that in the article. Maybe they do that in-memory?
I imagine a delta encoding scheme similar to what the time series DBs use would work well for the geo points. Maybe even a delta-of-delta encoding for things like ships which move very consistently.
It’s probably not worth it given how small they’ve already go their data. But it is fun.
Why does everyone on the planet hate sql nowadays?
If your not dealing with billions of transactions why not?
Comparing cost to AWS Aurora is unfair. Give us the self host price, and compare to that.
Also, they should have tried Scylla or Cassandra. It’s very scalable and handles a lot of writes.
If you’re using Java you can use eclipsestore. Seems like a good project
Anyone tempted to write a custom database should ask if they’re prepared to be in the database maintenance business.
Because that’s where they’re heading, for a really long time.