Usage of PostgreSQL for Web Scraping and datasets management.
PostgresSQL is great. But administering it can suck up a lot of time and for small teams using SaaS service is great value. We use and love Amazon RDS. Until recently it was the only reasonable choice in the market. But in 2017 new options ore on the verge of becoming available. Both Google and Azure clouds announced support and Amazon is also launching their Aurora service with PostgreSQL compatibility.
We did a quick comparison of those options.
TLDR: Google and Aurora are a bit faster for the same money but it’s no free lunch. Azure tests are not yet done.
Use case we care about is “mid size” database and queries […]