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

Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New
beno
I will often find my self writing things similar to: case some_value do nil -> something() "" -> something() _ -> somethi...
New
tduccuong
Hi, is there any work on GUI with Elixir, that is similar to Electron/Javascript? My idea is to bundle Phoenix and BEAM into a single se...
New
Lily
In templates/appointment/index.html.eex: <%= for appointment <- @appointments do %> <tr> <td><%= appoi...
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
script
If I have a string “1000 cfu/ml” . I want to remove the characters and / and space . So the string is like this "1000" What is the ...
New
rms.mrcs
Hi, I need to transform a list of numbers into a map where the keys are the indexes and the values are the original values of the list. ...
New
dotdotdotPaul
Okay, I’m having a heck of a time trying to figure out how to best handle the validation of belongs_to associations in Ecto. I’m sure I’...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New
lanycrost
Hi everyone! I need implement if…else if…else condition from my elixir code, and anymore of this control flow structures not work proper...
New

Other popular topics Top

danschultzer
None of the current solutions worked well for me, so I went ahead and built a user management system from scratch. This project took far...
548 29603 241
New
WestKeys
Currently suffering from paralysis by [HTTP client] analysis. This is rather unusual in Elixirland as there tends to be consensus on the ...
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
fireproofsocks
Forgive me if this is obvious, but how does one delete a database record WITHOUT selecting it first? Ecto.Repo — Ecto v3.14.0 has exampl...
New
jay1
Why is it that the mnesia database isn’t the most preferred database for use in Elixir/Phoenix?
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
alice
Hey, Just curious what are the main benefits of Elixir compared to Clojure? When is Elixir more useful than Clojure and vice versa? Th...
New
jaysoifer
Is there a way to rollback a specific migration and only that one (“skipping” all the other ones)? Would mix ecto.rollback -v 200809061...
New
dogweather
I wrote this comment on r/haskell, and it’s not popular there. :wink: But I think I’m on to something… Haskell reminds me of Java, and e...
New
jononomo
For some reason my phoenix channels are working for me in my local dev environment, but as soon as I deploy via Docker, I get a 403 error...
New

Latest on Elixir Forum

Elixir Forum

We're in Beta

About us Mission Statement