[Question] Working with databases/storing data in Go applications.

• reform

  1 1,435 0.0 Go

  A better ORM for Go, based on non-empty interfaces and code generation. (by go-reform)

  

However, you can use something like this https://github.com/go-reform/reform to help you with, I will call it automating the code writing. But I have always opted to one of the supported drivers and written a queries myself using for example this https://github.com/go-sql-driver/mysql.

• go-sql-driver/mysql

  19 14,204 7.8 Go

  Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

  

However, you can use something like this https://github.com/go-reform/reform to help you with, I will call it automating the code writing. But I have always opted to one of the supported drivers and written a queries myself using for example this https://github.com/go-sql-driver/mysql.

• 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.

  

• sqlx

  71 15,448 3.6 Go

  general purpose extensions to golang's database/sql

There's nothing particularly difficult or unusual. I run a small commercial website that has Go hitting a PostgreSQL db. I like https://github.com/jmoiron/sqlx to make the db queries. Yes, you have to know SQL, but that's a feature not a bug. It helps to know *how* and *why* things work. IMHO magic solutions like ORMs will eventually bite you.

• Squirrel

  52 6,540 2.4 Go

  Fluent SQL generation for golang

  

I prefer pure SQL for ORMs, but string manipulation is a lot of boilerplate. SQL generation https://github.com/Masterminds/squirrel + sqlx + database driver (e.g. pgx) works best for my tasks.

Suggest a related project