pg - PostgreSQL ORM for Golang with focus on PostgreSQL features and performance

  •        63

PostgreSQL ORM for Golang with focus on PostgreSQL features and performance. It supports Basic types, Multidimensional Arrays, Transactions, Prepared statements, Queries retries on network errors, Automatic connection pooling with circuit breaker support, Bulk/batch inserts and updates, Pagination and URL filters helpers, Migrations, Sharding and lot more.

http://godoc.org/github.com/go-pg/pg
https://github.com/go-pg/pg

Tags
Implementation
License
Platform

   




Related Projects

Kallax - PostgreSQL typesafe ORM for the Go language


Kallax is a PostgreSQL typesafe ORM for the Go language. It aims to provide a way of programmatically write queries and interact with a PostgreSQL database without having to write a single line of SQL, use strings to refer to columns and use values of any type in queries.

go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support


100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.Take a loot at line // gen:qs. It's a necessary line to enable querysets for this struct. You can put it at any line in struct's doc-comment.

sharding - PostgreSQL sharding for go-pg and Golang


This package uses a go-pg PostgreSQL client to help sharding your data across a set of PostgreSQL servers as described in Sharding & IDs at Instagram. In 2 words it maps many (2048-8192) logical shards implemented using PostgreSQL schemas to far fewer physical PostgreSQL servers.API docs: http://godoc.org/github.com/go-pg/sharding. Examples: http://godoc.org/github.com/go-pg/sharding#pkg-examples.

go_db_bench - Benchmarks for database/drivers from Go


This tests the performance of pgx native, pgx through database/sql, pq through database/sql, [go-pg](github.com/go- pg/pg), and theoretical maximum PostgreSQL performance. It always uses prepared statements.go_db_bench includes tests selecting one value, one row, and multiple rows.



db - Productive data access layer for Go.


The upper.io/db.v3 package for Go is a productive data access layer for Go that provides a common interface to work with different data sources such as PostgreSQL, MySQL, SQLite, MSSQL, QL and MongoDB.Take the tour to see real live examples in your browser.

noflo-pgorm - PostgreSQL ORM on top of noflo-pg


PostgreSQL ORM on top of noflo-pg

em-pg-client-helper - Helpful wrapper for em-pg-client


While em-pg-client is a nice solution to the problem of accessing a PostgreSQL database from within EventMachine, it is somewhat... spartan. ORMs have spoiled us somewhat, and so the appeal of hand-writing SQL and dealing with the finer details of error handling has faded. Hence the creation of the {PG::EM::Client::Helper} module. It contains a collection of useful helper methods that make it somewhat easier to perform common operations against PgSQL databases.

pq - Pure Go Postgres driver for database/sql


pq is a pure Go postgres driver for Go's database/sql package.

reform - A better ORM for Go, based on non-empty interfaces and code generation.


A better ORM for Go and database/sql.It uses non-empty interfaces, code generation (go generate), and initialization-time reflection as opposed to interface{}, type system sidestepping, and runtime reflection. It will be kept simple.

qbs - QBS stands for Query By Struct. A Go ORM.


Qbs.Find is about 60% faster on mysql, 130% faster on postgreSQL than raw Db.Query, about 20% slower than raw Stmt.Query. (benchmarked on windows). The reason why it is faster than Db.Query is because all prepared Statements are cached in map.Go get to get the most recent source code.

SQLBoiler - Generate a Go ORM tailored to your database schema.


SQLBoiler is a tool to generate a Go ORM tailored to your database schema.It is a "database-first" ORM as opposed to "code-first" (like gorm/gorp). That means you must first create your database schema. Please use something like goose, sql-migrate or some other migration tool to manage this part of the database's life-cycle.

anyevent-pg - Fork of AnyEvent::Pg event-driven module for the PostgreSQL client library


Fork of AnyEvent::Pg event-driven module for the PostgreSQL client library

djorm-ext-hstore - PostgreSQL HStore module integration for django orm.


PostgreSQL HStore module integration for django orm.

gopqgen - Generates the Go structs and getters/setters for PostgreSQL Database


This project aims to generate common CRUD operations for a given PostgreSQL database and expose them as a gRPC API.Note: It is a work on progress.

gomodel - A lightweight, fast, orm-like library helps interactive with database


gomodel provide another method to interact with database. Instead of reflection, use bitset represent fields of CRUD, sql/stmt cache and generate model code for you, high performance.The gomodel cmd tool and SQL convertion for structures.

pgweb - Cross-platform client for PostgreSQL databases


Web-based PostgreSQL database browser written in Go.Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.