Decent examples querying models from Postgres

• sqlx

  71 15,448 3.6 Go

  general purpose extensions to golang's database/sql

Yes, the rows/scanning pattern is pretty verbose and gets annoying fast, which is why there are a lot of packages to help simplify this. The most popular is sqlx

• scan

  5 65 4.3 Go

  Scan provides the ability to to scan sql rows directly to any defined structure. (by stephenafamo)

Personally, I created a scanning package specifically for this based on generics and even more flexibility, still needs a bit more documentation, but check it out Scan.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• jet

  27 2,076 8.1 Go

  Type safe SQL builder with code generation and automatic query result data mapping

• sqlc

  170 11,012 9.6 Go

  Generate type-safe code from SQL

  

For me sqlc work wonders. If you are developing a user facing api and are fine to go with graphql, with gqlgen you can even autobind (search the page for @goModel) the models that sqlc generates from your queries. A glorious match

• gqlgen

  43 9,635 9.3 Go

  go generate based graphql server library

  

For me sqlc work wonders. If you are developing a user facing api and are fine to go with graphql, with gqlgen you can even autobind (search the page for @goModel) the models that sqlc generates from your queries. A glorious match

• SQLBoiler

  42 6,453 7.7 Go

  Generate a Go ORM tailored to your database schema.

  

Take a look at sqlboiler. It's an ORM that generates the database models for you based on the SQL schema.

Suggest a related project