[06:37] https://thepiratebay.se/user/holoverse/0/7 [06:40] Someone's been busy [06:57] Hmmmm [07:36] godane, were you able to find "boot" magazine [07:36] came out mid 90s [07:41] boot magazine became maximum pc magazine right? [07:41] i couldn't find boot magazine but i have zip/cbz archives of maximum pc magazine thanks to google books [07:42] also got a t3 uk magazine issue 1 [07:42] yes it became Max pc [07:46] http://www.ebay.com/itm/Books-Boot-Magazine-Vol-1-Issue-1-Sept-Aug-1996-Collectors-Edition-/170996513941?pt=Magazines&hash=item27d02fbc95 [07:46] found it on ebay [07:48] what I don't understand is why the chumby ran its apps online at all. surely they knew that was a recipe for screwing over their users. [07:57] Doomsday Trailer: https://archive.org/details/g4tv.com-video20371 [07:57] g4 is like the ramdom crap sometimes [07:57] you have no idea what you will find [07:58] anyways going to bed [07:58] heh [07:58] hoping to get the full offtopic subforum of g4 sometime tomorrow [07:58] dream of fast downloads and happy parity blocks [07:59] i just know i will have do another grab around march 15th [08:00] then something last min on the 17th [08:00] be back later [09:45] So what do people think of that kickstarter film winning an oscar? [09:45] Hollywood should be worried, somewhat [09:46] the oscars are hollywood i thought [09:47] things are changing [09:47] there were 3 kickstarter films in the running [09:55] why should hollywood be worried? [09:55] kickstarter-funded films still hire film people to work on them [09:56] it takes away the director selection, writing process, marketing and money backing [09:57] Less rules and more chances for innovation [09:58] Just because a movie gets kickstarted, doesn't mean it'll be good or seen by many. [09:58] true [09:58] same for any hollywood film [09:59] Indeed, though they have a lot of money to spend in general - and practially "own" the entire industry. [09:59] So at least the seen by many, could be taken care of in a larger sense [10:02] Well mysql just shit the bed again on this project [10:02] lets flip it over to postgresql [10:02] maybe sqlite [10:03] Your url database project? [10:09] the screenshot tool [10:10] I am storing everything that I think should go in the warc in there for now [10:10] posterous cannot wait [10:11] then make the warcs later [10:11] fuck [10:12] I hit the mysql table size limit thing I think [10:12] 4gb [10:12] eat a fucking dead donkey you non-webscale assholes [10:12] ;) [10:12] are you saving the original HTTP Request and response in a database? ;o [10:12] lol'd at web scale [10:12] that, plus a sha1sum of the files [10:14] I am reading an article from a craigslist engineer about it. Talk about expert level knowledge [10:15] it came up before the mysql docs even [10:15] I keep using mysql because I know all the bullshit quirks. I need to learn the postgresql ones [10:19] postgres has no quirks [10:27] okay time to try and load my data into postgresql [10:30] Anyone know of low cost or free ways to get access to lexus nexus or jstor [10:30] I grew too used to using that stuff while in college [10:30] i only know alexis texas :( [10:31] lol [10:32] At one point I had a proxy setup through a college students account [10:32] It was sweet [10:34] In the field of computer science you can find many articles through a simple google search instead [10:35] Tried that, most of the papers I want are in pay only journals [10:35] Like if I wanted to read the original Bently papers they are only in the ACM [10:37] wow the postgresql wiki sucks. It gives me like 10 articles to read and does not tell me shit about what is in them [10:37] the first 2 I read were worthless [10:38] They have excellent documentation outside of the wiki [10:38] I thought this was supposed to be curated content not a link board [10:38] oh yes they [10:38] but I want a case study style approach [10:51] 10 minutes for a database dump, when did I become so impatient [10:57] :D [11:07] fuck it I am going to fix the table and keep using mysql for now. I got too much shit going on [11:07] all new projects are postgresql though [11:08] mysql date time and character escaping non-sense is taking too long [11:23] lol [11:29] I gotta finish a 7 million row update that is what started all this [11:29] omf_: character escaping...? [11:29] mysql does some non-standard shit [11:30] no, I mean, why are you escaping characters [11:30] because mysql escapes characters differently and if you do not fix them postgresql loads it wrong [11:30] *what* characters? [11:31] the only thing I can think of regarding escaping in the context of SQL, is escaping input to prevent it from fucking up your query [11:31] which is not necessary when using parameterized queries [11:31] https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#SQL [11:32] erm [11:32] !ops [11:32] etc [11:32] #archiveteam plz [11:32] omf_: okay? table says nothing about escaping... [11:32] :D [11:32] I didn't mean give me ops, but thanks :D [11:32] the 2nd row [11:32] if you look at an sql dumb those characters are different [11:33] okay? but what does that have to do with escaping? [11:34] also, omf_, https://pypi.python.org/pypi/py-mysql2pgsql [11:34] see backlog before http://wire.cryto.net/logs/2013-02-07#T01-56-32 [11:35] a whole discussion went on there about mysql -> postgresql [11:42] tried that script. Couldn't get the dependency chain to resolve [11:46] omf_: did you install the postgresql development package? [11:46] yes [11:46] what's the error you were getting? [11:47] a couple pages of output. Doesn't matter since the alter command finished and I was able to start the grab again. This will have to wait till later [11:48] then it's not a dependency resolution error [11:48] but a compile error [11:48] No it says some shit it needs cannot install [11:48] read: usually missing a development package of some sort [11:48] yes [11:48] I know how to read output [11:48] and above that there's most likely a compile error [11:48] "cannot resolve package X" errors in pip are at most 4 lines long or so [11:48] if you get more error output than that, there's a different issue [11:49] and that issue is usually a failed package install, and usually because of failed compilation [11:50] I also need to make sure I am running a good version of postgresql [11:50] up to date and stable [15:53] plane wifi is the best [15:55] It's magical [17:25] aww yeah posterous seesaw [17:25] time to waste a /27 [18:38] :D [18:54] The tracker is still down :-( [18:56] hm, the disk is completely full [18:56] that can't be good [18:59] that can't be good, indeed [19:03] D: [19:03] we killed it? [19:03] I'm freeing up a few gigs [19:03] but it was less than 50% full yesterday [19:09] ohhhhhh [19:09] it appears to be accepting rsync uploads?? [19:09] this machine is NOT supposed to do that [19:10] alard: wtf is tracker:/var/www/rsync for? [19:10] it's killing the box [19:48] :D [19:49] when in Doubt, blame alard [19:49] well it's got his user id on it [19:50] :D [20:00] chronomex: Alard is rsycing posterous to the tracker [20:00] well that's all kinds of wrong [20:00] tracker isn't designed to have disk space [20:00] and he's not draining it [20:01] How much diskspace does the tracker have? [20:01] total disk is 20G [20:02] currently ~8G is posterous, and there's ~2G free [20:02] I deleted 3G of crap an hour ago [20:02] (from my homedir) [20:04] I could set up rsync on my storage vps [20:10] Hm, maybe it was just accidentally and he wanted to point them to the batcave [20:15] chronomex: Could you send me the rsync config from the tracker? [20:28] Man guys, why haven't we been using this? Web archiving could be so much easier: http://anarchivist.tumblr.com/post/44000544319 [20:30] Heh [20:31] wow [20:31] kickstarter announced 31 minutes ago and already 40% to goal... [20:32] Coderjoe: What Kickstarter? [20:33] rifftrax wants to do a live riff of a major hollywood movie (instead of the usual PD or low-license-cost fare) [20:33] http://www.kickstarter.com/projects/90538351/rifftrax-wants-to-riff-twilight-live-in-theaters-n [20:33] i found better scans of commodore horizons [20:33] http://www.oldgamemags.com/index.php/magazines/64-commodore/commodore-horizons [20:33] Coderjoe: Wow, that is incredibly fast! Good for them, that sounds awesome. [20:38] I'm amused by one of the reward shorts: a digital download of a riff of A Voyage to the Moon [20:44] looks to me like a target= just needs to be added here? https://github.com/ArchiveTeam/posterous-grab/blob/master/pipeline.py#L235 [20:44] compare https://github.com/ArchiveTeam/weblognl-grab/blob/master/pipeline.py#L120 [20:45] Nah, upload locations are now controlled by the tracker [20:45] The client asks the tracker "where shall I send this" and then gets either an http or rsync url [20:45] Someone needs to change it in the tracker admin panel [21:24] funded in 1 hour 23 minutes [22:28] Well just great there i go and want to build an ami with seesaw-kit in it and then github is down