Remix.run Logo
tibbar 2 hours ago

This has been tried, but thousand-line stored procedures are truly a nightmare.

agumonkey an hour ago | parent [-]

was it due to the language expressiveness forcing too much verbosity ? (honest question)

tibbar 17 minutes ago | parent [-]

lack of version control, clunky language mechanics, performance issues, etc.

bob1029 5 minutes ago | parent [-]

Version control might not be a big deal if you are all-in on the database.

Stored procedures are easiest to version by simply defining multiple variants and then incrementally moving the callers in the direction you want. The durability comes from (hopefully) your backups. Point-in-time-recovery is often easier for the business to reason about than a git repository.