I have seen the question be asked a lot but I am genuinely stuck on this decision, anything would be appreciated. Thanks
As I understand it in NoSQL you avoid making joins or querying different documents to piece data to together. With my data I have my books. Which i want to searched by: title, category, collection, author, and subjects(eventually). So as I understand i would create collection for everyone of those? But then i will users as well and they will have a lists of their books: read, un-read and maybe custom ones as well. So would i end up copying the data of the books into documents, make nested documents? But the data as it linked below is ~10MB approx.
Seeing as how it could grow out of control I keep thinking I misunderstood can someone help clarify please? Or is SQL the correct path?
Just to help paint the picture more, for nosql im considering mongodb and for sql its AWS RDS SQL Server.
This is sample of my data:
{
"7": {
"uespID": 50,
"title": "The Code of Mauloch",
"categoryIndex": 1,
"collectionIndex": 1,
"bookIndex": 1,
"img": "//esoicons.uesp.net/esoui/art/icons/lore_book3_detail2_color3.png",
"author": "",
"description": "A description of the unwritten rules of the Orcs",
"subjects": "",
"content": ""By the Code of Mauloch!"All their weapons and armor are smithed right there in the stronghold. All the food is hunted down by Orc warriors and brought back to be eaten by the Orcs who live there.nnOrcs follow no laws save their own, an unwritten set of rules called "The Code of Mauloch," named after one of their gods, who is sometimes called Malacath. Most of it's pretty simple: don't steal, don't kill, and don't attack people without reason (although there seems to be a big list of exceptions). Orcs in a stronghold don't have jails for their criminals...That's a fine way of thinking when you're leading a mercenary's life."
},
"8": {
"uespID": 55,
"title": "A Warning to the Aldmeri Dominion",
"categoryIndex": 1,
"collectionIndex": 1,
"bookIndex": 2,
"img": "//esoicons.uesp.net/esoui/art/icons/lore_book3_detail1_color4.png",
"author": "Erystera Ligen",
"description": "A Daggerfall Covenant ultimatum delivered to the Aldmeri Dominion",
"subjects": "",
"content": "By Erystera LigennnThe overlords of the Aldmeri Dominion are hereby put on notice: renounce your ambitions of aggression and return to your islands and jungles, or the wrath of the Daggerfall Covenant shall fall upon you like a hammer of the Divines...They must reconsider, or they must face our wrath."
},
"9": {
"uespID": 1877,
"title": "True Heirs of the Empire",
"categoryIndex": 1,
"collectionIndex": 1,
"bookIndex": 3,
"img": "//esoicons.uesp.net/esoui/art/icons/lore_book1_detail1_color3.png",
"author": "Erystera Ligen",
"description": "Propaganda for the Daggerfall Covenant",
"subjects": "",
"content": "By Erystera LigennnRejoice, peoples of northwest Tamriel! Though the rest of Nirn is afflicted by war, madness, and Daedric horror, the glory and honor of the Reman Empire lives on in the Daggerfall Covenant. We remain true to the primacy of trade, the principles of freedom, and worship of the Divines.nnIn the face of a world of enemies, the trade powers of the Iliac Bay have formed a powerful alliance. High Rock, Hammerfell, and Orsinium stand as one, united under the rule of the High King in Wayrest. Orc and Breton craftsmanship make the alliance an economic powerhouse, and the military strength of the Orcs and Redguards make us a force to be reckoned with. Our kings join our people in longing for the return of a Tamrielic Empire, along with the economic prosperity that goes with it. There is only one way to make sure the right Emperor rules once more from the Imperial City: we must attend to it ourselves.nnThe current so-called "Empire of Cyrodiil" is a sham, a twisted mockery of Reman's glorious Second Empire. The charlatans who sit on the Ruby Throne openly mock the Divines and court the Lords of Oblivion, the Enemies of Man. Even the once-promising Emperor Varen fell victim to Daedric corruption, his reforms swept away by the puppet-masters of the Daedric Cabal.nnThe Daggerfall Covenant is the only true heir to the principles of the Second Empire. In the name of the Divines, we must conquer Cyrodiil and restore the glory of Reman's legacy. The cancerous Daedra worship that has corrupted Cyrodiil and threatens all Nirn shall be cleansed from Tamriel. We shall found the Tamriel Covenant, that all kingdoms may have a seat at the Grand Council under a new Imperial Dynasty. nnForward, soldiers of the Covenant! Freedom for all peoples in the name of the Divines! For a new Empire and a new era of law and justice!"
}
All the data can be seen here:
https://raw.githubusercontent.com/ranvirsahota/Apocrypha/dev/db.json?token=GHSAT0AAAAAACQ65UUJPT7HO4YHHYGWPXOYZT3JHUQ
There are about 6400 records containing details about books.