{"generator":"StatusNet 1.0.1","title":"Conversation","count":3,"totalItems":3,"items":[{"actor":{"displayName":"Toksyuryel","id":"http:\/\/rainbowdash.net\/user\/6766","avatarLinks":[{"url":"http:\/\/av.rdn.io\/avatar\/6766-480-20121120023350.jpeg","rel":"avatar","type":"image\/jpeg","width":"480","height":"480"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-48-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"48","height":"48"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-24-20121120023352.jpeg","rel":"avatar","type":"image\/jpeg","width":"24","height":"24"}],"image":{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},"type":"person","url":"http:\/\/rainbowdash.net\/user\/6766","statusnet:profile_info":{"local_id":"6766"},"contact":{"preferredUsername":"toksyuryel","displayName":"Toksyuryel","note":"Some kind of otherkin dragon thing who thinks he'll be a professional programmer someday. \r\n \r\nFavorite pony is Pinkie Pie, but Luna is best pony. Figure that one out.","addresses":{"formatted":"Renton"}}},"content":"@<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/7\" class=\"url\"><span class=\"fn nickname\">rotation<\/span><\/a><\/span> I am probably just over complicating it and don't really need to use subtables.","body":"@<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/7\" class=\"url\"><span class=\"fn nickname\">rotation<\/span><\/a><\/span> I am probably just over complicating it and don't really need to use subtables.","id":"http:\/\/rainbowdash.net\/notice\/1342631","object":{"displayName":"@rotation I am probably just over complicating it and don't really need to use subtables.","id":"http:\/\/rainbowdash.net\/notice\/1342631","type":"note","url":"http:\/\/rainbowdash.net\/notice\/1342631"},"to":[{"objectType":"person","id":"http:\/\/rainbowdash.net\/user\/7","url":"http:\/\/rainbowdash.net\/user\/7"}],"context":{"conversation":"http:\/\/rainbowdash.net\/conversation\/304558"},"published":"2012-05-07T16:54:23+00:00","postedTime":"2012-05-07T16:54:23+00:00","provider":{"objectType":"service","displayName":"Rainbow Dash Network","url":"http:\/\/rainbowdash.net\/"},"title":"@rotation I am probably just over complicating it and don't really need to use subtables.","verb":"post","url":"http:\/\/rainbowdash.net\/notice\/1342631","statusnet:notice_info":{"local_id":"1342631","source":"web"}},{"actor":{"displayName":"Toksyuryel","id":"http:\/\/rainbowdash.net\/user\/6766","avatarLinks":[{"url":"http:\/\/av.rdn.io\/avatar\/6766-480-20121120023350.jpeg","rel":"avatar","type":"image\/jpeg","width":"480","height":"480"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-48-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"48","height":"48"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-24-20121120023352.jpeg","rel":"avatar","type":"image\/jpeg","width":"24","height":"24"}],"image":{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},"type":"person","url":"http:\/\/rainbowdash.net\/user\/6766","statusnet:profile_info":{"local_id":"6766"},"contact":{"preferredUsername":"toksyuryel","displayName":"Toksyuryel","note":"Some kind of otherkin dragon thing who thinks he'll be a professional programmer someday. \r\n \r\nFavorite pony is Pinkie Pie, but Luna is best pony. Figure that one out.","addresses":{"formatted":"Renton"}}},"content":"@<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/7\" class=\"url\"><span class=\"fn nickname\">rotation<\/span><\/a><\/span> I'm sketching out what I want the database to look like for my stab at reimplementing <a href=\"http:\/\/status.net\/\" title=\"http:\/\/Status.Net\/\" rel=\"nofollow external\">status.net<\/a> in python, and was thinking about using several tables and subtables that all reference back to the main POSTS table as a method of pre-caching metadata like what tags are in the post, what users are mentioned in it, etc to speed up post lookups when searched for on said metadata (such that an exhaustive search should never be necessary). The database software I'd prefer to use is PostgreSQL.","body":"@<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/7\" class=\"url\"><span class=\"fn nickname\">rotation<\/span><\/a><\/span> I'm sketching out what I want the database to look like for my stab at reimplementing <a href=\"http:\/\/status.net\/\" title=\"http:\/\/Status.Net\/\" rel=\"nofollow external\">status.net<\/a> in python, and was thinking about using several tables and subtables that all reference back to the main POSTS table as a method of pre-caching metadata like what tags are in the post, what users are mentioned in it, etc to speed up post lookups when searched for on said metadata (such that an exhaustive search should never be necessary). The database software I'd prefer to use is PostgreSQL.","id":"http:\/\/rainbowdash.net\/notice\/1342588","object":{"displayName":"@rotation I'm sketching out what I want the database to look like for my stab at reimplementing status.net in python, and was thinking about using several tables and subtables that all reference back to the main POSTS table as a method of pre-caching metadata like what tags are in the post, what users are mentioned in it, etc to speed up post lookups when searched for on said metadata (such that an exhaustive search should never be necessary). The database software I'd prefer to use is PostgreSQL.","id":"http:\/\/rainbowdash.net\/notice\/1342588","type":"note","url":"http:\/\/rainbowdash.net\/notice\/1342588"},"to":[{"objectType":"person","id":"http:\/\/rainbowdash.net\/user\/7","url":"http:\/\/rainbowdash.net\/user\/7"}],"context":{"conversation":"http:\/\/rainbowdash.net\/conversation\/304558"},"published":"2012-05-07T16:50:27+00:00","postedTime":"2012-05-07T16:50:27+00:00","provider":{"objectType":"service","displayName":"Rainbow Dash Network","url":"http:\/\/rainbowdash.net\/"},"title":"@rotation I'm sketching out what I want the database to look like for my stab at reimplementing status.net in python, and was thinking about using several tables and subtables that all reference back to the main POSTS table as a method of pre-caching metadata like what tags are in the post, what users are mentioned in it, etc to speed up post lookups when searched for on said metadata (such that an exhaustive search should never be necessary). The database software I'd prefer to use is PostgreSQL.","verb":"post","url":"http:\/\/rainbowdash.net\/notice\/1342588","statusnet:notice_info":{"local_id":"1342588","source":"web"}},{"actor":{"displayName":"Toksyuryel","id":"http:\/\/rainbowdash.net\/user\/6766","avatarLinks":[{"url":"http:\/\/av.rdn.io\/avatar\/6766-480-20121120023350.jpeg","rel":"avatar","type":"image\/jpeg","width":"480","height":"480"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-48-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"48","height":"48"},{"url":"http:\/\/av.rdn.io\/avatar\/6766-24-20121120023352.jpeg","rel":"avatar","type":"image\/jpeg","width":"24","height":"24"}],"image":{"url":"http:\/\/av.rdn.io\/avatar\/6766-96-20121120023351.jpeg","rel":"avatar","type":"image\/jpeg","width":"96","height":"96"},"type":"person","url":"http:\/\/rainbowdash.net\/user\/6766","statusnet:profile_info":{"local_id":"6766"},"contact":{"preferredUsername":"toksyuryel","displayName":"Toksyuryel","note":"Some kind of otherkin dragon thing who thinks he'll be a professional programmer someday. \r\n \r\nFavorite pony is Pinkie Pie, but Luna is best pony. Figure that one out.","addresses":{"formatted":"Renton"}}},"content":"Can an SQL table contain subtables?","body":"Can an SQL table contain subtables?","id":"http:\/\/rainbowdash.net\/notice\/1342518","object":{"displayName":"Can an SQL table contain subtables?","id":"http:\/\/rainbowdash.net\/notice\/1342518","type":"note","url":"http:\/\/rainbowdash.net\/notice\/1342518"},"context":{"conversation":"http:\/\/rainbowdash.net\/conversation\/304558"},"published":"2012-05-07T16:43:46+00:00","postedTime":"2012-05-07T16:43:46+00:00","provider":{"objectType":"service","displayName":"Rainbow Dash Network","url":"http:\/\/rainbowdash.net\/"},"title":"Can an SQL table contain subtables?","verb":"post","url":"http:\/\/rainbowdash.net\/notice\/1342518","statusnet:notice_info":{"local_id":"1342518","source":"web"}}],"links":[{"url":"http:\/\/rainbowdash.net\/conversation\/304558","rel":"alternate","type":"text\/html"}]}