#archiveteam-bs 2013-02-25,Mon

↑back Search

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

irclogger-viewer