I am developing a web API with node.js for people to fetch the data insight.
on the admin side the administrator should be able to check the usage of each API, for example the statistic of how many visits of this API per hour/day , moreover the admin like to see the list and detail of API visit for each user, therefore in the design of this data API, certain log visit ( userid, request content ) should be insert into the database.
API function ( req, res ){
insertLog(req);
fetch(data);
}
now the question is if I design it myself, which db is more preferred, nosql db like mongodb could support the flexible schema and time series; OLAP like clickhouse could serve more column query; and there are also time-series db like influxdb.
additionally there are many works based on opentelemetry tracing, how this could support my purpose