Hello everyone I would like to know which database you prefer for chat applications? I do not know if traditional databases are preferable or maybe there is some other option that works well with Elixir / Phoenix? I would appreciate it if you can share your experience. In this case it will be a …

I would try scylla [0] for storing messages, postgres for storing user metadata (might replace with cockroach [1] for lolavailability, it’s definitely production ready, hit 1.0 a few weeks ago), elasticsearch for, well, searching through all those messages and users, prometheus 2.0-alpha [2] for c…

How much traffic do you expect on it? I would keep it simple and stick to Postgres. It plays well with Ecto, widely used in the industry, better tooling, easy to setup, etc.

I’m sorry for answering your question with somewhat of a non-answer, but it has to be mentioned: A Little Architecture by ‘Uncle Bob’ .

[image] idi527: scylla [0] for storing messages, postgres for storing user metadata (might replace with cockroach [1] for lolavailability (it’s definitely production ready (hit 1.0 a few weeks ago))), elasticsearch for, well, searching through all those messages and users, prometheus 2.0-alpha …

One example: Postgres full-text search is Good Enough!

Sure, it’s just that master-master story in postgres is still far from perfect, although postgres can make it far without any need to scale/replicate, but then (in case the chat app is international) I would want to spin up a database server on each continent in an attempt to reduce latency, and tha…

PostgreSQL has some pretty great libraries now for such replication, two main styles too (one replicates the raw data, always perfect consistency, the other replicates commands, much less bandwidth).

[image] idi527: …(in case the chat app is international) I would want to spin up a database server on each continent in an attempt to reduce latency, and that would make postgres a bit harder to operate. I feel this is a rare problem to have and once you do have it, you’ll have the resources …

I feel like everyone here has forgotten that Whatsapp uses only Mnesia (or at least used too, I’m not sure about anything after 2014).

Elixir Programming Language Forum

Best DB for chat

Questions & Help Questions

WolfDan May 31, 2017, 4:01pm 6

Any example for advances searchings with postgre? I’m interested :o