Tbh a lot of NoSQL databases don't use foreign key constraints. If you have a SQL system with messaging and eventual consistency you have to turn them off anyway.
So in a lot of ways, yes people use databases like they're just persistent memory with indexes.
So in a lot of ways, yes people use databases like they're just persistent memory with indexes.