News for hackers. Stuff that matters.
Re:Write libraries instead of services, where possible by iudqnolq on Tuesday March 09, 2021 @02:09PM (#26402541)
What's it like using stored procedures with Ecto?
Re:Write libraries instead of services, where possible by cultofmetatron on Tuesday March 09, 2021 @02:13PM (#26402609)
surprisingly easy.

1. if I'm calling directly, I can just use a raw sql query 2. views can be backed with a read only ecto model 3. triggers can be set to run without your ecto code even being aware of it. 4. for custom errors, you can add overides for the error handling in ecto to transform things like deadlocks to 400 errors

Re:Write libraries instead of services, where possible by iudqnolq on Tuesday March 09, 2021 @02:17PM (#26402659)
Cool. What language do you write the stored procedures in?
Re:Write libraries instead of services, where possible by cultofmetatron on Tuesday March 09, 2021 @02:26PM (#26402815)
plpgsql