So this is the year...Databases, here I come
PostgresSql, MongoDB, and MemSQL. I am going to push data, learn about data, become data (is that too weird?). After months, if not years, of trying to settle on which databases to thrown my life into, I settled on those three. And I don’t know that i can tell you exactly why. But here is what I can tell you:
I was looking for three types of databases: an Open Source RDBMS, an Open Source NOSQL database, and an In Memory Database. Open Source was important because of cost. I am running a start up and of course, money is everything. So free is always good. As far as MemSQL, I am using the Community Edition for now, again, because of cost.
My reasons for using each, really are simple. I chose Postgres over MySql because I have the opportunity of using Postgres at my current work; MongoDB because I have heard and read about it every where for years and seems extremely stable; and MemSQL because, well, they didn’t pester me like some of the other In Memory DB. Real reasons, all of them, in my book.
But in all honesty, in this day and age where you can find so many options for everything, in order to choose the “correct” thing, it would require so much research. And let’s face it, by the time that research is done, new versions are out with new features, new databases show up promising so much more than others, that’s you might as well start over again. In the end, specially for start up like mine, a decision like this comes down to just a gut feeling. So here I am.
In the next few weeks and months, I will share the project I am working on that requires these three databases; their installation and the struggles that goes with it; the loading of tons of datasets and the issues that will come from it; and of course, the building of a business out of these databases and the data they will contain.
Join me. It should be a fun ride!