Why is Raw SQL preferred over ORM in go?

• sqlc

  169 10,950 9.6 Go

  Generate type-safe code from SQL

  

I was on a large project with Gorm (Go ORM) and what an unmaintainable mess. Trying to do complex queries in ORM when you already know SQL is a real pain. Also, the migration process on it was not powerful and failed many times. It saved me a ton of time to take individual micro-services and strip Gorm out and replace it with Standard SQL or https://sqlc.dev/

• ent

  145 14,930 8.1 Go

  An entity framework for Go

  

https://entgo.io is a good orm for Golang. It also built-in support for GraphQL, gRPC, Restful API

• InfluxDB

  www.influxdata.com sponsored

  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.

  

• yte.wsgi.py

  1 0 1.7 Python

  A Python WSGI REST wrapper around YoutubeExplodeSync

Actually, ditching flask is less readable but easily doable. https://github.com/cellularmitosis/yte.wsgi.py/blob/main/yte.wsgi.py

• Squirrel

  52 6,522 2.4 Go

  Fluent SQL generation for golang

  

I think he means an sql builder like squirrel. This allows dynamic queries, but more important you can reuse function that build a where clause so you can get a count and query with that.

Suggest a related project