Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

How can I use int32? The maximum int is int8 which can store a max length of 8

Hello <@425318824137457664>!
This thread has been automatically created from your message in <#843999948717555735> a ``few seconds ago``.

Pinging <@&951828363943759883> so that they see this as well!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ... menu) and select **Leave Thread** to unsubscribe from future updates.

**Want to change the title?**
Use the `/title` command!

**We have solved your problem?**
Click the button below to archive it.

for timestamp with time zone, u can try: timestamptz

Yes I have seen this type but I have to store a date

I want to store timestamp like 1648301593

which has 10 length and I can't store it in max 8 length int

I tried to set the column to bigint but I get int8 again

what type can I use in order to have 10 length

bigint range: -9223372036854775808 to +9223372036854775807

My bad guys, I had set the value to string in golang

You should even be ok with int4, but it might not be sufficient in years to come as the range is -2147483648 to 2147483647

Yes int4 (for timestamp) has a maximum year 2038

If you have a choice I would suggest converting them to timestampz, this way you get the benefit of the tools the database provides when dealing with date comparison and so on.

I use it for my chat module, so it's easier to check according to device's unix timestamp value (eg. 2 mins ago)