One way to do it just storing json. So title field would contain {"en": "this is a title", "sv": "det här är en titel"}

So i'm trying to build a time tracker for reporting. How would I restrict so that a user can't have overlapping time entries? It's for tracking work so the same user can't work at double at the same time. Any constaints I can set in the DB to avoid possibility for overlapping entries from the same user?

Column constraint

Will this slow down the queries?

Yes this is one idea, figuring out best possible options.

not sure. We didnt have any complicated queries (just getting all articles etc). if you need to implement some kind of search function it might matter not sure

Okay, locales will keep on adding.. What you suggested will go with the current architecture I have. Lets see. If anyone has a better suggestion.

Is there any way I could check if a name exists in

name

column of my table? I'd like to throw an error if it does.

or will I have to do a 2 step process? check if exists then manually throw error?

Constraints are ur best friends

Or make the name also a primary id :)

Sorry I'm using SQL first time. Can you please explain? Let go in that thread above ^

Hi Does anyone already worked with triggers? I tried that but as you can see, I get an error and I don't really know why :/

Hi, new Supabase user here. I'm wondering whether it's possible to connect to Supabase database using the 'regular' postgres Python libraries /ORMs (i.e. where you normally need a host/port and username, password).

hello guys I saw in the supabase website that triggers are not yet "production ready". did some of you tried using it? and if so, is it okay to create triggers? because I really enjoy having them

Hello, I'm trying to use the local supabase but apparently

gen_random_uuid()

doesn't exist. How do I enable it? It works on the online, hosted supabase database. (UPDATE: fixed by dropping and creating the pgcryto extension)

Second question, are the default SQL schemas (initial, auth and storage) supposed to be ran automatically when self-hosting? Seems they are not, just checking.. (https://github.com/supabase/supabase/tree/master/docker/dockerfiles/postgres)

What is your postgresql version ? you need 13 for gen_random_uuid

Do I need to add userId column in SQL if I need to get a specific user's posts?

I'm not sure what that Foreign key relation is

Anyone know if it's possible to create a procedure that's only callable with the service role?

Creating a process only callable by the service role

Hi, what's your preferred GUI for inspecting Postgres or saving some queries etc? I've been using Beekeeper which is alright, but thinking there must be something nicer out there.

PopSQL works too.

But it has a pricing model, if you need additional features

Beekeeper is limited in features when compared to others on the market, TablePlus, DataGrip, ArchType and others. I'm more of a TablePlus person.

Guess we should have made a thread again, but thanks guys. TablePlus and PopSQL both look like improvements

user specific posts

Is it possible to get the connectionstring for the database?

Yes! Let me find it quick