SaaSHub helps you find the best software and product alternatives Learn more →
Pg_idkit Alternatives
Similar projects and alternatives to pg_idkit based on common topics and language
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
pgx
Discontinued Build Postgres Extensions with Rust! [Moved to: https://github.com/tcdi/pgrx] (by tcdi)
-
neon
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
-
sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
pg_idkit reviews and mentions
-
Show HN: pg_idkit, a Postgres extension for generating exotic UUIDs
Hey HN,
It turns out choosing a good database-optimized UUID (and deciding whether to use serial, etc) isn't quite so simple, and I finally got a chance to do some exploration, write about it[0].
One of the reasons Postgres is the best open source database out there is it's extensibility -- so I hacked up a small extension for generating some of the more exotic (but crucially, lexicograhically sortable) UUID generation mechanisms:
https://github.com/t3hmrman/pg_idkit
This idea has been bumbling around my head for a while, but I finally got a chance to build it while working with Supabase on a post about IDs[0]!
Most of the heavy lifting is done by pgx[1] which is an amazing framework for building Postgres extensions in Rust. I think we are very early to the trend of amazing postgres extensions built in Rust, and it's yet another reason that it's an exciting time to be all-in on Postgres.
[0]: https://supabase.com/blog/choosing-a-postgres-primary-key
[1]: https://github.com/tcdi/pgx
[0]: https://supabase.com/blog/choosing-a-postgres-primary-key
-
pgx is awesome: introducing pg_idkit
Using pgx made it dead simple for me to write pg_idkit which is an extension that makes some more exotic UUID generation strategies (Timeflake, CUID, UUIDv6-8, etc) available to Postgres instances. It's still a WIP but I don't think I would have been able to get started so quickly without it (and the DX is awesome).
-
Choosing a Postgres Primary Key
This article comes with a complementary postgres extension which we wrote to benchmark various UUIDs: https://github.com/t3hmrman/pg_idkit
In case you don't read the article, my favourite idea is using the `ksuid` type as both an ID and a *created_at* field:
> One interesting feature would be using at least partially time-based UUIDs for created_at columns -- we could save space by virtualizing our created_at columns:
CREATE TABLE users (
-
A note from our sponsor - SaaSHub
www.saashub.com | 6 May 2024
Stats
The primary programming language of pg_idkit is Rust.
Popular Comparisons
Sponsored