I'm planning on letting people download the sqlite database file. That's a single file (with the .db extension I think) that you can load into any air app and access. I could also do a CSV, but it's a lot of data (hell, excel can't even load that many rows).
Doug On Sun, Jun 22, 2008 at 10:18 PM, arieljake <[EMAIL PROTECTED]> wrote: > What will the data format be so we can plan ahead? > > --- In [email protected], "Doug McCune" <[EMAIL PROTECTED]> wrote: >> >> Within then next week I hope to have a fairly complete dataset of >> date, subject, and name of who posted for close to all the messages >> ever posted to flexcoders. I might also do a second pass to get full >> text of each message too. I say "close to all" because I'm scraping >> the mail archive website and that only shows 95,000 message, but in >> reality I think there are more like 116,000. Plus some of the messages >> from 2004 seems to have gotten a bit jacked on the mail archive site >> and don't show up with the proper subjects and senders (there's a >> block of a few hundred). >> >> But once I get that I'm going to post a sqlite DB file that has it all >> that you can load into an air app to play with. I'll let y'all know >> when you can start playing with the data. >> >> Doug >> >> On Sun, Jun 22, 2008 at 5:29 PM, Tim Hoff <[EMAIL PROTECTED]> wrote: >> > >> > flexCodersStatus = (mostRecentlyPostedThread == "The subject that > shall >> > not be named!" ? "Banned" : "Active"); >> > >> > -TH :-) >> > >> > --- In [email protected], Matt Chotin <mchotin@> wrote: >> >> >> >> Hey folks, >> >> >> >> Given the recent big thread on the subject that shall not be > named, my >> >> colleague Suchit went ahead and got some interesting membership stats >> > since >> >> the beginning of the list. >> >> >> >> Number of people who: >> >> >> >> Joined group == 14036 >> >> Left group == 3686 >> >> Were Banned == 631 >> >> Got Removed == 359 >> >> >> >> I would say losing ~25% over time isn't too bad. That said we haven't >> > done >> >> analysis to see if there's a trend in dates or if we're losing more >> > people >> >> recently, etc. But interesting info for starters... >> >> >> >> Matt >> >> >> > >> > >> > >
