DEV Community

Discussion on: NoSQL Written On Top of MySQL.

Collapse
 
tacsiazuma profile image
Krisztian Papp

What was the reason to use Mongo over SQL? What kind of project was it?

Collapse
 
joshualjohnson profile image
Joshua Johnson

So the project for me was the inability to convince management to use anything other than straight SQL queries. A lot of the time, we were demanded to be fast at implementing our updates. As it turns out, things got chaotic with over 20 developers checking in changes to database schemas. The director of Software Engineering didn't want to implement new architecture. So a new Database type was completely out of the question. So, I invented a stop gap solution for inserting and querying for objects. Eventually, the FireSQL project was created shortly after leaving that company. I realized that many other companies are using solutions like Wordpress. So this could be a quick bolt on solution to wordpress without having to interrupt the schemas they have in place.

I had a client come to me who wanted me to add a registry to their Woocommerce powered website. He only wanted to spend $1200. I put this solution in place and was able to finish all of the work to create his registry in less than 10 hours worth of work.

I had another client want to build out an entire backend to manage data, but they wanted to do it for less than 10k. Again, I used this solution, built out an interface for managing their collections/objects and delivered what they asked for and I averaged $120/hour.

Both solutions are still running today. And the solutions are doing good. I'm not saying that this is for enterprise level companies, but the average small to medium sized business could absolutely use this.