Google Cloud Spanner is now half the cost of Amazon DynamoDB

Post by jiggawatts » Wed, Oct 11, 2023, 10:36 PM UTC

folmar wrote: post #303

jiggawatts wrote: post #283

Earlier quoted context omitted.

SQL Server supports in-memory columnstore tables. I’m not an expert but I suspect SAP HANA also. If you squint, any database engine is “in memory” if there is more buffer than data. Or just use a RAM disk!

> If you squint, any database engine is “in memory” if there is more buffer than data. That is sadly not true, I remember one lonely night debugging a MSSQL 2012 instance that was _very_ slow, and it turned out that for a simple query (one join, 100 rows in one table and 10 in the other, 100 result in total, one where clause) it forced writing the result to disk before evaluating the WHERE condition. Unable to fight…

Post by DevKoala » Wed, Oct 11, 2023, 10:37 PM UTC

vicpara wrote: post #182

Just moved our infra from GCP to AWS. Kubernetes clusters, LB, storage, lambdas, KMS and all of it. Google runs their tech stack as if it's a startup that builds their CV. Everything is immature, tons of hacks, undocumented features. If you are on their k8s there are tons of upcoming new versions and features that force you to revisit key hacks you put in your infra because of their misgivings. Our infra team keeps t…

Post by hot_gril » Wed, Oct 11, 2023, 10:45 PM UTC

mardifoufs wrote: post #247

vicpara wrote: post #182

Just moved our infra from GCP to AWS. Kubernetes clusters, LB, storage, lambdas, KMS and all of it. Google runs their tech stack as if it's a startup that builds their CV. Everything is immature, tons of hacks, undocumented features. If you are on their k8s there are tons of upcoming new versions and features that force you to revisit key hacks you put in your infra because of their misgivings. Our infra team keeps t…

I don't know. I like GCP. I have been in an Azure centric corporation for close to two years now and I dearly miss GCP almost every day. My team has a sort of a sandbox where we can use almost any Azure product we want (our IT is supportive and permissive as far as that sandbox goes, which is a blessing), but even then it's just painful in comparison. AWS is probably better though.

Post by HDThoreaun » Wed, Oct 11, 2023, 11:09 PM UTC

0xbadcafebee wrote: post #136

FredPret wrote: post #40

But a droplet with a Postgres db is nearly free, and seriously performant. And for 65/month, you can get a VERY beefy Hetzner server. You’ll have to wade through the crazy thicket that is the menu of cloud offerings. I gave that one look, and decided I might as well give up and learn the basics of Linux admin once and apply it for life.

Or you could use DynamoDB for basically free. One month of 1GB of storage, 1kb item size, 100,000 writes, and 100,000 reads, would be $0.39 on DynamoDB on-demand. A million writes and reads respectively would be $1.63. Strongly consistent reads'd make that $1.75, and transactional writes would make it $3.00

Post by lijok » Wed, Oct 11, 2023, 11:28 PM UTC

hatsix wrote: post #58

paxys wrote: post #22

Earlier quoted context omitted.

Postgres is a piece of software. Cloud Spanner/Dynamo etc are managed services. It makes no sense to directly compare one with the other.

Sure, You can compare Cloud SQL vs Cloud Spanner and RDS vs Dynamo, but it makes more sense to just say "Postgres" and assume that the reader can figure out that it means "Whatever managed postgres service you want to use". The entire point is that every cloud provider has a managed postgres offering, and there's no vendor lock-in. Though, technically, Dynamo does have a docker image you could run in other cloud prov…