ReadMeFeed / Community knowledge

#indexing

Real questions. Useful conversations. Find the people who know your stack.

Question1 answer· Accepted0 comments0 followingPosted Apr 230 views0 votes

Are there any downsides to using nanoid for primary key?

I know that UUIDs and incrementing integers are often used for primary keys. I'm thinking of nanoids instead because those are URL friendly without being guessable / brute-force scrapeable (like incrementing integers). Would there be any reason not to use nanoids as primary keys in a database like Postgres? (For example: Maybe they drastically increase query

AI & Data

AI & Data

Question1 answer· Accepted1 comment0 followingPosted Feb 20 views0 votes

create index concurrently on partitioned table

I am using postgresql 14.1, and I re-created my live database using parititons for some tables. since i did that, i could create index when the server wasn't live, but when it's live i can only create the using concurrently but unfortunately when I try to create an index concurrently i get an error. running this: create index concurrently foo on foo_table(co

AI & Data

postgresql-14 indexing

postgresql

AI & Data

Question1 answer· Accepted3 comments0 followingPosted Jun 270 views0 votes

Understand Python swapping: why is a, b = b, a not always equivalent to b, a = a, b?

As we all know, the pythonic way to swap the values of two items a and b is a, b = b, a and it should be equivalent to b, a = a, b However, today when I was working on some code, I accidentally found that the following two swaps give different results: nums = [1, 2, 4, 3] i = 2 nums[i], nums[nums[i]-1] = nums[nums[i]-1], nums[i] print(nums) # [1, 2, 4, 3] nu

AI & Data

python list swap