Hacker News Reader

Comment by dig1 | Hacker News Reader

As someone dealing with billions of records on it, BigQuery is far from cheap; G will not charge you much for storage as they will charge you for queries and data transfer.

AFAIK, the cheapest Postgres server on GCP is very expensive compared to the usual Postgres installation (price/performance).

View on HN

Yep. I used it once for a personal project involving GHTorrent [0], and each query was about $20. That may be peanuts for a business, but for someone playing around on their own, it's incredibly prohibitive.

[0]: https://github.com/ghtorrent/ghtorrent.org/blob/master/gclou...

EDIT: The site no longer exists, it seems. The project (which is not my creation) was a regularly-updated dump of all GitHub metadata (PR comments, Issues, etc.). Here's an archive snapshot: https://web.archive.org/web/20220126060859/https://ghtorrent...

On billions of records my query costs were generally less than a cent. But I partitioned and clustered on the key fields.

Either the website this is referring to got hacked or you sold it. Either way, this probably shouldn’t be linked on HN.

What is hardboiled studios?

That and RDS are kind of a rip-off if you are trying to have a sandbox out there, short of running your own instance.

For that, I found Digital Ocean to be very reasonable.

DO’s pricing has increased a lot. I was surprised, I couldn’t start a $5 vm anymore, it’s worth checking again.

You can, but I think you have to be in one of the regions that supports it. The generally (globally?) available lowest priced VM is $6 a month.

https://www.digitalocean.com/pricing/droplets

What do you mean by "the usual Postgres installation"?

Reply on news.ycombinator.com