Couchdb can run on Android and easily sync with a server in the cloud. It’s a great solution for providing apps that work “offline”. But I’m fairly new to Couchdb and the whole nosql thing. And actually, I when I first started coding we used flat files. Relational databases and SQL made life much better. So I’m a still a bit skeptical about nosql. But the offline/online sync is something I really need.
Couchdb will give me the sync that I need. But so far reporting off nosql is at least behind from what I can tell. So I’d like to use Couchdb (probably with a couchapp) on the mobile side and have the data normalized and put into MySQL where I can work in familar surroundings.
And since my preferred development environment is Grails with its all-powerful GORM, I have an idea. There’s a Couchdb plugin for Grails that will use GORM to create databases and documents from domain classes. And of course, it creates MySQL tables and records. So it seams feasible that I can create a Grails plugin that will take Couchdb documents, normalize them and put their data into MySQL.
I’d certainly appreciate any feedback on this idea.