How can I use sqlc if I don't know how to write sql files?

[frederikhors]

I'm using go-pg right now.

I wanna try sqlc but I'm too inexperienced to define PG tables properly.

For example I don't know what is the right choice for ID columns and other definitions which instead using Gorm or go-pg come to me "FREE".

What do you recommend to those like me in this situation?

[mvrhov]

That you borrow a book an learn SQL

[kyleconroy]

sqlc requires a good understanding of SQL. There's no shame in using other Go ORMs that require less SQL knowledge. If you're just getting into SQL, this is a good place to start: https://gumroad.com/l/sql-zine.

[app-o-matix]

You might also check out dbdiagram.io as a step toward learning sql. It's sql-ish and generates sql that can be exported for Postgres, MySql, or Sql Server.