go-gorp/gorp
Gorp
Gorp is a lightweight object-relational mapper for Go that binds structs to relational database tables. It functions as a relational data mapper and SQL dialect abstraction layer, automating the translation between application data and relational rows.
The project provides a translation layer that generates vendor-specific SQL for PostgreSQL, MySQL, SQLite, Oracle, and SQL Server. It distinguishes itself by implementing optimistic locking via version columns to prevent concurrent update conflicts and providing a database schema generator to create tables and indexes from object definitions.
The capability surface covers standard CRUD operations, atomic transaction management, and query result binding to slices or structs. It includes support for lifecycle hooks to automate record processing and observability tools for logging and tracing executed SQL statements.
Features
- CRUD Operations - Provides a consistent interface for basic create, read, update, and delete operations.
- SQL ORMs - Implements a lightweight object-relational mapper that binds Go structs to relational database tables.
- Database Access Layers - Provides a consistent API for CRUD operations and transactions regardless of the underlying database driver.
- Database Schema Generation - Automatically creates or modifies database tables and indexes based on object definitions.
- Database Transaction Management - Provides programmatic control of atomic transaction boundaries to ensure data consistency.
- Object-Relational Mappers - Maps database rows to hierarchical Go objects using tags and custom type conversions.
- Struct-to-Table Mappings - Provides mechanisms to map Go structs to relational database tables for automated data translation.
- Query Result Binding - Binds the results of select queries to pointers to populate Go variables with data from returned rows.
- Query Result Bindings - Binds raw SQL query results to Go slices or structs using custom scanning functions.
- SQL Database Engine Support - Provides a standardized interface that works across PostgreSQL, MySQL, SQLite, Oracle, and SQL Server.
- SQL Dialect Adapters - Translates operations across multiple database engines including SQLite, PostgreSQL, MySQL, SQL Server, and Oracle.
- Dialect-Specific SQL Generation - Provides translation of generic operations into SQL strings tailored to specific database versions and dialects.
- SQL Schema Generators - Automatically derives database table and type definitions from Go struct definitions.
- Struct-to-Table Mappings - Links Go object structures to relational database tables using tags to define column names and primary keys.
- Reflection-Based Population - Uses runtime reflection to automatically populate struct fields with data returned from database query results.
- Database Column Bindings - Binds database result columns to strongly-typed Go primitives using custom scanning functions.
- Query Result Bindings - Binds the results of raw SQL queries to Go slices, structs, or primitive types.
- Database Type Mappings - Translates application-level Go types into Oracle-specific database column types.
- Row-to-Struct Mappers - Automatically transforms database result sets into hierarchical Go objects by supporting nested structs.
- Data Type Mappings - Translates Go types and structs into Snowflake SQL data types for table creation.
- Complex Data Type Mappings - Translates complex language structures like slices or custom types into database-compatible formats during persistence.
- Database Index Management - Enables the creation and registration of indexes to optimize query performance.
- Database Lifecycle Hooks - Triggers custom logic before or after database operations to automate tasks like timestamping.
- Schema Constraints - Specifies primary keys and multi-column uniqueness constraints for relational tables.
- MySQL Integrations - Provides specific support for translating Go types into corresponding MySQL column types.
- Optimistic Locking - Prevents concurrent update conflicts by tracking and verifying version columns on model instances.
- Database-Specific Type Mappings - Maps Go primitive types and structs to Microsoft SQL Server data types.
- Persistence Lifecycle Hooks - Implements lifecycle hooks to automate tasks like timestamping or validation before and after data persistence.
- Databases & Data - Object-relational mapper for mapping structs to database tables.
- Object Relational Mappers - ORM-like library for Go.
- Object Relational Mapping - ORM-like library for Go.
- ORM and Data Mapping - Relational persistence ORM-ish library.
