News for hackers. Stuff that matters.

r0ckysharma

Ask HN: Suitable database to store and manage Growing Likes and Reactions

Hi Hackers,I am seeking an experience-based comment on effectively storing thousands of likes and reactions that occur every second in a database. What database have you chosen, and if possible, answer why as well, along with schema/format!We are currently using a custom key-value Go-based database, but now it's getting messy with growing numbers and is complex to manage.How do apps like...

( Read More... | no comments | 2 points | on HN )
1. 80,000 - 125,000 ( on peak per minute ) - expecting 5-6 times in increase in coming few months.

2. Size of each insert ( approx 1 KB )

3. Year end datasize = Not available ( too early to guess, but average 600-700 GB )

4. Query must finish in around a minute or around.

Ask HN: Suitable database to store web analytics data for million insertion

Hi Hackers,I am looking for an experience-based comment for cost-effectively storing millions of web analytics data in a database. What database have you chosen, and if possible, answer why as well!I have a few timeseries databases in mind, but apart from that - if anyone else has some other solution which has worked them in a highly cost-effective way for extremely high insertion and low read,...

( Read More... | 10 comments | on HN )
Re:Show HN: Camome UI – A lightweight React and CSS framework on Thursday February 16, 2023 @07:44AM (#34817959)
This looks clean and nice. Well done there.
It's time to move to Rust or Nim or Crystal?

telemetry is definitely not a solution half of the industry would be happy about. It's polite way of saying - I want to know what you are doing!