home.social
Sign in Create account

#autoincrement — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #autoincrement, aggregated by home.social.

  1. Vint Prox @[email protected] ·

    UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

    youtube.com/watch?v=JbdvmQ_HgJo

    #UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

    #uuid #uuidv7 #uuid7 #uuidv4 #uuid4 #autoincrement
  2. Vint Prox @[email protected] ·

    UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

    youtube.com/watch?v=JbdvmQ_HgJo

    #UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

    #uuid #uuidv7 #uuid7 #uuidv4 #uuid4 #autoincrement
  3. Vint Prox @[email protected] ·

    UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

    youtube.com/watch?v=JbdvmQ_HgJo

    #UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

    #uuid #uuidv7 #uuid7 #uuidv4 #uuid4 #autoincrement
  4. Vint Prox @[email protected] ·

    UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

    youtube.com/watch?v=JbdvmQ_HgJo

    #UUID #UUIDv7 #UUID7 #UUIDv4 #UUID4 #AutoIncrement #ID #database #databases

    #databases #database #id #autoincrement #uuid4 #uuidv4
  5. Vint Prox @vintprox ·

    UUIDv7 takes the best of two worlds for distributed systems: auto-incrementing ID and UUIDv4. It keeps page splits and fragmentation out of primary key index, while also maintaining cryptographically secure randomness to prevent insecure direct object reference. (This obsoletes UUIDv4, which only tends to bloat every index and cost more with each write operation.)

    youtube.com/watch?v=JbdvmQ_HgJo

    #uuid #uuidv7 #uuid7 #uuidv4 #uuid4 #autoincrement
  6. PrecisionSQL @[email protected] ·

    How to Stop AUTO_INCREMENT From Reusing After Restart

    Recycled IDs can break your caching.

    #mysql #autoincrement #reuse #howto #ids #gotcha

    youtube.com/watch?v=AMm1JExqDbU

    #mysql #autoincrement #reuse #howto #ids #gotcha
  7. PrecisionSQL @[email protected] ·

    How to Stop AUTO_INCREMENT Gaps From Breaking IDs

    Rollbacks still consume auto increment values.

    #mysql #autoincrement #ids #howto #transactions #gotcha

    youtube.com/watch?v=sGsPlUnRt_s

    #mysql #autoincrement #ids #howto #transactions #gotcha
  8. PrecisionSQL @[email protected] ·

    Auto-Increment IDs Have GAPS Forever?!

    IDs are BROKEN! Failed INSERT consumes the auto-increment ID! User #1, skip #2, User #3! Your IDs have permanent GAPS! This breaks ID-based logic! Watch this chaos!

    #sql #sqlbug #autoincrement #primarykey #idgaps #failedinsert #sqlfails #productionbug #sqlshorts #sqlwtf #identitycolumn #dataintegrity

    youtube.com/watch?v=qF3obGJL_MY

    #sql #sqlbug #autoincrement #primarykey #idgaps #failedinsert