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.
4 Replies
Just rent a virtual server and put postgres on it.
Is there a reason for using postgress instead of other options?
It's the one of the most performat databases when you work with lots of data and complex queries, also with Postgires you can add PostGIS extension to store GPS data. But if you prefer something like MySQL or MariaDB, you can use them as well, they are all good
Good to know