Data modelling for 'followers count' in MongoDB app with RESTful API -


i have user entity has array of other user ids he/she following.

var userschema = {   following: { type: array } };

i have restful api, , when request user, application needs know how many followers user has.

the 2 options see are:

  • when user requested, count query such as: { following: { $in: [userid] } }
  • when user posted, check see whether user ids added or removed following array, , if were, use mongodb's $inc increment or decrement followerscount property on user document have been followed/unfollowed.

are other options? if not, best option? feel weird putting followerscount property in document itself, because suggests can updated application, when in fact dynamic count.

i have similar situation need restful api return number of articles associated website. count articles website on request, or store count property , update every time new article associated website created?

don't scared of storing more data think need in document. when started thinking along lines of mongo, rather rdms, freed thinking normalize everything. allowed me add more 'useful' information document, if wans't strictly necessary. transactions within document cheap, , cost of storage relatively cheap well. cost in finding information in document or collection expensive (processing wise) , possibly worth mitigating if can.

i understand concern having count in db 'the application can edit'. what? make sure application can't edit it, , if api open world, make sure can't edit either. usefulness of 'cached' count far outweighs fact potentially edited , fall out of sync. 1 of dangers of using nosql database: things end out of sync, since we're trusting application code keep data in order, rather relying on database.

consider this. if user gets removed, , count doesn't updated. make world of difference user? possibly not. while idea of background task check values (and worth having that), solution check integrity everytime user posts followers. in case have users anyway, , relatively inexpensive check count well. you're building in failsafe checks data integrity everytime message sent user. if user never sends, user doesn't care if count 100% accurate.

at end of day, if code tested, , defensive coding practices followed, shouldn't have consistency problems.


Comments

Post a Comment

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

since using iframes house external pages are, accounts "not preferred method" , disallowed sites (flickr, one), want dynamically generate browser tabs. e.g., when user submits form, want dynamically generate tab on browser in response submitted. e.g., might want add new tab url like: http://www.bigsurgarrapata.com/contact how in jquery? you want form target attribute action attribute. http://www.w3schools.com/tags/att_form_target.asp browsers have ultimate control on result of target attribute open new tab value of _blank. <form action="contact_submit.php" target="_blank" method="post">
Read more

node.js - Getting the socket id,user id pair of a logged in user(s) -

i have web application done using node js , in it,i have authentication system requires users log in before can access pages. have 2 pages,the homepage , updates page. from read docs,a new socket id issued when user opens tab in browser. me being admin,i know socket id of logged in user , more so,the socket id,logged in user id pair logged in users. what method can use socket id,logged in user id pair make sure broadcast realtime info users online?.
Read more

keyboard - C++ GetAsyncKeyState alternative -

i using windows.h library's getasynckeystate function define key pushed on keyboard . here program returns int value of pushed key example. #include <iostream> #include <windows.h> using namespace std; int main (){ char i; for(i=8;i<190;i++){ if(getasynckeystate(i)== -32767){ cout<<int (i)<<endl; } } return 0; } but trying make opengl simple game , function appeared slow . there function not need cycle 180 times , if statement . thanks you're trying make opengl game, you're going use glfw. if that's case can away using glfwgetkey() such: if (glfwgetkey(glfw_key_up) == glfw_press) {...} if (glfwgetkey(glfw_key_down) == glfw_press) {...} that method nicely explained in tutorial 6 opengl-tutorial.org . should start first tutorial of beginners tutorials , later intermediate tutorials . if you're going make win32 window can listen wm_keydown or wm_keyup messages , virtua
Read more