ericdouglas

ericdouglas

Resources to learn about databases, data modeling and how to choose the right one

Hey, friends!

TL;DR

Please, help me doing a mental dump with all resources you know about the topic’s title. :pray:
Many thanks!


Recently, I have been dedicating a lot of time on the server side with Elixir. It has been a great adventure so far! I’m really pleasured with the language and the mental model Erlang brought to us.

Disclaimer: I know the question is “off-topic”, but I don’t know other places to ask. If you know, tell me as well! All my professional experience is as a JavaScript Developer but I decided to focus more and dive on the server side with Elixir.

One thing I’m facing real difficulties is how to separate the signal/noise in the database land. I mean, how to find good resources and how to find resources that will give me the capability to decide which approach is the most indicated to implement my applications in the scenario I have (in the data/persistence context).

I really, really like the minimalistic mindset, and I want to keep the systems I’m developing as minimal as possible, and one great thing I saw in the combo Elixir/Erlang is the capability “to do a lot with little”, including several solutions in the data layer.

So what I really want is: please, help me suggesting good resources that will give me the ability to answer the following questions, all in the data context:

  • What is the best approach for that application?
  • What is the minimal (good enough) approach?
  • How to model data/database in the X database?
  • What are the limitations to be aware of following the chosen approach?
  • How to manage Z database?

I think you got the idea. I can’t remember more questions right now, but I want to develop I real expertise in that matter since it’s a subject I’m really interested.

So please, do a mental dump here with all resources you have/know about this topic, it’ll be a huge help for me and for others that probably are facing/will face the same challenge.

Many thanks! :smile:

Where Next?

Popular in Questions Top

minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
skosch
To my knowledge, put_in, Map.update etc. all have the one limitation of not automatically creating intermediate keys when needed (for exa...
New
ashish173
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
belgoros
I’m not a pro in using Regex and can’t figure out why the following behaviour happens, especially if we take into account the difference ...
New
freewebwithme
Using vs code and installed ElixirLS: support and debugger. And I got an error popped up on start up says Failed to run ‘elixir’ comma...
New
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID<0.412.0> terminating ** (Postgrex.Error) FATAL...
New

Other popular topics Top

minhajuddin
I have seen a lot of code which picks the first element from a list using Enum.at(0) instead of List.first. Is there a reason why people ...
New
baxterw3b
Hi guys, i’m new in the Elixir world, and i have to say, that i love it! i’m having some problem to understand anonymous functions with ...
New
Qqwy
Original source of discussion: This topic on the Pragmatic Programmers’ Functional Web Development with Elixir, OTP, and Phoenix forum. ...
New
chrismccord
Phoenix 1.4.0 released Phoenix 1.4 is out! This release ships with exciting new features, most notably with HTTP2 support, improved deve...
688 31494 112
New
gausby
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
1207 40042 209
New
sergio
Kind of like when jquery came out, it was super necessary. Existing drag and drop libraries have a bunch of baggage to support old browse...
New

We're in Beta

About us Mission Statement