adrfinance
adrfinance5mo 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
Shams5mo 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
adrfinance5mo 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
cleverbit5mo ago
Hey @adrfinance curious what you're building that involves update? Sounds interesting, but don't mean to pry. Would you mind sharing?
adrfinance
adrfinance5mo 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
cleverbit5mo 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?