3 ms·
Moving business logic into database functions is the shortest path to insanity.
by overflowy 3mo ago
Moving business logic into database functions is the shortest path to insanity.
- christophilus 3mo agoI agree with that. You can use Postgres as a message queue / task manager backing store without a database function, though, and it works quite well at the small scale that most sites / SaaS products operate at.
- jamesfinlayson 3mo agoI remember an old colleague telling me at a previous job they'd moved all business logic into triggers and stored procedures because their database was on their most powerful server. And then one day it wasn't and the database started to choke horrifically.