BarMemes
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Awesome, thank you 🙏
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Yeah it looks really good. We’re abusing AWS for all their free startup credits at the moment and then may move to PlanetScale once they dry up. Kind of stuck if we stick with DynamoDB though…
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Why would you recommend MySQL on PlanetScale vs on other provider and why MySQL over MSSQL? Is it just licensing and hosting costs or is MySQL a better database for this use case?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
So what would you recommend as your ideal SQL and noSQL combo for a social network?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Great! That’s very reassuring. I’m picturing this nightmare scenario where we pick one architecture and then we’re stuck with it… 😅
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
I read that Discord recently moved from Cassandra to ScyllaDB, which I found interesting. They made a tonne of customisation though…
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Also, if we were going to use a graph database, which would you recommend? Neo4j, MemGraph, NebulaGraph, AllegroGraph, Redis, Cassandra with DataStax, AWS Neptune, GraphDb, ScyllaDB with JanusGraph etc
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Would would be fine starting off with an SQL database and then moving to a graph database as the app becomes more complex or are we better off starting out with a graph database. Would we be fine just using an SQL database with GraphQL?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
The plan is to have functionality like Discord, but also have a social “wall” like Instagram and run it over the Matrix.org protocol. Thanks for the video, I’ll check it out 😀
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
He also doesn’t see the point of graphQL if you setup the REST API’s properly. I just want to get a better understanding of what’s out there and avoid any big issues as we scale. My background is more in IT and cloud computing infrastructure.
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
I’m more involved with the UI/UX and concept of the app. My developer handles the code and he’s used DynamoDB before and he’s comfortable with it, plus he thinks it’ll be easier and cheaper to find additional developers for MSSQL and DynamoDB because they’re older and more established platforms.
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
We are starting out with MSSQL and DynamoDb with REST API. I just wanted to make sure that’s the best approach and we’re not going to run into issues. The app is being coded in Xamarin.
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
I got confused because @Own3r3k mentioned graph databases earlier and I got my posts mixed up.
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Apologies @keef @Sybatron is right, I meant to say GraphQL vs REST API.
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Thanks @OwenWexler. Why would you use a graph database instead of REST API or tRPC?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Thanks @VictorTimi, why would you choose Redis over DynamoDB?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
The noSQL would be mostly for “hot” data when synchronously chatting back an forth, when users need to read and write quickly. Did you have a preference on what type of SQL and noSQL database?
75 replies
TTCTheo's Typesafe Cult
•Created by BarMemes on 5/10/2023 in #questions
Best database for a social network if starting from scratch today?
Surely we need both though to handle excessive reads and writes to the database?
75 replies