[00:02] *** pikhq has quit IRC (Remote host closed the connection) [00:08] *** sketchcow has quit IRC (Read error: Connection reset by peer) [00:14] *** sketchcow has joined #archiveteam-bs [00:14] *** swebb sets mode: +o sketchcow [00:17] *** pikhq has joined #archiveteam-bs [00:26] *** dashcloud has quit IRC (Remote host closed the connection) [00:28] *** dashcloud has joined #archiveteam-bs [00:35] *** kyan has joined #archiveteam-bs [02:58] *** lytv has quit IRC (Read error: Operation timed out) [03:07] *** lytv has joined #archiveteam-bs [04:18] *** aaaaaaaaa has quit IRC (Leaving) [05:02] *** sketchcow is now known as SketchCow [05:24] *** mistym has quit IRC (Remote host closed the connection) [05:46] *** mistym has joined #archiveteam-bs [06:01] oops. i gues i mean episode 7, balrog [06:04] balrog: did you find it, though? [06:04] I didn't [06:04] I didn't look hard [06:50] *** mistym has quit IRC (Remote host closed the connection) [07:22] *** schbirid has joined #archiveteam-bs [07:23] *** primus104 has joined #archiveteam-bs [07:47] *** pekesene_ has quit IRC (My Mac has gone to sleep. ZZZzzz…) [07:50] *** mistym has joined #archiveteam-bs [08:07] *** primus104 has quit IRC (Leaving.) [08:07] *** lytv has quit IRC (hub.se efnet.port80.se) [08:07] *** dan_ has quit IRC (hub.se efnet.port80.se) [08:07] *** serapeum has quit IRC (hub.se efnet.port80.se) [08:07] *** Rickster has quit IRC (hub.se efnet.port80.se) [08:07] *** goekesmi_ has quit IRC (hub.se efnet.port80.se) [08:07] *** Kazzy has quit IRC (hub.se efnet.port80.se) [08:07] *** Muad-Dib has quit IRC (hub.se efnet.port80.se) [08:07] *** GLaDOS has quit IRC (hub.se efnet.port80.se) [08:07] *** Sue_ has quit IRC (hub.se efnet.port80.se) [08:07] *** antomati_ has quit IRC (hub.se efnet.port80.se) [08:07] *** dx has quit IRC (hub.se efnet.port80.se) [08:07] *** Lord_Nigh has quit IRC (hub.se efnet.port80.se) [08:07] *** balrog has quit IRC (hub.se efnet.port80.se) [08:07] *** LittUp has quit IRC (hub.se efnet.port80.se) [08:07] *** johtso has quit IRC (hub.se efnet.port80.se) [08:07] *** deathy has quit IRC (hub.se efnet.port80.se) [08:07] *** goekesmi has joined #archiveteam-bs [08:07] *** dx- has joined #archiveteam-bs [08:08] *** GLaDOS- has joined #archiveteam-bs [08:08] *** antomatic has joined #archiveteam-bs [08:08] *** Kazzy_ has joined #archiveteam-bs [08:09] *** LordNigh2 has joined #archiveteam-bs [08:17] *** balrog_ has joined #archiveteam-bs [08:17] *** swebb sets mode: +o balrog_ [08:21] *** Rickster` has joined #archiveteam-bs [08:22] *** Rickster` is now known as Rickster [08:22] *** LordNigh2 is now known as Lord_Nigh [08:22] *** GLaDOS- is now known as GLaDOS [08:22] *** balrog_ is now known as balrog [08:23] *** Kazzy_ is now known as Kazzy [08:24] *** lytv has joined #archiveteam-bs [08:36] *** LittUp has joined #archiveteam-bs [08:36] *** johtso has joined #archiveteam-bs [08:37] *** Muad-Dib has joined #archiveteam-bs [08:37] *** dan_ has joined #archiveteam-bs [08:37] *** deathy has joined #archiveteam-bs [08:38] *** primus104 has joined #archiveteam-bs [08:54] *** mistym has quit IRC (Read error: Operation timed out) [09:01] *** lytv has quit IRC (Read error: Connection reset by peer) [09:01] *** serapeum has joined #archiveteam-bs [09:04] *** lytv has joined #archiveteam-bs [09:09] *** BlueMaxim has quit IRC (Ping timeout: 512 seconds) [09:10] *** BlueMaxim has joined #archiveteam-bs [10:30] *** mistym has joined #archiveteam-bs [10:37] *** mistym has quit IRC (Read error: Operation timed out) [10:43] *** pekesener has joined #archiveteam-bs [10:48] *** pekesener has quit IRC (Quit: My Mac has gone to sleep. ZZZzzz…) [10:54] *** Sue_ has joined #archiveteam-bs [11:00] anyone here knowledgeable in SQLAlchemy? [11:02] I'm trying to figure out how to use the JSON type for postgresql shown here http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html but i keep getting import and attribute errors [11:03] wait i think i finally figured it out [11:03] *** john1 has quit IRC (Read error: Operation timed out) [11:05] rubber duck debugging [11:05] I lack a duck [11:05] I should probably get one later [11:05] with a big sign reminding me to use it [11:06] a blinky sign that i can't forget [11:15] we were the duck in this case [11:15] and that's fine, it's still rubber duck debugging though :) [11:19] *** john1 has joined #archiveteam-bs [12:40] *** BlueMaxim has quit IRC (Read error: Connection reset by peer) [12:45] *** sankin has joined #archiveteam-bs [12:52] Ctrl-S: make sure to use JSONB, not JSON [12:54] why? [12:56] Ctrl-S: JSONB is parsed on insertion [12:56] which means any kind of lookup is much, much faster [12:56] as it is stored as a binary structure [12:56] rather than stored as text and parsed on every lookup [12:56] (as is the case for JSON) [12:57] you basically always want JSONB, unless you have JSON that is not fully spec-compliant (eg. the order of keys in an object matters) [12:57] okay, thanks [12:57] because the non-spec-compliant data is lost in JSONB [12:57] um [12:57] if i pass JSON in from an external source, i'd be better using JSON? [12:58] ATM i'm receiving JSON, json.loads()ing it, then reencoding after grabbing stuff from it and dumping that reencoded JSON [12:58] Ctrl-S: no [12:59] Ctrl-S: okay, so, according to the JSON spec, object keys are unordered - there is no guarantee that a parse and stringify will result in the same object key order [12:59] whereas arrays are ordered [12:59] *some* applications ignore this, and depend on object key order [12:59] so i'd only lose the ordering, not the keys themselves? [12:59] for those kind of applications, you need the original (string) data [12:59] correct [12:59] okay, that shouldn't be a problem [12:59] if you use a standard JSON implementation, always use JSONB [13:00] only use the JSON column type if you *explicitly* know that your data source is not spec-compliant [13:00] :) [13:00] this is Tumblr's API [13:00] (usually only a concern for embedded appliances) [13:00] okay [13:00] yeah, JSONB will be fine [13:00] any REST API can be assumed to be spec-compliant [13:00] this is basically for mirroring blogs from the API [13:07] thanks for the advice [13:52] *** primus104 has quit IRC (Leaving.) [14:04] *** mistym has joined #archiveteam-bs [14:18] *** mistym has quit IRC (Read error: Operation timed out) [14:50] *** mistym has joined #archiveteam-bs [14:50] *** kyan has quit IRC (Quit: This computer has gone to sleep) [14:51] *** kyan has joined #archiveteam-bs [14:51] *** kyan has quit IRC (Remote host closed the connection) [14:58] *** mistym has quit IRC (Remote host closed the connection) [15:14] *** mistym has joined #archiveteam-bs [15:46] *** kyan has joined #archiveteam-bs [16:16] *** mistym has quit IRC (Remote host closed the connection) [16:30] *** Start has quit IRC (Disconnected.) [16:36] *** mistym has joined #archiveteam-bs [16:52] *** SimpBrain has joined #archiveteam-bs [16:56] *** aaaaaaaaa has joined #archiveteam-bs [17:06] *** primus104 has joined #archiveteam-bs [17:19] does anyone know how to grab periscope videos? [17:31] *** primus104 has quit IRC (Leaving.) [17:32] *** kyan has quit IRC (Quit: This computer has gone to sleep) [17:52] *** SmileyG has quit IRC (http://www.milkme.co.uk - You'll never understand.) [17:53] *** Smiley has joined #archiveteam-bs [17:58] *** Smiley has quit IRC (Quit: http://www.milkme.co.uk - You'll never understand.) [18:03] *** Smiley has joined #archiveteam-bs [18:16] so looks like i can get c-span going back to 1990 [18:22] godane: i never used it but judging from view-source:https://www.periscope.tv/w/VyEDnzE4MDcxNjB8Nzc3MjA3OOdHsrJMxrZl32h2RBOIQLoFnJSrVSw6ddZKiQhQv02C it may be only accessible from the mobile app [18:23] generating urls is pointless since they're so long .. somehow i think google indexed them but they blocked the results [18:24] re internet speeds, my connection at work https://pbs.twimg.com/media/CDm1x02WoAE1MGF.png:orig [18:24] \o/ [18:27] wooo [18:29] schbirid: I give you this: https://files.app.net/jx7xnu037.png [18:29] (also work) [18:30] :D [18:30] it depends on server [18:30] we peer with level3 and cogent [18:31] level3 is great; cogent *sucks* [18:32] i should check a traceroute tomorrow [18:42] balrog: such redaction [18:43] joepie91: what, you don't like that I cut out my ISP? [18:43] or do you mean that it's not sufficient [18:50] :P [18:50] was joking [18:50] joepie91: well when your ISP and your employer are the one and the same ;-) [18:51] then redacting makes sense [18:52] heyyy balrog who's your isp [18:52] if you want to stay anon, sure [18:52] :p [18:52] *** kyan has joined #archiveteam-bs [18:54] xmc: hahahahaha [19:01] so i found a way to grab cspan old videos [19:02] example code for rtmpdump: rtmpdump -r "rtmp://s1g3v4ljhhuslz.cloudfront.net:1935/cfx/st/" -a "cfx/st" -y "mp4:trimmed/full/012/12001-1/12001-1-MP4-STD_01.mp4" -o 12001-1-MP4-STD_01.flv [19:02] yes i know i'm insane [19:03] we already knew that :P [19:03] thats good [19:10] *** insane_al has joined #archiveteam-bs [19:14] godane: nice :) [19:19] *** kyan has quit IRC (Quit: Leaving) [19:19] *** mistym has quit IRC (Remote host closed the connection) [19:20] *** primus104 has joined #archiveteam-bs [19:25] i'm checking 1979 c-span schedule dates to see if there are any videos [19:31] *** Start has joined #archiveteam-bs [19:33] *** mistym has joined #archiveteam-bs [19:38] how I hate rtmp, reminded me tha I have some rtmp work to do that i have been putting off [19:53] *** SN4T14_ has joined #archiveteam-bs [19:55] *** insane_al has quit IRC (Read error: Connection reset by peer) [19:57] *** insane_al has joined #archiveteam-bs [19:57] *** SN4T14__ has quit IRC (Ping timeout: 306 seconds) [20:01] *** godane has quit IRC (Ping timeout: 370 seconds) [20:05] Boop [20:05] ohai SketchCow [20:07] FOS is continuing efforts. Not having Halo for a few days will help. [20:11] *** insane_al has quit IRC (Remote host closed the connection) [20:12] *** Smiley has quit IRC (http://www.milkme.co.uk - You'll never understand.) [20:12] *** mistym has quit IRC (Remote host closed the connection) [20:19] godane: in regards to RTMP - one trick is to pretend to be a mobile device, more often than not an android phone will get an mp4 [20:19] *** Smiley has joined #archiveteam-bs [20:20] wacky: "hi, I'm an iPad" is one of my favourites :) [20:21] amen [20:22] *** Start has quit IRC (Disconnected.) [20:24] *** RichardG has quit IRC (Read error: Connection reset by peer) [20:29] *** RichardG has joined #archiveteam-bs [20:31] *** mistym has joined #archiveteam-bs [20:46] *** SimpBrain has quit IRC (Read error: Connection reset by peer) [20:48] *** SimpBrain has joined #archiveteam-bs [20:56] OK, I got a good one for you maniacs. [20:57] https://www.youtube.com/watch?v=-bW0v2F9Rgc [20:57] This is boss Brewster, and his entire talk is "how much can we push the limit to get stuff on archive.org" [20:57] It's quite amazing he gave this speech. It's 40 minutes plus 20 minutes of incredulous questions [20:58] *** BlueMaxim has joined #archiveteam-bs [21:00] SketchCow: of the "wait... you can do _do_ that?" type? [21:01] It's just a worthwhile hour [21:02] I know some of you look for talks by me to watch; this is the boss going full out [21:02] heh [21:02] * joepie91 notes [21:03] *** sankin has quit IRC (Leaving.) [21:06] SketchCow: that director is amazingly boring to listen to.. :/ [21:10] Suck it up [21:11] :P [21:16] https://www.youtube.com/watch?v=9D-QD_HIfjA music video featuring Brewster Kahle [21:17] now we're talking [21:21] *** torvik has quit IRC (Read error: Operation timed out) [21:26] *** primus104 has quit IRC (hub.se irc.efnet.pl) [21:26] *** schbirid has quit IRC (hub.se irc.efnet.pl) [21:26] *** RedType_ has quit IRC (hub.se irc.efnet.pl) [21:30] *** RedType has joined #archiveteam-bs [21:34] *** schbirid2 has joined #archiveteam-bs [21:43] *** primus104 has joined #archiveteam-bs [21:52] jesus christ on rollerskates https://twitter.com/frankcifaldi/status/593529947538337797 [21:55] *** RichardG_ has joined #archiveteam-bs [21:55] *** kvieta has quit IRC (Read error: Operation timed out) [21:55] *** eprillios has quit IRC (Read error: Operation timed out) [21:56] I really want those messages to look right in the window before it boots. [21:57] *** SimpBrain has quit IRC (Quit: Leaving) [21:57] *** espes__ has quit IRC (Read error: Operation timed out) [21:57] *** espes__ has joined #archiveteam-bs [21:57] *** Sk1d has quit IRC (Read error: Operation timed out) [21:57] *** Sk1d has joined #archiveteam-bs [21:58] *** eprillios has joined #archiveteam-bs [21:59] *** RichardG has quit IRC (Ping timeout: 606 seconds) [21:59] SketchCow: is there an ongoing effort for recording internet-streamed (regional) TV channels already? [22:04] *** brayden has quit IRC (Read error: Operation timed out) [22:08] *** fx_ has quit IRC (Read error: Connection reset by peer) [22:09] Not that I know. [22:09] *** goekesmi_ has joined #archiveteam-bs [22:10] *** goekesmi has quit IRC (Read error: Connection reset by peer) [22:12] *** kvieta has joined #archiveteam-bs [22:20] *** Rickster has quit IRC (Ping timeout: 606 seconds) [22:20] *** Rickster has joined #archiveteam-bs [22:26] *** godane has joined #archiveteam-bs [22:26] *** fx_ has joined #archiveteam-bs [22:30] wacky: what rtmp work do you have to do? [22:31] i maybe able to help [22:34] *** Start has joined #archiveteam-bs [23:12] *** serapeum has quit IRC (Remote host closed the connection) [23:12] *** serapeum has joined #archiveteam-bs