Menu

#TimeStamp

38 posts

Feed·
20 of 38 posts
ID Format Comparison: UUID vs ULID vs NanoID vs KSUID vs Snowflake
📰
0Read More

ID Format Comparison: UUID vs ULID vs NanoID vs KSUID vs Snowflake

DEV Community: database·woofgl·5 days ago
#RZtPrxVh
#devtodatabase#devto#dev#uuid#bits

Table of Contents Why ID Format Is a Real Decision The Contenders at a Glance UUID: The...

15s
The same shipping event, twice, in two languages: a dedup rule we measured and did not ship
📰
0Read More

The same shipping event, twice, in two languages: a dedup rule we measured and did not ship

DEV Community: database·24hTrack·13 days ago
#GBrTFsew
#devtodatabase#devto#dev#event#carrier

If you store carrier scan events, you will eventually meet a timeline where every row appears twice:...

15s
0Read More

Paging through rows by updated_at can skip some, and I didnt realise why until a whiteboard chat with an engineer

Hey guys, not sure if this is useful to anyone but it surprised me so I thought I would share. If you have an updated_at column set to now() (or CURRENT_TIMESTAMP, or a time from your app) and you page through it to process changes, you can miss rows.…

15s
Our updated_at is maintained by the ORM, not the database, and 10 of 25 tables have one
📰
0Read More

Our updated_at is maintained by the ORM, not the database, and 10 of 25 tables have one

DEV Community: typescript·Daniel Pertu·27 days ago
#Rt7y9X9R
#devtotypescript#devto#dev#updated_at#count

created_at comes from Postgres and updated_at comes from Node, there are no triggers in the database, and the rule is not "any write to this row" but "any UPDATE this ORM built".…

15s
All 59 timestamp columns in our schema are without time zone, and the public API still appends a Z
📰
0Read More

All 59 timestamp columns in our schema are without time zone, and the public API still appends a Z

DEV Community: typescript·Daniel Pertu·27 days ago
#fPYtFqUu
#devtotypescript#devto#dev#date#timestamp

Drizzle's timestamp() is timestamp without time zone, postgres.js parses it with new Date(), and the only reason our dates are right is that Vercel runs UTC.

15s
UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate
🖼️
0Read More

UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate

DEV Community: postgres·Kiell Tampubolon·29 days ago
#CnIFQQYb
#devtopostgresql#devto#dev#time#uuidv7

UUIDv7 primary keys help database indexes, but the embedded timestamp is not a reliable clock. Four tests to run before migrating your PostgreSQL IDs.

15s
Timestamp attributes are now supported in Vercel Flags - Vercel
🖼️
0Read More

Timestamp attributes are now supported in Vercel Flags - Vercel

Vercel News·Vincent Derks·about 1 month ago
#LvyBWB3b
#vercel#time#timestamp#flags#attribute

Vercel Flags now support timestamp attributes for date-based rule evaluation. Enable flags between two dates, for account age, or other time-based conditions.

15s