pg-xid
pg-xid is a globally unique id generator for postgres (by modfin)
SQLBoiler
Generate a Go ORM tailored to your database schema. (by volatiletech)
Our great sponsors
| pg-xid | SQLBoiler | |
|---|---|---|
| 2 | 42 | |
| 76 | 6,441 | |
| - | 1.8% | |
| 4.0 | 7.7 | |
| 10 days ago | 9 days ago | |
| Go | Go | |
| MIT License | BSD 3-clause "New" or "Revised" 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.
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.
pg-xid
Posts with mentions or reviews of pg-xid.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-09-28.
-
PostgreSQL reached maximum value of sequence (2147483627)
Or even xid https://github.com/modfin/pg-xid
-
Introducing pg_idkit: an extension for generating lexicographically sortable UUIDs (UUIDv6-8, CUID, Timeflake) in Postgres
If I only need/want xid, how this compares to https://github.com/modfin/pg-xid ?
SQLBoiler
Posts with mentions or reviews of SQLBoiler.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-01-18.
-
Go ORMs Compared
SQLBoiler takes a database-first approach, generating Go code from your database schema. This means it creates highly optimized and custom-tailored code for your specific database schema. SQLBoiler is great for applications where the database schema is well-defined and changes infrequently. However, like sqlc, it requires regenerating the code when the database schema changes. It's well-suited for projects where performance is a key concern and the database design is stable.
-
Comparing database/sql, GORM, sqlx, and sqlc
Moved all my projects to https://github.com/volatiletech/sqlboiler.
-
Are there any decent ORMs in Golang?
sqlboiler
-
Any mid sized / big open source code base in golang that makes use of SQL DBs?
My current ORM of choice is Bob [GitHub Link] which I created based on my experience using and maintaining SQLBoiler [GitHub Link].
-
GORM
You mean like ORMs? * sqlboiler: generates Go ORM using database schema.
-
ORM or no ORM (and which ones)?
SQL code generator (aka inspect a database or SQL files to generate data models). You have the option of using something like volatiletech/sqlboiler which looks at the a physical database and generates code based on the schema. Or SQLC which is an amazing and fast project.
-
Using Prisma Migrate with a Dockerized Postgres
After trying a half dozen migration engines for NodeJS, I was pleased to see Prisma and its excellent documentation. As a golang developer I am partial to SQLBoiler and its database-first approach, though perhaps this is a condition of our community where we want all the knobs. Prisma was code-first but still gave me enough control to feel confident.
-
Can anyone help me on how you are using golang with databases in production systems?
I use sqlboiler which generates an ORM from your database, and sql-migrate which is a tool for managing SQL migrations. Although you have to write your migrations in SQL, which IMHO is a plus.
- volatiletech/sqlboiler: Generate a Go ORM tailored to your database schema.
-
Go overtook Ruby and ranked #3 among the most used backend languages for pull requests since 2021
FWIW, the other posts point to https://gobuffalo.io/ and https://github.com/volatiletech/sqlboiler as possibilities.
What are some alternatives?
When comparing pg-xid and SQLBoiler you can also consider the following projects:
bytebase - The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.
GORM - The fantastic ORM library for Golang, aims to be developer friendly
sqlc - Generate type-safe code from SQL
ent - An entity framework for Go
sqlx - general purpose extensions to golang's database/sql
go-pg - Golang ORM with focus on PostgreSQL features and performance
upper.io/db - Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
jet - Type safe SQL builder with code generation and automatic query result data mapping
FrameworkBenchmarks - Source for the TechEmpower Framework Benchmarks project
xorm - xorm是一个简单而强大的Go语言ORM库，通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本，为xorm提供类似ibatis的配置文件及动态SQL支持，支持AcitveRecord操作
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
Xorm