Auto increment ID in JavaScript

Is there a way to get the last greatest ID in a table and then increment off of that for the next row of data?

say turn•12/4/22, 5:46 PM

SELECT * FROM Table ORDER BY ID DESC LIMIT 1

SELECT * FROM Table ORDER BY ID DESC LIMIT 1

You can convert this for the js functions

say turn•12/4/22, 5:49 PM

await supabase.from('table').select('id').order('id', {ascending: false}).limit(1)

await supabase.from('table').select('id').order('id', {ascending: false}).limit(1)

say turn•12/4/22, 5:51 PM

given that

{ascending: false}

{ascending: false}

means descending. @Mod

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:52 PM

getting this error:

{"code":"22P02","details":null,"hint":null,"message":"invalid input syntax for type bigint: \"[object Object]1\""}

{"code":"22P02","details":null,"hint":null,"message":"invalid input syntax for type bigint: \"[object Object]1\""}

code:

const lastID = await supabase
    .from('test')
    .select('id')
    .order('id', { ascending: false })
    .limit(1);

const { error } = await supabase
    .from('test')
    .insert({ id: lastID + 1, message: 'test' });

console.log(JSON.stringify(error));

const lastID = await supabase
    .from('test')
    .select('id')
    .order('id', { ascending: false })
    .limit(1);

const { error } = await supabase
    .from('test')
    .insert({ id: lastID + 1, message: 'test' });

console.log(JSON.stringify(error));

★★𝒄𝒍𝒂𝒊𝒓𝒆★getting this error: `{"code":"22P02","details":null,"hint":null,"message":"inval...

say turn•12/4/22, 5:53 PM

lastID seems to be an array

Ssay turn lastID seems to be an array

say turn•12/4/22, 5:53 PM

console log lastID and verify this

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:53 PM

oh yep, need to deconstruct it

garyaustin•12/4/22, 5:54 PM

Why would you be inserting the id, when it auto increments?

garyaustin•12/4/22, 5:55 PM

Reading a last value, then turning around and writing using it in another operation will also fail if there are multiple users.

Ggaryaustin Why would you be inserting the id, when it auto increments?

say turn•12/4/22, 5:55 PM

unless they have it specified as UUID or some other type that's not number, but they seem to be using big int so well yeah it won't make much sense

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:56 PM

no just a normal int that increments

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:56 PM

just messing around right now trying to get my bearings straight with supabase

garyaustin•12/4/22, 5:57 PM

Normally you use an identity column attribute (available in the table UI also) to set up an auto incrementing column on every insert.

say turn•12/4/22, 5:58 PM

Anyway, was I correct?

given that
{ascending: false}
{ascending: false}
means descending.

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:59 PM

im pretty sure i have that? my id column has the

Is Identity

Is Identity

box checked

garyaustin•12/4/22, 5:59 PM

Then you don't even provide it from the API call.

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 5:59 PM

ahh ok

garyaustin•12/4/22, 6:00 PM

It will always increment (note it can skip in weird cases on upserts, so you can't count on it going up just by 1, but it will always be bigger after each insert.

★★𝒄𝒍𝒂𝒊𝒓𝒆★ahh ok

say turn•12/4/22, 6:00 PM

you can have a default value to whatever column you want and you won't need to pass it through the api call. Like your

id

id

in this case.

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 6:02 PM

oh i think i just broke it lol, deleted all my rows and did an insert with just a

message

message

attribute and it started the count as 10

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 6:02 PM

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 6:02 PM

and before deleting i tried it out and it inserted as 9 so its remembering that

garyaustin•12/4/22, 6:02 PM

That is fine, it is a separate counter set when it is created.

garyaustin•12/4/22, 6:03 PM

It has nothing to do with the number of records.

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 6:03 PM

★

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•12/4/22, 6:03 PM

well thank you guys so much for the help

Ssay turn given that `{ascending: false}` means descending. @Mod

silentworks•12/4/22, 6:05 PM

You at Mods so is there someone breaking the rules or spamming a channel? If not please don’t ping the Mods because if everyone was to do this it wouldn’t be good for the server.

say turn•12/4/22, 6:07 PM

my bad, won't happen again.

const lastID = await supabase .from('test') .select('id') .order('id', { ascending: false }) .limit(1); const { error } = await supabase .from('test') .insert({ id: lastID + 1, message: 'test' }); console.log(JSON.stringify(error));

Auto increment ID in JavaScript

Similar Threads

Similar Threads

Similar Threads