Nice! This is a much simpler decision tree. Google uses column-oriented as their primary database, but you're probably right that unless at massive scale, it only makes sense as a secondary data store (e.g. data warehouse)
I created something like this for PostgreSQL. It's a Node.js service that implements the MongoDB wire protocol and converts the query to use jsonb. It works pretty well, but it also got increasingly hard to make it compatible because MongoDB has a lot of quirks.
As a F/OSS freeloader, I would very much like you a link to this project... Feels like something I'd contribute to or do something crazy like try to start a business (2ndquadrant/edb style) on.
Thanks! I didn't realize I put the link. Here it is, http://github.com/thomas4019/pgmongo. I'd love to hear your thoughts on it and am happy to answer any questions.
Author here. I like the Mongo query interface so I originally wrote some of the conversion code for my API framework called expressa. Then I created this project largely to see if it were possible. I'm not really sure how this will be useful. Migrating data should be relatively easy with Mongo's db.copyDatabase() since it thinks it's just copying from one Mongo to another.
Thanks for bringing this up. Currently there's no migration process. Like Mongo, Expressa only ensures validity of new data, but doesn't change old data so it's up to the application to handle that.
This is definitely something I would like to eventually support though so that renaming fields and other data changes are easy.
One of the main features is that it provides an admin interface which lets you modify your data as well as your collection schema. I got tired of Django, keystone and other CMS that require defining schema in code and have found this to be a good solution for my projects.
thanks. A new version is coming out in js, so no browser add on necessary. It will find the main points, supporting content, etc. automatically, so you can still use number keys to cut to the chase. Will post when its released.
This has been an idea of mine for 8 years and just got around to hacking away at it.
