SQL vs Elastic Search for storing CRM Data

twitter logo ・1 min read

Hey everyone,
First post here.I need some help choosing a cloud service to store CRM data for a website I'm building. At the least, I need user's to upload a csv of their customer emails (per group) and save that in a database. I'm very familiar with Firebase and I am using that for auth and RTDB, but I don't think it makes sense for storing the CRM emails and their group associations (ie - email and groupId).

I'm leaning towards AWS Elasticsearch or Google Postgres SQL. Any recco's?

Thanks.

twitter logo DISCUSS (2)
markdown guide
 

My guess is that Postgres would be better to start with.

Elasticsearch is awesome at natural language-ish searching, filtering, and aggregations on large amounts of data. However, unless your app has a strong need for one of those you'd probably get better value out of a relational database because they are so flexible, and I would guess the integrity and relational aspects will be much more useful for you.

I'd wager that most companies who run Elasticsearch also run a relational db, but the converse is not true.

 

I would store the data in PostgreSQL and then if PostgreSQL full text search is not good enough branch out to ElasticSearch.

Classic DEV Post from Jan 25

Letter to Myself Ten Years Ago

Inspired by the viral 10-year challenge on social media, when people show the world what they looked like 10 years ago, I decided not to share my photos of that time.

Will Trapp profile image
Self taught full stack dev