Sure thing. I tend to use Postgres for everything unless there is a really strong argument for not using postgres. CRM data should be stored in postgress unless you expect billions of rows. Next you'll want to replicate some of that data to Elastic for awesome search. If the search only kinda needs to work you could also consider the built-in fulltext search of postgres, its pretty decent actually.
Managed postgres is nice since tuning PG, and setting up WAL replication (check out wal-e, github.com/wal-e/wal-e) takes quite a bit of work. We did this in-house at my first startup, and while it worked it took up way to much time to justify the cost savings. Gitlab is a nice example of running it yourself gone wrong. They wrote an awesome transparent blogpost about it though. about.gitlab.com/2017/02/10/postmo...
I've used RDS in the past, never used the google one, how do you like it so far?
Man, amazing answer. Can’t tell you how much I appreciate the help. I’m self taught (going on year 3) and never really had anyone to bounce ideas off. Dev.to just became my favorite place :) Postgres it is! ... I’m a huge fan of Google Firebase real time database. I learned backend processes, data structure, and authentication through it which gave me so much confidence when I started out. Now I can setup something so quick using it, I use it a ton at work mainly for internal projects. It’s a great product with great developer advocates and great docs ... thanks again !
Can you help answer my latest post:) dev.to/trappology/sql-vs-elastic-s...
Sure thing. I tend to use Postgres for everything unless there is a really strong argument for not using postgres. CRM data should be stored in postgress unless you expect billions of rows. Next you'll want to replicate some of that data to Elastic for awesome search. If the search only kinda needs to work you could also consider the built-in fulltext search of postgres, its pretty decent actually.
Managed postgres is nice since tuning PG, and setting up WAL replication (check out wal-e, github.com/wal-e/wal-e) takes quite a bit of work. We did this in-house at my first startup, and while it worked it took up way to much time to justify the cost savings. Gitlab is a nice example of running it yourself gone wrong. They wrote an awesome transparent blogpost about it though. about.gitlab.com/2017/02/10/postmo...
I've used RDS in the past, never used the google one, how do you like it so far?
Man, amazing answer. Can’t tell you how much I appreciate the help. I’m self taught (going on year 3) and never really had anyone to bounce ideas off. Dev.to just became my favorite place :) Postgres it is! ... I’m a huge fan of Google Firebase real time database. I learned backend processes, data structure, and authentication through it which gave me so much confidence when I started out. Now I can setup something so quick using it, I use it a ton at work mainly for internal projects. It’s a great product with great developer advocates and great docs ... thanks again !
Firebase is pretty cool, it's also price super competitively because Google knows you end up buying more stuff from them