In which database is it better to store a large number of simple values?

Question

Database

The bottom line is - there is an application for recording a GPS track. I would like to optimize the storage of tracks on the server. In fact, this is simple disconnected data (coordinates, speed, time). It is necessary to quickly give a large number of points to the user, as well as to save them in the process of work and sometimes request a small amount if necessary. I'm thinking of using Redis (at the moment I have Postgres and there are some issues there, although maybe if I change the implementation almost all the issues go away). I'm thinking about scaling in the future and I'm not sure if it's better to store in Postgres, as there can be a lot of rows in the future compared to other tables. If you have experience with similar tasks, I will be glad if you share. Thank you!

Answer 1

You need a database for time series (timeseries database). For example, install the timescaledb plugin on your postgresql . Or look at something like InfluxDb

Answer 2

sqlite