[hn_user2]

I’m an ex-ORM advocate.

In short, you are very very unlikely to ever change your database.

DBs are full of useful features that an ORM hides.

Instead, I now pick a DB that has the features I want and then use the hell out of the features.

I remember a pre-ORM time of so many manually created db side configs, stored procs, views, triggers, etc. that a DBA would have to manage. I think these unmanageable messes were one of the catalysts to getting people on board with ORMs.

To avoid going back that far. I make sure all config is part of code. Managed by migrations. Or otherwise checked into a repo and managed by a CI/CD pipeline. Now I get to use a full featured DB again. Actually use all its features. And things don’t turn into unmanageable messes.