News for hackers. Stuff that matters.
Re:An open-source alternative to Mixpanel by KaoruAoiShiho on Wednesday May 22, 2024 @11:44AM (#40442364)
Do you have a way to automatically prune old data? I ran into the problem with posthog where the old data just overflowed my db and made it inoperable and they had no way to prune it.
Re:An open-source alternative to Mixpanel by lindesvard on Wednesday May 22, 2024 @04:05PM (#40445709)
Hmm seems odd? Currently I have none but will probably add a TTL to clickhouse on 5 years.

And if you really need to prune data you could just use good ol SQL?

Re:An open-source alternative to Mixpanel by XCSme on Wednesday May 22, 2024 @08:43PM (#40448948)
For my platform, I created some cron-jobs that run an SQL that deletes data older than X months.