pgx VS GORM

Compare pgx vs GORM and see what are their differences.

pgx

PostgreSQL driver and toolkit for Go (by jackc)

GORM

The fantastic ORM library for Golang, aims to be developer friendly (by go-gorm)
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
pgx GORM
71 80
10,721 36,825
- 0.5%
9.1 8.3
3 days ago 16 days ago
Go Go
MIT License MIT License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pgx

Posts with mentions or reviews of pgx. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-04-22.
  • Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App
    2 projects | dev.to | 22 Apr 2024
    Sometimes, backend developers tend to opt for an ORM library because it provides an abstraction between your app and the database and thus there is little or no need to write raw queries and migrations which is nice. However, if you want to get better at writing queries (SQL for example), you need to learn how to build your repositories without an ORM. To open a database handle, you can either do it directly from the database driver or do it from database/sql with the driver passed into it. I will be opening the connection with database/sql together with pgx which is a driver and toolkit for PostgreSQL. Walk with me.
  • The DDD Hamburger for Go
    2 projects | dev.to | 6 Jan 2024
    The infrastructure layer contains the concrete implementation of the repository domain interface ActivityRepository in the struct DbActivityRepository. This repository implementation uses the Postgres driver pgx and plain SQL to store the activity in the database. It uses the database transaction from the context, since the transaction was initiated by the application service.
  • Building RESTful API with Hexagonal Architecture in Go
    21 projects | dev.to | 27 Sep 2023
    For building the RESTful Point of Sale service API, I've considered and selected a combination of technologies that would work seamlessly together. For handling HTTP requests and responses, using the Gin HTTP web framework would make sense because I think it seems complete and popular among Go community too. To ensure data integrity and persistence, I'm using PostgreSQL database with pgx as the database driver, the reason I choose PostgreSQL because it is the most popular relational database to use in production and offers efficient Go integration. I'm also implementing caching using Redis with go-redis client library, which provides powerful in-memory data storage capabilities.
  • Working with postgres in GO.
    2 projects | /r/golang | 3 Jul 2023
    If you are willing to commit to working only with Postgres, I highly recommend pgx. Be sure you get the latest version github.com/jackc/pgx/v5. This gives you the full power of interacting with Postgres without going through an intermediate lowest-common-denominator library.
  • How to Use Iris and PostgreSQL for Web Development
    6 projects | dev.to | 2 Jul 2023
    It uses pg package and pgx driver under the hood.
  • Could I get a code review?
    11 projects | /r/golang | 1 Jun 2023
    Starting off, is there any reason you're calling out to the CLI, instead of just using a Postgres driver like pgx? Shelling out to the command line should always be a last resort where possible as a software engineer.
  • Why elixir over Golang
    10 projects | /r/elixir | 29 May 2023
    For maintaining state I use PostgreSQL. Driver: https://github.com/jackc/pgx (I use the pgxpools) Along with Sqlc for generating database models and allowing me to focus on just building queries in DBeaver. https://sqlc.dev/
  • Make psql display settings on login
    1 project | /r/PostgreSQL | 24 May 2023
    An example of what I'm looking for can be found here https://github.com/jackc/pgx/wiki/Getting-started-with-pgx-through-database-sql/c9f798b4d9a500fcf93931df2464af969d68f516
  • Zig now has built-in HTTP server and client in std
    3 projects | news.ycombinator.com | 18 May 2023
    Except pgx recommends using their native interface, not database/sql, for performance and extra features [0], so it's not that simple in practice.

    [0]: https://github.com/jackc/pgx#choosing-between-the-pgx-and-da...

  • Go Roadmap
    2 projects | /r/golang | 5 May 2023
    pgx is “PostgreSQL driver and toolkit for Go”. Take a look at https://github.com/jackc/pgx

GORM

Posts with mentions or reviews of GORM. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-10-23.
  • Toasty, an Async ORM for Rust
    5 projects | news.ycombinator.com | 23 Oct 2024
    I never understood why people are so stubborn about hating on orm.

    For example I'm familiar with https://gorm.io and it does save me a lot of time and useless boilerplate.

    And guess what, if I ever need to make a complex query, I also happen to know SQL, and I'm just going to make a "raw" query https://gorm.io/docs/sql_builder.html#Raw-SQL and be done with it.

    It's not all that hard.

  • Building a RESTful API with Go Fiber: An Express-Inspired Boilerplate
    13 projects | dev.to | 5 Oct 2024
    SQL database: PostgreSQL Object Relation Mapping using Gorm
  • Store IoT device data
    2 projects | dev.to | 26 Sep 2024
    The previous post demonstrated receiving the raw data and unmarshalling it into a struct that was already annotated with gorm tags. Gorm is a popular ORM for Go. If you are not familiar with it, you can for more information here.
  • GORM, PostgreSQL & Atlas
    4 projects | dev.to | 12 Aug 2024
    GORM is a, quite conveniently named, ORM for GO
  • Scaling Backend to 1M requests with just 2GB ram ⚡️
    2 projects | dev.to | 14 Jun 2024
    Written in GIN framework and uses GORM as ORM.
  • How to handle migrations in Golang
    5 projects | dev.to | 11 Jun 2024
    There are ORMs like gorm that supports some kind of documentation with files, but they mainly focus on converting the database to "things" in the code to be used by the ORM, and not as documentation only/documentation-first.
  • Go ORMs Compared
    5 projects | dev.to | 18 Jan 2024
    GORM is a comprehensive ORM tool in Go, offering a code-first approach which allows defining database schemas using struct tags in Go. It's known for its developer-friendly nature, making it suitable for both beginners and experienced users. GORM supports a variety of SQL databases like MySQL, PostgreSQL, and SQLite. It's designed to be flexible, allowing developers to drop down to raw SQL when necessary. However, it's important to be cautious about its performance implications in large-scale applications.
  • 6 🔥 Awesome Golang packages (web devs)
    6 projects | dev.to | 4 Dec 2023
    Homepage: https://gorm.io/
  • Tenha controle sobre seu SQL com Golang e SQLC
    3 projects | dev.to | 25 Nov 2023
  • Não use funções puras com Go
    1 project | dev.to | 22 Oct 2023

What are some alternatives?

When comparing pgx and GORM you can also consider the following projects:

sqlx - general purpose extensions to golang's database/sql

ent - An entity framework for Go

pq - Pure Go Postgres driver for database/sql

Xorm

gomock - GoMock is a mocking framework for the Go programming language.

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

go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package

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

sqlc - Generate type-safe code from SQL

beego orm

migrate - Database migrations. CLI and Golang library.

bun - SQL-first Golang ORM

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured