Why is no one recommending DETS or Mnesia instead of SQLite? Curious for educational reason.
Enuzo
dimitarvp
Because it’s much easier to query stuff with SQL. (D)ETS and Mnesia aren’t known for being easy to cover part of the data fetching, filtering and sorting scenarios.
3
D4no0
Some of my personal reasons:
- Unified language for querying that is very well specified and documented;
- Some well defined standards of how data is stored and how concurrency is handled;
- External tools for data inspection and migrations;
- Possibility to add any other random programming language to the mix;
- A extremely nice library for querying,data validation and migrations in elixir, AKA Ecto.
3
xoron
So if i will go with db approach(For MVP) i can also spin some worker process per company to handle client request which client send via websocket and Db will handle the data race problem if multiple request same resource.
0
dimitarvp
The DB will handle it, yes, but I also don’t think you need to spawn any processes yourself. Your app simply responds to requests, right? Though you also mentioned WebSockets so maybe it’s a two-way communication?
2
xoron
As every user communication is with websocket and websocket is process itself i can use it too. But i think its good to have centralize control for these things.
0
dimitarvp
xoron
I cant client is on mobile app and employee can be on mobile and web both. Thanks for help.
0
dimitarvp
