I've got time-series data that I'd like to store in a database of the format:
- group : string
- date : date
- val1 : number
- val2 : number
- ... valN
This database will be almost all reads. The searches will be for rows that belong to a group that is within a date range (e.g. group = XXX and date >= START and date <= END).
The data-set is big. Hundreds of millions of rows. Will SQLite be able to easily handle this kind of data? The appealing thing about SQLite is that it is serverless and I'd like to use it if I can.
Aucun commentaire:
Enregistrer un commentaire