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

This page summarizes the projects mentioned and recommended in the original post on /r/golang

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. reform

    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.

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. go-sql-driver/mysql

    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.

  4. sqlx

    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.

  5. Squirrel

    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.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Go Tool: (exploring) sqlc (Part 1)

    8 projects | dev.to | 15 Feb 2021
  • Golang equivalent of MyBatis/iBatis

    4 projects | /r/golang | 3 Jul 2023
  • Does sqlc/sqlx support MS-SQLServer? All examples for sqlc with postgres and mysql

    2 projects | /r/golang | 23 Feb 2023
  • Question about inserting date into MySQL?

    1 project | /r/golang | 15 Nov 2022
  • Creating an API using Go and sqlc

    5 projects | dev.to | 24 Oct 2022