Ask HN: Should I use time-series DB for real-time chat app?

Posted by tiffanyh on Monday February 28, 2022 @12:27PM
from the ask-hn dept.

I’m working on a side project (Slack clone) and am not certain if using a time-series database is appropriate for a chat based app.

Even though messages are chronological in order (time based), people might want to start a new thread on a previous message that isn’t the most current message. So the hierarchy isn’t just the time a message was sent, but it’s also based on the message that it’s being responded too as well.

As such, I’m not certain if using a time series database is the appropriate use for a chat app.

EDIT:

Question - What do you believe is the most appropriate data-store to use and why?

(Eg relational, nosql, document, time-series, etc)

( 2 comments | 2 points | on HN )

Re:Ask HN: Should I use time-series DB for real-time chat app? by sakethr98 on Monday February 28, 2022 @12:34PM (#30502507)

tbh, databases of any kind could be used to make a chat application if your query structures are well setup etc.,.

But the feature you are mentioning like having threads could be easily be solved using like a document store ex; mongodb or any other no-sql db that could help you save time in both setting up things and querying.

Just my 10 cents.

[ Parent | on HN ]

Re:Ask HN: Should I use time-series DB for real-time chat app? by tiffanyh on Monday February 28, 2022 @12:40PM (#30502587)

Thanks for reply.

What do you believe is the most appropriate data-store to use and why?

(Eg relational, nosql, document, time-series, etc)

[ Parent | on HN ]