What's your take on Aurora DSQL? My take is anything single cloud provider propr...

sgarland · 2025-01-15T13:19:35 1736947175

Relational databases (sans JSON columns) are limited in the same way that seatbelts limit your ability to be transfenestrated during a crash.

Having a rigid and well-designed schema is a mechanism to keep you or your team from doing stupid things.

tempworkac · 2025-01-15T13:38:49 1736948329

nosql does not imply no schema

sgarland · 2025-01-15T14:37:46 1736951866

I think most would infer that, but in any case, it most definitely implies a non-rigid schema.

Cassandra et al. IMO only fall under the NoSQL banner by retconning the meaning to be “Not Only SQL.” Columnar DBs are a fine idea for certain uses.

Document DBs and/or chucking everything into a JSON column, though… those can die in a fire.

tempworkac · 2025-01-15T14:41:56 1736952116

the only thing nosql means is that there are no relations. mongodb 8 and newer for example support schemas and validations, cascading checks, etc. dynamodb, more relevantly does also support a schema, and in fact you can't even create a table without defining one.

qaq · 2025-01-15T18:13:55 1736964835

Honestly haven't really had to deal with use case where json column does not cut it, but I would imaging there might be some.