Why ORMs are so hated?

• GORM

  74 35,416 8.4 Go

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

  

I have never hated gorm and it serves me well. However I tend to feed it raw SQL very often.

• sqlc

  169 10,837 9.7 Go

  Generate type-safe code from SQL

  

In Go we have http://sqlc.dev which allows you to define all your SQL queries and table schemas upfront in a single file and have all the model code generated for you.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• norm

  1 0 10.0 Java

  No ORM (NORM) is a Java library for working with database in a more SQL oriented way with Java safety mechanisms (by cmcgee-mac)

• sqlx

  144 11,742 9.2 Rust

  🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)

  

Thanks for sharing your experiences. I've been looking to get into snowflake for some time (even opened this https://github.com/launchbadge/sqlx/issues/986) . We thought to move to it years ago, but there's no way it was going to replace a significant amount of the mariadb we're running, and unless it did I wasn't looking forward to managing 2 DBs.

Suggest a related project