TTC
Theo's Typesafe CultGetPsyched

Benefits of using auto incrementing primary keys?

Is there any benefit of using auto incrementing columns as primary keys in postgres when I have another column that is unique and can be used as a primary key?
N
Neto•18d ago
storage + speed to compare
N
Neto•18d ago
https://planetscale.com/blog/the-problem-with-using-a-uuid-primary-key-in-mysql
The problem with using a UUID primary key in MySQL — PlanetScale
Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.
G
GetPsyched•17d ago
So, an auto incrementing primary key uses less space and is hence faster to query?
N
Neto•17d ago
without going too deep into db archtecture yeah
G
GetPsyched•17d ago
Hm, makes sense.
Want results from more Discord servers?
Add your server
More Posts
Is Tanstack Query needed when using Next Route Handlers?Basically what it says. To my understanding a [Route Handler](https://nextjs.org/docs/app/building-yt3 env doesn't seem to work with docker compose buildI'm working to validate my application before pushing it to my CI/CD pipeline. I keep getting faileNextAuth - Email Provider Breaking Google Provider!Howdy, Some users of my app (app.getriver.io) started reporting not being able to log in to our appVSCode Import Autocomplete Purgatory (Relative, absolute, and barrel paths)I hope I'm missing some easy setting, otherwise this UI seems pretty terrible. Why does the autocompThe In App vs NextAuth problemIf you open the app link from a mobile app (like discord/telegram) and it opens in the in-app browseTypeErrorinitialTree is not iterable in Modern React Tutorial vidThe images map correctly until I try clicking on one, so I think the error may be misleading me. I T3 Roadmap? What would you recommend?I recently landed an internship, and they use the T3 Stack. I already had experience with JS, React,are there any better logs for nextJS that are in Englishjust spent 30min playing around with this and trying to work out the problem all I did was copy and Should I report a bug to a federal(-ish) university without hopes of a bug bounty?I live in nigeria, I attend national open university of nigeria. I recently found out a bug which alFork bombHi, i saw the new video from theo about the AI interview, and on the video he said to the AI to exeCommunication with server and client <nextjs>i have a webhook which calls nextjs api, can that api call do something which triggers an action onReact Native Data Loader libraryDoes anyone know of any good data loader libraries that will prevent waterfalls in React Native? I kNext.js as a client API choiceHaving watched all theo's videos regarding next and APIs (mainly tRPC and server actions), i got theShould I start my own blog, or use an existing platform?So I already have a few articles out on dev.to ( https://dev.to/noblica ) , and a few older ones on