4
5 Comments

What (free) Database solution do you use for your CRM?

Hello everyone,
I would like to setup a custom CRM to manage all the contacts (emails) that we have acquired over time and then use a custom tool (Nodemailer) for email campaigns.
What do you use to store contacts (possibly free)?

I was thinking about a mySql database hosted on a Digital Ocean instance, but I was wondering if there were simpler solutions.
I checked out solutions like Airtable, but the limit on the number of records would be a problem for us (same as for Mailchimp and co).

Thanks

on June 6, 2019
  1. 1

    I thinking of writing a CRM for my next project. what features would you suggest the mvp has?

    1. 1
      • simple API to read/write
      • unlimited storage (if self-hosted, otherwise with quotas based on storage and/or api calls)
      • relational
      • SQL-like query syntax

      these would be the base minimum for me

  2. 1

    Hah, just closed out an Airtable tab before I came to this. What about Firebase? Having JSON object storage might be nice for any work with Node. I don't have much experience with MongoDB, but that's another option to pair nicely with Node (albeit needing hosting like MySQL).

    1. 1

      Hi ben, thanks for your feedback 😄
      We are using Firebase (Firestore) as DB for our webapp, but I wanted to create an independent service for this purpose.
      I could always create another instance of firebase, that's certainly true.

      1. 2

        There’s definitely no reason why you couldn’t build a microservice that has its own Firestore/Firebase instance.

        Just have your microservice do one thing and one thing well. Keep the integration light and simple.