which database should we use to store analytics data?

[nelsonic]

• https://segment.com/blog/choosing-a-database-for-analytics/
• https://reflect.io/blog/analytics-101-choosing-the-right-database/
• http://www.kdnuggets.com/2015/12/database-best-for-analyst.html
• http://stackoverflow.com/questions/19923924/appropriate-database-for-web-analytics

Has anyone tried mnesia ? https://en.wikipedia.org/wiki/Mnesia

[nelsonic]

Not using a Database ... 😮 No Database would be worth the overhead. So using an "append-only immutable log" using the Filesystem. See: http://milinda.pathirage.org/kappa-architecture.com/

[ademidun]

@nelsonic I just want to say that your strategy of ask questions and answering them for yourself in public is brilliant. I'm currently in the process of trying to determine if we should use this at my work and reading your "learning in public" style of questions and answers makes it so easy for us to learn how this works and the small nuances of how hits works.

It reminds me of how stack overflow encourages people to do the same.

It's amazing that over 5 years later, this thread is still providing a lot of value to us. Thank you so much.

[nelsonic]

Hey @ademidun 👋 Stoked you fine my trails "brilliant". 😜 believe it or not, I was writing code before Google and long before StackOverflow. 👴 remember well having to look things up in books in a library ... 📚 🤯
So have always made copious notes of everything first in .txt files, then Google Docs and now GitHub. 📝

Looks like you are keen reader & note taker too: https://github.com/ademidun/book-notes 😍

If anyone else in your team is unconvinced by this method of "Answer your own research questions", ❓ ✍️ 🔍 💡 🚀 point them to Tiago Forte's "Building a Second Brain": https://github.com/dwyl/product-roadmap/issues/33 🧠 Again, was doing this looooong before he popularised the term. ⏳ But I'm delighted it's gaining traction now. 🎉

Hope you have a great week and good luck on your quest! 🗻