sqlc

Around the ORM choice, I would stay with raw SQL Queries and use sqlc with to generate the boilerplate (structs and the repository itself). I have been using it and it is amazing. Only issue it only supports postgres, although it has beta support for other DBs. https://github.com/kyleconroy/sqlc SQLx is good for simple read queries, but iirc for write operations you still need to map things manually and reads with JOINs are a bit tricky. Gorm might be good for simple CRUD applications, but it's magic has a performance cost.

The sqlc lib "generates fully type-safe idiomatic Go code from SQL". It makes sense to generate code from SQL and not the other way around. https://github.com/kyleconroy/sqlc

Go has something similar to this https://github.com/kyleconroy/sqlc

This is similar to sqlc for Golang: https://github.com/kyleconroy/sqlc If you're looking for the ability to generate type-safe SQL – given you write SQL correctly – this project is pretty good. Aalso a fan of SQLBoiler (https://github.com/volatiletech/sqlboiler) for Golang, for simple type safety: `models.Accounts(models.AccountWhere.ID.EQ(id)).One(ctx, db)`. Though SQLBoiler breaks with left joins, as it auto-generates your structs and maps results 1-1 with table definitions. In this case you have to custom type something, either using sqlc or squirrel.

A better equivalent in Go is https://github.com/kyleconroy/sqlc

As a maintainer of a similar project[0], it's great to see another entry in this space. sqlc currently has great support for Go and experimental support for Kotlin. I'm planning on adding TypeScript support in the future, so it's great to see that others in the TypeScript community find this workflow useful. [0] https://github.com/kyleconroy/sqlc

I maintain an open source project with ~2k stars (https://github.com/kyleconroy/sqlc). There’s a large list of bug reports and feature requests, but since I don’t work on it full time, I’ve gotten really good at saying “No” and “I’m sorry”.

SQL. I'm writing a compiler for SQL that parses DDL (CREATE TABLE, etc.) and queries and outputs type-safe Go. It currently supports PostgreSQL, but the plan is to support more engines and more output programming languages. https://github.com/kyleconroy/sqlc

I'm working on a tool that compiles SQL queries into type-safe code. It's called sqlc and it already works really well: https://sqlc.dev Go and PostgreSQL are currently supported, with Kotlin and MySQL support on the way. https://github.com/kyleconroy/sqlc

Very cool! I maintain a similar tool: sqlc https://github.com/kyleconroy/sqlc In addition to catching SQL errors, it generates type-safe Go wrapping code. Right now it supports PostgreSQL and MySQL. I’m (obviously) a huge fan of the SQL first approach and hope more people adopt it for their own projects.