sergeyprokhoren

5 ms·

1.
by sergeyprokhoren 11mo ago
The PostgreSQL uuidv7() developers are leaning toward a different approach to solving timestamp leaks, similar to FHSS ( https://en.wikipedia.org/wiki/Frequency-hopping_spread_spect... ). This is currently possible manua
2.
by sergeyprokhoren 1y ago
PostgreSQL Gains a Built-in UUIDv7 Generation Function for Primary Keys (many interesting details) https://habr.com/en/news/950340/
3.
PostgreSQL Gains a Built-In UUIDv7 Generation Function for Primary Keys(habr.com)
2 points by sergeyprokhoren 1y ago|0 comments
4.
by sergeyprokhoren 1y ago
Offsetting the timestamp is much better. Use the uuidv7(INTERVAL shift) function in PostgreSQL 18 https://www.postgresql.org/docs/18/functions-uuid.html in Percona Server for MySQL: https://docs.percona
5.
by sergeyprokhoren 1y ago
95% of the comments here have nothing to do with reality. What May Surprise You About UUIDv7 https://medium.com/@sergeyprokhorenko777/what-may-surprise-y...
6.
by sergeyprokhoren 1y ago
If you shift the timestamp forward by 5 thousand years, it can hardly be called just a decrease in precision.
7.
by sergeyprokhoren 1y ago
Bad idea. In PostgreSQL 18 the optional parameter shift will shift the computed timestamp by the given interval https://www.postgresql.org/docs/18/functions-uuid.html
8.
by sergeyprokhoren 1y ago
https://biggo.com/news/202509050143_6NF_File_Format_Debate
9.
by sergeyprokhoren 1y ago
What does looks "old school" mean? Do you want to wrap this format in JSON like JSON-LD? I don't mind
10.
by sergeyprokhoren 1y ago
See "DSL for Bitemporal Sixth Normal Form with UUIDv7" https://github.com/sergeyprokhorenko/6NF_DSL
11.
What May Surprise You About UUIDv7(medium.com)
6 points by sergeyprokhoren 1y ago|0 comments
12.
DSL for Bitemporal Sixth Normal Form with UUIDv7(github.com)
4 points by sergeyprokhoren 1y ago|0 comments
13.
by sergeyprokhoren 1y ago
This is a fairly common problem. Data is often transferred between information systems in denormalized form (tables with hundreds of columns - attributes). In the data warehouse, they are normalized (data duplication in tables is excluded b
14.
6NF File Format(habr.com)
76 points by sergeyprokhoren 1y ago|27 comments