And referential integrity, transactions, and SQL types are only dimly important in a Rails app or something in Node using Sequelize.

Plenty of apps--perhaps more apps than not--use a database as a vaguely typed (MySQL out of strict mode barely gives a nod to them) multiplayer notepad.