Log file Viewer

[00:56:50] <frostyfrog> No idea overburn :(

[02:40:01] <LoneSoldier728> ok so this is an interesting question

[02:40:10] <LoneSoldier728> how do I design mongodb for recent activities

[02:40:53] <LoneSoldier728> any suggestions... basically I have followers/following connections and I want users to have a feed populated by followers

[02:45:29] <LoneSoldier728> http://stackoverflow.com/questions/22277734/how-to-store-followers-recent-activity-database-design

[08:11:44] <Guest45591> anybody use the mongo dart driver

[08:11:54] <Guest45591> I having some issue updating a map in document

[08:18:27] <Guest45591> any body active

[10:09:30] <yuki23_98> hi

[10:09:37] <yuki23_98> from japan

[10:10:03] <yuki23_98> question OK>

[10:10:05] <yuki23_98> ?

[10:50:01] <kali> yuki23_98: yeah, just ask

[11:14:10] <shantanoo> hi, which takes less space while storing data in mongodb. ISODate object or the string in isoformat

[11:17:03] <kali> Date. (so that's ISODate in the shell)

[11:17:12] <yuki23_98> hi

[11:17:27] <yuki23_98> i install meteor

[11:17:31] <yuki23_98> now

[11:17:47] <yuki23_98> mongodb in meteor

[11:18:44] <yuki23_98> error

[11:18:46] <yuki23_98> Unexpected mongo exit code 14. Restarting.

[11:19:29] <yuki23_98> Can't start Mongo server.

[11:26:29] <delkin_> Is there a way to tell mongo to keep a collection ordered by date, to avoid doing it every time I find() the elements? Does this make sense?

[11:28:41] <kali> delkin_: hmmm... what do you mean "doing it every time" ? you're sorting in your code ?

[12:35:47] <lior> hey so I am trying to figure out my database design for friends recent activities... what is the best way to do it scaling wise?

[13:33:03] <ron> lior: shalom. that question is a bit too vague.

[14:01:54] <tradeigniter> Hi

[14:03:17] <tradeigniter> any one here

[14:04:01] <tradeigniter> Im looking for someone to advise me on my database

[14:04:08] <ron> just ask your question.

[14:07:19] <tradeigniter> ive built a db in mysql but I want to move over to mongodb

[14:07:32] <tradeigniter> I need someone to build the design

[14:07:41] <tradeigniter> Its a trading platform im creating

[14:07:51] <tradeigniter> I have most of the feilds

[14:11:02] <tradeigniter> I can pay also for someone to look at what I have and start me off in the right direction

[14:12:09] <ron> no need to pay. just start giving out the specifics and hopefully someone will guide you.

[14:13:16] <tradeigniter> http://192.81.213.140:2403/dashboard/

[14:13:28] <tradeigniter> i found this nodejs app called deployd

[14:13:36] <tradeigniter> ive been using it to help me with the database

[14:14:28] <tradeigniter> http://pastebin.com/0DqZggbW

[14:14:56] <tradeigniter> im just trying to make a rough database layout of whats needed

[14:16:22] <tradeigniter> im sure theres alot more feilds to be added but its certainly a good start

[14:32:12] <tradeigniter> any thoughts

[14:50:14] <tradeigniter> Im building an exchange currently looking for database designers and developers to help

[15:34:00] <tradeigniter> https://github.com/panique/php-login/blob/master/application/_installation/sql_statements/02-create-table-users.sql

[15:34:10] <tradeigniter> how would I go about making this in mongo

[15:34:27] <tradeigniter> would that just be users collection

[15:58:24] <lior> hey ron I realized... basically I am trying to figure out how to design my table for showing a user's followers recent activity

[16:00:12] <lior> I was thinking of adding a collection with each action and userid and i already have a collection with a user's followers, so I can query the actions collection with the db.posts.find({ userId: { $in: [12, 24, 56, …] }, date: { $gt: x, $lt: y } }).sort({ date: -1 }).limit(-100)

[16:00:55] <lior> is that good enough or would it pose a problem in the future for scaling/ is there a more efficient way?

[16:01:38] <kali> lior: http://blog.mongodb.org/post/65612078649/schema-design-for-social-inboxes-in-mongodb

[16:02:12] <kali> the schema your describing does raise serious issues

[16:04:13] <lior> what kind of issues?

[16:07:11] <kali> scalability. your find() is impossible to optimize with an index, even before sharding

[16:07:49] <lior> so what is a more efficient query

[16:08:16] <kali> you need a denormalized schema. read the blog post

[16:09:07] <lior> yeah i am

[18:34:04] <raminnoodle> Can anyone take a look at my query and see what im doing wrong

[18:34:05] <raminnoodle> http://pastebin.com/VrGK5U7e

[18:34:40] <raminnoodle> or more like how to adjust it

[18:40:35] <raminnoodle> anyone?

[18:41:22] <kali> raminnoodle: you'll struggle to get the results you want

[18:41:35] <raminnoodle> yea :/

[18:41:45] <raminnoodle> im trying to figure out how to make my grouping within another ojbect

[18:41:48] <raminnoodle> like in my eample

[18:41:50] <kali> raminnoodle: you would need to know the various coin type value beforehand

[18:41:56] <raminnoodle> I do

[18:42:16] <raminnoodle> but why can I group them and set the child objects the params

[18:42:25] <kali> well, then, you can use $project to arrange the results

[18:42:35] <raminnoodle> can project also encapsulate

[18:42:55] <raminnoodle> each grouping into another object with the key as the coin type

[18:43:13] <kali> anyway, this is a waste of db-server resource

[18:43:25] <raminnoodle> why is that

[18:43:27] <kali> better reformat whatever needs reformating on the application level

[18:43:41] <raminnoodle> really...

[18:43:56] <raminnoodle> i would just like clean formated results

[18:44:44] <kali> the database server is the part of your infrastructure that is difficult to scale. don't bug it with stuff you can do elsewhere

[18:44:55] <raminnoodle> ok gotcha

[18:44:59] <raminnoodle> good point

[18:45:04] <raminnoodle> thanks

[20:05:03] <[twisti]> hey, i dont really understand how these nosql things work - can you still effectively search the storage, like in sql with columns and indexes ? or is that not something youd do with something like mongodb ?

[20:05:25] <ron> [twisti]: yes.

[20:08:36] <ron> [twisti]: nosql dbs are just... databases. and like everything out there, they have benefits and drawbacks in different fields.

[20:09:39] <ron> [twisti]: the only general assertion you can make regarding nosql solutions is that they don't use sql to query them.. and even that assertion isn't 100% correct. you have to look at each nosql solution separately.

[20:25:17] <bufferloss> how can I send a $where query to mongo? e.g. I want to select all records where the date_time field is a multiple of 5 minutes (not sure if this is node.js specific or mongo specific as I'm using the node.js native driver for mongo)

[21:39:19] <raminnoodle> bufferloss: db.gls.find({field:value})

[21:39:24] <raminnoodle> sorry

[21:39:30] <raminnoodle> bufferloss: db.collection.find({field:value})

[21:40:11] <retran> heh... you said gls

[23:21:01] <LoneSoldier728> hey so creating a feed system for users who have followers... wanted to get your opinion on the design... http://pastebin.com/GPJm46bq

[23:21:49] <LoneSoldier728> Basically creating 2 collections, sharded based on the owner, followers... and I am using this example pretty much from mongodb (3rd one) http://blog.mongodb.org/post/65612078649/schema-design-for-social-inboxes-in-mongodb