3 ms·
What's the general consensus of what logic should remain in the DB? There are a few places I write SQL and call it from a host language and think "this feels li
by jjice 5y ago
What's the general consensus of what logic should remain in the DB? There are a few places I write SQL and call it from a host language and think "this feels like it should all be in SQL, but it'd be much more verbose". Just interested in what anyone here thinks.
- mberger 5y agoI've stuck with thinking of Pl/* as an aid to data normalization. This way i can look up records like country codes in the database but keep business rules in the app.
- sa46 5y agoI use plpgsql for constraints but try to avoid any form of mutation mostly based on other folks horror stories.