GORM — The Fantastic ORM Library for Go

What it is

GORM is the most widely adopted ORM library for the Go programming language. It provides a developer-friendly, chainable API for database operations including auto-migration, associations (has-one, has-many, many-to-many, polymorphic), hooks, transactions, and query building. It supports PostgreSQL, MySQL, SQLite, and SQL Server.

GORM is best suited for Go developers who want ActiveRecord-style productivity without writing raw SQL for every operation. Teams building web APIs, microservices, or any Go application that talks to a relational database will find GORM reduces boilerplate significantly.

How it saves time or tokens

GORM eliminates repetitive SQL boilerplate. Instead of writing CREATE TABLE statements, you define Go structs and call db.AutoMigrate(). Instead of hand-crafting INSERT/UPDATE/DELETE queries, you use db.Create(), db.Save(), and db.Delete(). The chainable query builder handles WHERE clauses, joins, preloading, and pagination in a type-safe manner. For AI-assisted coding workflows, GORM's declarative struct-tag approach means you describe your schema once and the ORM handles the rest, reducing token consumption when generating database logic.

How to use

1. Install GORM and a database driver: go get -u gorm.io/gorm and go get -u gorm.io/driver/sqlite (or postgres/mysql).
2. Define your models as Go structs embedding gorm.Model for automatic ID, timestamps, and soft delete.
3. Open a database connection with gorm.Open(), run db.AutoMigrate() to sync your schema, and use the chainable API for CRUD.

Example

package main

import (
    "gorm.io/gorm"
    "gorm.io/driver/sqlite"
)

type User struct {
    gorm.Model
    Name  string
    Email string `gorm:"uniqueIndex"`
    Age   int
}

func main() {
    db, _ := gorm.Open(sqlite.Open("app.db"), &gorm.Config{})
    db.AutoMigrate(&User{})

    // Create
    db.Create(&User{Name: "Alice", Email: "alice@example.com", Age: 30})

    // Read
    var user User
    db.First(&user, "name = ?", "Alice")

    // Update
    db.Model(&user).Update("Age", 31)

    // Delete (soft delete by default)
    db.Delete(&user)
}

Related on TokRepo

• Automation tools -- tools that reduce repetitive development tasks
• Database AI tools -- AI-powered database utilities and integrations

Common pitfalls

• Forgetting that gorm.Model enables soft delete by default. Deleted records remain in the database with a non-null deleted_at column. Use db.Unscoped().Delete() for hard deletes.
• Using db.Save() on a struct without a primary key value triggers a CREATE instead of UPDATE. Always load the record first or set the ID explicitly.
• N+1 query problems with associations. Use db.Preload('Orders') to eager-load related records instead of accessing them in a loop.