Popularity
9.2
Growing
Activity
8.9
Growing
4,087
85
303
Programming language: Go
Tags:
ORM
Latest version: v10.0.0-beta.2
go-pg alternatives and similar packages
Based on the "ORM" category
-
upper.io/db
Single interface for interacting with different data sources through the use of adapters that wrap mature database drivers. -
go-queryset
100% type-safe ORM with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support based on GORM. -
SQLBoiler
An ORM generator. Generate a featureful and blazing-fast ORM tailored to your database schema. -
REL
💎 Modern Database Access Layer for Golang - Testable, Extendable and Crafted Into a Clean and Elegant API
Scout APM: Application Performance Monitoring
Scout gets developers back to coding faster. An intuitive UI streamlines real-time performance insight so you can quickly pinpoint & resolve issues before the customer ever sees them. Start your free trial today!
Promoted
scoutapm.com
Do you think we are missing an alternative of go-pg or a related project?
Popular Comparisons
|
SaaSHub - Software Alternatives and Reviews
More from our partner
|
README
PostgreSQL client and ORM for Golang
:heart: Uptrace.dev - distributed traces, logs, and errors in one place
- Join Discord to ask questions.
- Docs
- Reference
- Examples
- Example projects:
- GraphQL Tutorial on YouTube.
Ecosystem
- pgext - faster JSON encoding, OpenTelemetry hook, etc.
- Migrations by vmihailenco and robinjoseph08.
- Genna - cli tool for generating go-pg models.
- urlstruct to decode
url.Valuesinto structs. - Sharding.
Features
- Basic types: integers, floats, string, bool, time.Time, net.IP, net.IPNet.
- sql.NullBool, sql.NullString, sql.NullInt64, sql.NullFloat64 and pg.NullTime.
- sql.Scanner and sql/driver.Valuer interfaces.
- Structs, maps and arrays are marshalled as JSON by default.
- PostgreSQL multidimensional Arrays using array tag and Array wrapper.
- Hstore using hstore tag and Hstore wrapper.
- Composite types.
- All struct fields are nullable by default and zero values (empty string, 0, zero time, empty map
or slice, nil ptr) are marshalled as SQL
NULL.pg:",notnull"is used to add SQLNOT NULLconstraint andpg:",use_zero"to allow Go zero values. - Transactions.
- Prepared statements.
- Notifications using
LISTENandNOTIFY. - Copying data using
COPY FROMandCOPY TO. - Timeouts and canceling queries using context.Context.
- Automatic connection pooling with circuit breaker support.
- Queries retry on network errors.
- Working with models using ORM and SQL.
- Scanning variables using ORM and SQL.
- SelectOrInsert using on-conflict.
- INSERT ... ON CONFLICT DO UPDATE using ORM.
- Bulk/batch inserts, updates, and deletes.
- Common table expressions using WITH and WrapWith.
- CountEstimate
using
EXPLAINto get estimated number of matching rows. - ORM supports has one, belongs to, has many, and many to many with composite/multi-column primary keys.
- Soft deletes.
- Creating tables from structs.
- ForEach that calls a function for each row returned by the query without loading all rows into the memory.
- Works with PgBouncer in transaction pooling mode.