For small projects SQlite can also be a smart choice. As it has no database server, you will need PHP or Node.JS to access your data, but administration and backup is super easy.
If you need to deal with large scale time series data, there is no way around influxDB. Operations like aggregation or interpolation on the data are performed on the server and make this operations very fast.
Please mention other approaches like NoSQL, FlatFile and TSDB too. It is always good to know the strength and limitations of the different database types.
For small projects SQlite can also be a smart choice. As it has no database server, you will need PHP or Node.JS to access your data, but administration and backup is super easy.
If you need to deal with large scale time series data, there is no way around influxDB. Operations like aggregation or interpolation on the data are performed on the server and make this operations very fast.
Thank you for comment. I plan to write a few more articles about other sql databases.
Please mention other approaches like NoSQL, FlatFile and TSDB too. It is always good to know the strength and limitations of the different database types.
sqlite uses with applications - it is 'no install' db, only driver is used.