4
5 Comments

Tell me your exotic database story

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

Trending on Indie Hackers
How I grew a side project to 100k Unique Visitors in 7 days with 0 audience 49 comments Competing with Product Hunt: a month later 33 comments Why do you hate marketing? 29 comments My Top 20 Free Tools That I Use Everyday as an Indie Hacker 15 comments $15k revenues in <4 months as a solopreneur 14 comments Use Your Product 13 comments