search

dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

ElephantQL #100

Open ndrean opened 1 year ago

ndrean commented 1 year ago

A cloud-based PostgreSQL managed service, on top of AWS, GCE and Azure. The free tier is 20 MB. Not sure if this is useful as most providers offer a Postgres connection in the free-tier. I used it once to simulate a remote connection to AWS.

Screenshot 2023-02-25 at 09 22 04

nelsonic commented 1 year ago

@ndrean thanks for opening this issue. Always good to capture the offering of cloud providers. https://www.elephantsql.com/plans.html image

Prices seem reasonable on the surface. But not a huge fan of the doubling in price just because data stored increases. i.e: going from 500GB to 501GB is $798 to $1598

It's very similar to Digital Ocean: https://www.digitalocean.com/pricing/managed-databases image image

For me the biggest question when hosting PostgreSQL is: What is the "distance" from the Application Server to the Database Server? If the servers are not colocated (same rack / data centre) then network latency is a UX-destroyer!

ndrean commented 1 year ago

I was also worried about safety. I am not a specialist but this happens over HTTPS. If you are on the same DC, meaning nside a VPN, Postgres runs on TCP with SSL I believe.