undefined | Better HN

0 pointsconst_cast8mo ago0 comments

I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.

0 comments

Yes, we already have all of our business logic in postgres functions(create_order, create_partial_payment etc).

Doing the extra work in stored procedures is noticeably faster than relying on triggers.

j / k navigate · click thread line to collapse

0 pointsconst_cast8mo ago0 comments

I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.

Yes, we already have all of our business logic in postgres functions(create_order, create_partial_payment etc).

Doing the extra work in stored procedures is noticeably faster than relying on triggers.

j / k navigate · click thread line to collapse