Re:Umami: Self-hosted open-source alternative to Google Anal...
by anaganisk on Wednesday August 19, 2020 @01:53AM
(#24207549)
Tho very rare, why would you use a database that is at risk to be erased completely, and with a limited set of queries as the main DB? Honest question.
[ Parent
| on HN ]
Re:Umami: Self-hosted open-source alternative to Google Anal...
by imedadel on Wednesday August 19, 2020 @04:53AM
(#24208466)
My concern was the performance of Postgres when it's receiving thousands of writes per second. I assumed that such a task would be more suited for Redis, then the data could be filtered and sent to Postgres for longer storage (or some storage solution such as S3).
Re:Umami: Self-hosted open-source alternative to Google Anal...
by ponyous on Wednesday August 19, 2020 @05:02AM
(#24208507)
I think bigger issues would be time related queries when dataset gets bigger as opposed to write speeds.
I think a time series database is best suited for this kind of project (timescale build on top of postgres, influxdb, ...)