How would I move a structure like this over to sup...
# helps
Sasial
04/30/2022, 9:33 AMHow would I move a structure like this over to supabase?
n
Needle
04/30/2022, 9:33 AMHello @Sasial!
This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``.
Pinging @User 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
/titleg
garyaustin
04/30/2022, 2:04 PMIt looks like will probably have at least a categories table, a questions table possible with foreign key to category, and a currentTickets table.
But other than that, not really enough info to understand your relationships, what guild, channel and messages are, why some tickets have guild and others have message, where 0's are does that mean there will be more than 1 (assumed), etc.
n
Needle
04/30/2022, 2:04 PMSasial (2022-04-30)
s
Sasial
04/30/2022, 9:48 PMso i can't have nested structures, I have to use more tables?
Sasial
04/30/2022, 9:49 PMthis is FB's stupid UI, 0's are the first item in an array
Sasial
04/30/2022, 9:49 PMso yes
Sasial
04/30/2022, 9:49 PMmessage is a temp field, which'll change to guild
g
garyaustin
04/30/2022, 9:52 PMYou can do json columns as deep as you want or array columns of json objects, but it gets harder to search and maintain. Relational data bases are designed for lots of smaller tables all interconnected by keys, references or just how you set up you queries.
s
Sasial
04/30/2022, 9:54 PMare there any docs for migrating from firestore?
g
garyaustin
04/30/2022, 9:58 PMI've not seen any, but I'm sure you could google. Remember you are not just looking for firestore to supabase, but to Postgres which should get more hits.
I like this reference in PostgREST (which Supabase uses for its API) as it relates fairly clearly ways you can relate tables. You are not at the point though you need to really worry about relations between tables versus how to breakdown your structure into tables. Normally you look at structures that are common, like messages, users, tickets, categories, etc.
garyaustin
04/30/2022, 10:00 PMI moved from firebase, mainly because I was spending all my time fighting query cost and organizing data to minimize that, versus just organize the data so it makes sense then just worry about minimizing how much you download, versus how many calls you make to do it.
s
Sasial
04/30/2022, 10:00 PMYeah for sure!
Sasial
04/30/2022, 10:06 PMJSON colums wouldn't be typed though, right?
g
garyaustin
04/30/2022, 10:17 PMtechnical for json and jsonb in postgres https://www.postgresql.org/docs/current/datatype-json.html
garyaustin
04/30/2022, 10:17 PMIf by typed you mean numeric/boolean/string then yes that is supported
s
Sasial
04/30/2022, 10:24 PMohhh, okay
g
garyaustin
04/30/2022, 10:29 PMI'm not suggesting you use json columns for what you have, just saying if you need very flexible data formats json is supported reasonable well. That is usually the big issue if someone took full advantage of a no sql database without any fixed structure on their objects. I have a note taking app where each note type can have different information and some of the information may or may not be filled in so use a json column for that. I then pull out a few key items into separate columns for searching faster and displaying in lists. But I can also do a full search on the json, just slower.