Michele Riva

@mrloldev Kinky

@MicheleRivaCode we dominate

viva españa!

@xeraa Real 😂

@MicheleRivaCode nice! my secret influence on your projects :D

A star would be highly appreciated - lost 10.5k of them github.com/micheleriva/zb…

@nicolasrouanne Got kicked out the github org after I left my own company, now project is unmaintained/sloppy github.com/oramasearch/or…

@MicheleRivaCode How so?

@xeraa You were right 😂

@MicheleRivaCode wait. I said that? :D x.com/xeraa/status/2…

@TejasKumar_ @manuelnavid Follow me my friend goodreads.com/user/show/1844…

@manuelnavid no one i know uses this

hear me out: strava but for books

@MohitKarekar @leerob 😍

@leerob @MicheleRivaCode ✨

She’s found the ancient scrolls.

@AbhiCodes15 no?

unpopular opinion: vibe coding is actually hard work too

@brandonkpbailey the tweet I quoted uses "users" as domain example, but it could be anything

@MicheleRivaCode I meant to say production users. Not really sure how i goofed that up

Real interview question is how to move away from design A before you run out of integers. Serial4 exhausts at ~2.1B, moving a pk to uuid means regenerating an index and if you don't know how to index stuff correctly you’ll blow the db. Also you cannot backfill with a migration - you’ll blow the db again. Even when you backfill, how do you ensure non-nullish values without running an unique query? Mid-level eng question imho

@rackSpreader1 yes if you're a techbro no if you're a normal guy

Is sf dating scene relly that bad

@brandonkpbailey literally done that 1 month ago

@MicheleRivaCode Are the 2.1B productions in the room with us?

@c4_cauliflower Yes. Index using `CREATE INDEX CONCURRENTLY` to avoid surprises. Next question is, how do you enforce foreign keys are not screwed up?

@MicheleRivaCode Before switching off of the integer pk, add a new optional column for the UUIDs, fill it for all new entries and use a script to backfill the old entries at whatever rate you can get away with. Once the old entries are all backfilled, switch to using the new column.

ZBSearch works on @Cloudflare workers - scales as much as R2 does (a lot)

@aileenvl @leerob 🫪

@leerob @MicheleRivaCode mentioned

@netspencer @leerob What!!! 🔥🔥🔥

@leerob shoutout @MicheleRivaCode

Ayo I wrote this

@Elindalyne Maybe it's a multitenant db

@MicheleRivaCode if you have 2 billion users you can afford to hire someone to figure it out...

@SQLGene 😂

@MicheleRivaCode Real ones know to switch over to negative ints

@theharshpat First of all check the postgres version 'cause it's not supported <18 Then why v7 over v4? If time is the reason, wouldn't a timestamp column work just fine?

@MicheleRivaCode How do you move away from uuidv4 mess to uuidv7? 1TB database btw. Painful af