Rewriting my app from ruby/rails to javascript/express. Will mongodb suit my needs? -

-

my rails 3 database schema.rb looks this:

activerecord::schema.define(:version => 20110504034934)    create_table "comments", :force => true |t|     t.string   "name"     t.text     "content"     t.integer  "post_id"     t.datetime "created_at"     t.datetime "updated_at"     t.string   "ancestry"   end    add_index "comments", ["ancestry"], :name => "index_comments_on_ancestry"    create_table "posts", :force => true |t|     t.string   "name"     t.string   "title"     t.text     "content"     t.integer  "topic_id"     t.datetime "created_at"     t.datetime "updated_at"   end    create_table "topics", :force => true |t|     t.string   "name"     t.datetime "created_at"     t.datetime "updated_at"   end end

the additions database user-related via openid. can mongodb handle this?

yes, mongodb can handle type of structure. note may want change structure of data. may want consider embedding comments inside of posts.

also take @ topics. if topic name unique (it is), may want consider making _id in mongodb.

if you're moving node / mongodb, you'll want check out mongoosejs.com. it's simple orm mongodb. may model data.


Comments

Post a Comment

Popular posts from this blog

iphone - Using nested NSDictionary with Picker -

-
newbie here, i have single component picker set plist, each item being array, multiple strings in each array app uses. currently plist structure this: nsdictionary -> nsarray -> nsstring | | items in picker data each item but now, want: nsdictionary -> nsdictionary -> nsarray -> nsstring | | | different picker data sets items in picker data each item so there multiple sets of picker components show using segmented control etc... i'm not sure if possible, , hoping save me making many different separate picker controllers. what has me stumped getting ingested properly this have now, builds crashes (debug info below): nsbundle *bundle = [nsbundle mainbundle]; nsstring *plistpath = [bundle pathforresource:@"camerasdatabase" oftype:@"plist"]; nsdictionary *dictionary = [[nsdictionary alloc] initwithcontentsoffi...
Read more

php - accessing mysql using different server to which db connection data is located -

-
i'm trying include file db connection info (hostname password username). this have far: include ('http://site.com/config35sdf322e54353452d/wp2154654315634652132513546541564.php'); mysql_connect($hostname,$username,$password); @mysql_select_db($dbname) or die( "unable select database"); include ('../refference.php'); $select = mysql_query("select my_field $usertable ". "gdi_username = '$sponsor_gdi_id' , unique_id = '$sponsor_refference'"); while($check = mysql_fetch_array($select)) { $sponsor_email = $check["email"]; $sponsor = $check["gdi_username"]; $sponsor_first_nme = $check["first_name"]; $sponsor_second_nme = $check["last_name"]; $sponsor_domain = $check["gdi_domain"]; $unq_id = $check["unique_id"]; } $sponsor_name = "$sponsor_first_nme $sponsor_second_nme"; echo "$sponsor $hostname" ?> i err...
Read more

javascript - Iterate over array and calculate average values of array-parts -

-
i have array this: ["2011-06-16 16:37:20",23.2], ["2011-06-21 16:37:20",35.6], ["2011-06-26 16:37:20",41.8], ["2011-07-01 16:37:20",25], ["2011-07-06 16:37:20",22.8], ["2011-07-11 16:37:20",36.4], ["2011-07-16 16:37:20",34], ["2011-07-21 16:37:20",20] [...] format: [$date,count] now need add 3rd 4th value every array element, average of n counts before or after. example if n=3 the 3rd value should average of 3 count-values before , 4th value should average of 3 count-values after current array element. result that: ["2011-06-16 16:37:20",23.2, null, 34.13], ["2011-06-21 16:37:20",35.6, null, 29.86], ["2011-06-26 16:37:20",41.8, null, 28.06], ["2011-07-01 16:37:20",25, 33.53, 31.06], ["2011-07-06 16:37:20",22.8, 34.13, 30.13], ["2011-07-11 16:37:20",36.4, 29.86, null], ["2011-07-16 16:37:20",34, 28.06, null], ["2...
Read more