[wackget]

No support for collation is an enormous dealbreaker. It means you can't have case-insensitive searches or keys (e.g. [e-mail] is treated differently than [e-mail]). You also can't rename databases.

The query syntax is also a massive pain IMHO. Especially when you get into nesting expressions. E.g. I can never remember if it's `{$id: $regex{'/pattern/'}}` or `{$id: ${regex: '/pattern/'}}` or `{$id: $regex{ pattern: '/pattern/' }}` or something totally different.

SQL is still superior.

[willio58]

>It means you can't have case-insensitive searches or keys (e.g. [e-mail] is treated differently than [e-mail]). You also can't rename databases.

Can't you just query for a lowercase version of the input and sanitize data going into the DB so it's only lowercase? I'm not a mongo user but that doesn't seem like a dealbreaker to me

[tstrimple]

Yes, you'd do something just like that. Document databases aren't relational databases. People need to think about solving the same problems a little differently. A lot of folks used to relational databases push for some perfect third normal form like disk space is still the major constraint in massive databases. For document databases, you design them based on how they are going to be used. Even if that means duplication of data like storing the lowercase version of something for indexing or rolling up your data into summary collections instead of performing those sorts of queries or collection aggregations on-demand.

[hot_gril]

Relational DBs often involve duplication for these kinds of use cases. Simple case-insensitive match can be handled with a custom index that's automatically derived from the col data, but there are more advanced cases where you need manually denormalized tables. Or sometimes it makes sense for performance reasons, but you only do this after you notice the normalized way being too slow.

[tstrimple]

Sure. It's not like all folks who lean on relational databases are third normal form zealots. But third normal form zealots exclusively come from a relational database background. Which makes sense.

[hot_gril]

They probably do, but idk, I've never considered 3NF or the preferred type of DBMS as part of someone's personal identity. These are just tools.

[willio58]

I’ve been using DynamoDB for the first time recently and this is some good perspective to bring to it!