Skip to content
Documentation
GPA Overview
Bun Provider

Bun Provider

Overview

The Bun provider (github.com/lemmego/gpabun) wraps uptrace/bun to provide GPA-compatible SQL access. It’s a lighter alternative to GORM with a focus on SQL-first development.

Setup 

import (
    "github.com/lemmego/gpa"
    "github.com/lemmego/gpabun"
)

config := gpa.Config{
    Driver:   "postgres",
    Host:     "localhost",
    Port:     5432,
    Database: "mydb",
    Username: "user",
    Password: "password",
}

provider, err := gpabun.NewProvider(config)

Supported Drivers

  • PostgreSQL (via pgdialect)
  • MySQL (via mysqldialect)
  • SQLite (via sqlitedialect)

Creating Repositories 

// From a specific provider
repo := gpabun.NewRepository[User](provider)

// From the registry
repo := gpabun.GetRepository[User]()

Repository Type

The Bun repository implements gpa.SQLRepository[T]:

  • Full Repository[T] CRUD
  • Raw SQL (FindBySQL, ExecSQL)
  • Eager loading (FindWithRelations, FindByIDWithRelations)
  • DDL (CreateTable, DropTable, CreateIndex, DropIndex)

Differences from GORM

FeatureGORM ProviderBun Provider
MigrationYes (AutoMigrate)No (stub)
SavepointsYesNo
Validation HookYesNo
FeaturesTransactions, Indexing, Agg, RawSQLTransactions, Indexing, FullText, Joins, SubQueries

Hooks

The Bun provider supports Before/After Create/Update/Delete/Find hooks but does not support ValidationHook:

func (u *User) BeforeCreate(ctx context.Context) error {
    u.CreatedAt = time.Now()
    return nil
}

Use Cases

  • Projects that prefer Bun’s SQL-first approach over GORM’s ORM-heavy pattern
  • Applications needing full-text search or advanced subquery support
  • Lightweight deployments where Bun’s smaller footprint is beneficial
GORM ProviderMongoDB Provider