[parthdesai]

> Using Ecto as the main way of interacting with the database was a miserable experience.

Ecto is prolly one of the best ways to interact with db. Genuinely curious, what other ORMs have you used?

[zinclozenge]

I usually just write the SQL, honestly. For the last 6ish years of my career I've mainly been in the Golang world, so the closest I've gotten to an ORM is a utility to scan rows into structs.

[freedomben]

Interesting, I usually just write the SQL too in most projects, but in Elixir I love Ecto because it's so close to the SQL but has an elegant and powerful way to handle interpolated values.

[Andys]

Have you tried sqlc? Different to any other SQL library I've used and suits Go really well

[zinclozenge]

Yes, I like it very much. I've run into some edge cases with it, and I wish there was a setting to change the names of some of the autogenerated code, but otherwise it works very well.

[Andys]

Yeah, hopefully its plugin architecture will continue to develop and make changing things easier in the future.