Menu

SQL vs NoSQL on AWS (Aurora, RDS or DynamoDB)
📰

SQL vs NoSQL on AWS (Aurora, RDS or DynamoDB)

DEV Community: aws·Ifeanyi O.·5 days ago
#AtYmp295
#devtoaws#devto#dev#aurora#database
Long article (1929 words) — no AI summary yet.
Reading 0:00
15s threshold

Intro

A database is one of the few architecture decisions that can be expensive to reverse. Pipelines can get replaced and caches get swapped easily, but by the time you know whether the database choice was right, you already have a schema, query layer and production data that must move together.

Consider our working example:

You're a software engineer at REXTECH, a company that operates public EV charging stations across the United States and you've been handed the next version of their platform along with ownership of the data layer. The platform does three jobs:

Drivers open an app to find charging stations near them and see which connectors are free

The platform meters and bills each charging session as it happens

The operations team needs to know which stations are busy, which are failing and what revenue looks like by region

REXTECH runs all this today on a single PostgreSQL database in their own data center.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.