4 ms·
> Business logic was PL/SQL Funny that you said that because i sometimes hear “store your database logic / invariants in the database!” I guess it depends wha
by armchairhacker 5y ago
> Business logic was PL/SQL
Funny that you said that because i sometimes hear “store your database logic / invariants in the database!”
I guess it depends what kind of logic.
- theshrike79 5y agoIn this case it was decoding binary responses from devices directly off the wire. Completely bonkers setup. If the PL/SQL parser failed, there goes that message. Oh, well. Try again next day when the message arrives or dial the device and ask it to send it again. I suggested after a while if we could store the raw message in a queue table and parse it from there. But no, everyone was too scared to change the system and we stuck to the old ways.