Hey everyone. It's my first time using SQL so I'm wondering what kind of type I should use for a row id in a table. Should I just leave it at int8?

int8 is good for new applications, a lot of apps still uses int4 and works OK

I see, thank you!

Using incrementing keys has some problems (you can't generate a complete row outside the DB, and just looking at ids can tell users something about your scale), but it's simple and fast.

Yeah thats what concerned me at the start but users knowing the scale cant be that big of a deal right ?

another thing is: if users can guess ids of things, and you botch securing those things, then they might be able to access something they should not

I also have another question. I want to implement search based on location in my app. I know that I'm supposed to get location names from another database but how do I add it into supabase ? Is it hard ?

I haven't worked with geonames for years, but I'm sure there are examples. Can you try asking on the channel? This question might get lost if it stays in a thread.

Sure, thank you for your time

You can see the ranges of those key types (int8, int4) here https://www.postgresql.org/docs/current/datatype-numeric.html