adrfinance•4mo ago

adrfinance - Hello, which database doese Builds...

Hello, which database doese Buildship recommend using? I see you have your own, Firestore and Supabase??? Can you help me please?

5 Replies

Shams•4mo ago

if you dont have too many relationships in your data, i would recommend firestore, but if you have alot of relationship and complex queries any sql database is good, and supabase is the easiest

adrfinance•4mo ago

Thanks @Shams I couldn't get Supabase to work yesterday for some reason (I could SELECT but I could not update) so I am giving the built in Database a try now.

cleverbit•4mo ago

Hey @adrfinance curious what you're building that involves update? Sounds interesting, but don't mean to pry. Would you mind sharing?

adrfinance•4mo ago

@cleverbit well, let's say you have some user information that you want to edit through a UI and save the changes to the database, how would you do it?

cleverbit•4mo ago

Oh of course, yeah sorry I misread your message! FWIW I've got Supabase working with Get, Update and Create. Something that was non-obvious (just failing silently) was that for an Update if you are passing multiple objects, all the keys need to match. So if you send: [ {"title":"Hello"}, {"description": "ok"}] That will fail, because the keys of the 2 objects don't match. You have to send:

[
    {"title":"Hello", "description":""},
    {"title":"", "description":"ok"}
}

[
    {"title":"Hello", "description":""},
    {"title":"", "description":"ok"}
}

Hope that helps?