May 17, 2019

Tell me your exotic database story

Nicolas Beauvais @Regex

Hey Indie Hackers!

Most products run with the same databases engines (MySQL, PostgreSQL, MongoDB, Redis...) that are taught in schools and online tutorials.

Did you ever have to move from the traditional relational or NoSQL database to something more exotic like Hierarchical, Graph, ER model, Object-oriented, Network or Document database?

Tell me your story below, how did you discovered it, what problem does it solve that a traditional database couldn't tackle easily?

#ask-ih #tech-questions

  1. 2

    It's not really a database, it's a search index, but we've built it in-house using the FAISS (https://github.com/facebookresearch/faiss) library as a basis. It helps us a lot with semantic search over the user data.

  2. 1

    I've gone with CockroachDB for my most recent project, because it looks like a regular Postgres db from the application side, but has benefits with scalability and availability. I'm especially concerned with the latter. I just really like that I can have three storage nodes in a cluster (in three separate availability zones in AWS), and if one goes down I'm not in a hurry to get it back up. Makes me sleep better at night. And this can be done extremely cost-effectively and in any cloud provider, without vendor lock-in.

  3. 1

    Perhaps not exotic, I used Google BigQuery in a previous job. It saved me tons of headache and time, as I didn't have to depend on devops for every little thing (because we were allowed to install stuff). I'd love to use it for personal projects, if I could afford it :(

    1. 0

      BigQuery is essentially free - you pay only for storage and queries. Unless you want to do so across massive amounts of data it's close to nothing (and even has a free tier)

      1. 2

        Yes, I know it is free for the first 1 TB, which is good for experimenting, but not good enough for serious applications.

        I love the product though