Bean
Explore posts from serversTTCTheo's Typesafe Cult
•Created by Bean on 9/11/2023 in #questions
What kind of db/storage do I need?
I am trying to make an app but I am confuse by all the DB options and idk what is the best option for me.
I am making a public bus tracking app for a city. There is a public API I am able to use to get the current location of all the buses in the city. So, I wanted scape that API every few seconds and store that data so I can track the performance of the buses over time and see when they are usually late/full/early, etc.
the API returns the live GPS and the passenger count as well as some extra info.
I ran the scraper for a couple days and it looks like the raw json (without cleaning it up for formatting it correctly) results in about 1gb/week. I can easily bring that down to 800mb/week.
what do you think would be the best way to store, access this data?
I am currently planning on using pocketbase but I don't know if thats the best option.
5 replies