13 ms·

What's it like using stored procedures with Ecto?

• cultofmetatron 6y ago
  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
  • iudqnolq 6y ago
    Cool. What language do you write the stored procedures in?
    • cultofmetatron 6y ago
      plpgsql
  • deleted 6y ago
    [deleted]