ORM or no ORM (and which ones)?

• sqlc

  170 11,012 9.6 Go

  Generate type-safe code from SQL

  

SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.

• Squirrel

  52 6,547 2.4 Go

  Fluent SQL generation for golang

  

I personally do the no ORM approach, often combining query-builders with SQL drivers (sqlx + squirrel) as to avoid raw SQL in my code. You can build composable query this way and it lessens the likelihood of someone accidentally creating a SQL injection vulnerability.

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

  

• almanack

  11 21 9.0 Go

  Predicts future sports scores

  

You just write more queries and sqlc will make ad hoc types for you. I have a bunch of code here: https://github.com/spotlightpa/almanack/tree/master/internal/db https://github.com/spotlightpa/almanack/tree/master/sql/queries

• GORM

  74 35,527 8.5 Go

  The fantastic ORM library for Golang, aims to be developer friendly

  

Hello, I want to communicate with a database in my go API. My API is for a website that allows you to track finances and budgets, so the reason I need a database is to store the user's expenses and allow them to search and find each one and which one is costing them the most. I also am going to implement login soon, but I don't think that matters for now. I'm now stuck on how to communicate with my database (Postgres). Should I go with an ORM like gorm, database/sql package, sqlx, or any others? Advice is appreciated

• sqlx

  71 15,448 3.6 Go

  general purpose extensions to golang's database/sql

https://github.com/jmoiron/sqlx and github.com/lib/pq are pretty solid, this is what i go to.

• tinyORM

  2 1 5.2 Go

  A tiny package for your basic data layer needs (by BitlyTwiser)

• bun

  18 3,161 7.9 Go

  SQL-first Golang ORM (by uptrace)

  

This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• ent

  145 14,975 8.1 Go

  An entity framework for Go

  

Check out https://entgo.io/ I like the approach to define an entity schema first and let handle entgo the query part.

• sqload

  3 40 0.8 Go

  Load your SQL queries from .sql files instead of writing the SQL code in your Go source files.

sqload

• goyesql

  1 249 5.0 Go

  Go + Yesql (by nleof)

Yesqlgoyesql

• jet

  27 2,076 8.1 Go

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

Use sql builder https://github.com/go-jet/jet.

• goqu

  23 2,245 5.6 Go

  SQL builder and query library for golang

SQL Builders (think squirrel or goqu)

• SQLBoiler

  42 6,453 7.7 Go

  Generate a Go ORM tailored to your database schema.

  

SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.

Suggest a related project