js-id
tbls
Our great sponsors
js-id | tbls | |
---|---|---|
3 | 6 | |
10 | 3,057 | |
- | - | |
5.9 | 8.9 | |
8 months ago | 7 days ago | |
TypeScript | Go | |
Apache License 2.0 | MIT License |
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.
js-id
-
Type-safe, K-sortable, globally unique identifier inspired by Stripe IDs
We have a uuidv7 implementation that we've been using with rocksdb for over a year https://github.com/matrixai/js-id
-
Plan B for UUIDs: double AES-128
We evaluated ULID but we wanted something that is future proof for our decentralised secret sharing system. So we implemented UUIDv7 in TypeScript called `IdSortable` https://github.com/MatrixAI/js-id
It allows strict monotonic IDs when you provide it the previously generated ID. The resulting data structure is a Uint8Array making it easy to put into binary structures. Can also be used as a key inside any POJO record.
-
Lesser Known PostgreSQL Features
I had reviewed existing UUIDv7 implementations and many were incorrect or had subtle timing bugs.
We ended up implementing UUIDv7 in our ID generation library https://github.com/MatrixAI/js-id. And we have a number of tests ensuring that it is truly monotonic even across process restarts.
See IdSortable.
tbls
- FLaNK 25 December 2023
- tbls
- Tools to use to make high level Architecture diagrams
-
Graphviz: Open-source graph visualization software
Autogenerated database documentation is often pretty hit and miss but tbls[1] does a pretty good job in that space. Especially when you comment on your tables, fields, views, functions etc (which is a good habit anyway!) the output is quite useful
[1] https://github.com/k1LoW/tbls
-
Lesser Known PostgreSQL Features
In-database comments combined with something like https://github.com/k1LoW/tbls make for very cheap database documentation.
No affiliation with tbls except that I'm a big fan
-
Recommendations for a CLI-tool to generate DB diagrams?
Check out tbls. You can create a ERD in one command
What are some alternatives?
ksuid - K-Sortable Globally Unique IDs
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
typeid - Type-safe, K-sortable, globally unique identifier inspired by Stripe IDs
typeid-go - Go implementation of TypeIDs: type-safe, K-sortable, and globally unique identifiers inspired by Stripe IDs
prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client
resource-id - Developer-friendly k-sortable IDs
pg-ulid - ULID Functions for PostgreSQL
postgres-elasticsearch-fdw - Postgres to Elastic Search Foreign Data Wrapper
plantuml-syntax - vim syntax file for plantuml
afid
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown