Hacker News new | ask | show | jobs
by smurfpandey 4177 days ago
Storage of JSON documents. We are using MySQL as our primary database, and mongoDB for storing JSON documents.
1 comments

What do you do with the documents? Join them? Search them? Filter them? Summarize/aggregate them? All of the above? Do you have schemas for them? (Just curious!)
These documents are simply sent to our client apps. All the processing happens on MySQL. And since we are sending JSON, so instead of creating JSON on runtime, we store as a document and retrieve that and send to the client.

We retrieve documents using the unique id generated in mysql table.