[00:20] *** RedType has quit IRC (Quit: leaving) [00:23] *** lytv has quit IRC (Ping timeout: 186 seconds) [00:23] *** Ravenloft has joined #archiveteam-bs [00:26] *** RedType has joined #archiveteam-bs [00:38] *** Start has joined #archiveteam-bs [00:59] *** primus has joined #archiveteam-bs [01:04] *** BlueMaxim has quit IRC (Read error: Operation timed out) [01:04] *** BlueMaxim has joined #archiveteam-bs [01:19] *** lytv has joined #archiveteam-bs [01:32] *** kyan_ has quit IRC (Read error: Operation timed out) [02:00] *** Start_ has joined #archiveteam-bs [02:00] *** Start has quit IRC (Read error: Connection reset by peer) [02:00] *** Start_ is now known as Start [02:03] *** lbft has joined #archiveteam-bs [02:06] *** primus104 has quit IRC (Leaving.) [02:15] *** lbft has quit IRC (Read error: Operation timed out) [02:28] *** lbft has joined #archiveteam-bs [02:32] *** mistym has joined #archiveteam-bs [02:45] *** Smiley has quit IRC (Read error: Connection reset by peer) [02:47] *** schbirid has quit IRC (Read error: Operation timed out) [02:47] *** DFJustin has quit IRC (Ping timeout: 258 seconds) [02:47] *** DFJustin has joined #archiveteam-bs [02:50] *** DopefishJ has joined #archiveteam-bs [02:50] *** swebb sets mode: +o DopefishJ [02:50] *** DFJustin has quit IRC (Client Quit) [02:50] *** DopefishJ is now known as DFJustin [02:50] *** bsmith093 has quit IRC (Ping timeout: 258 seconds) [02:51] *** zenguy_pc has quit IRC (Ping timeout: 258 seconds) [02:52] *** bsmith093 has joined #archiveteam-bs [02:52] *** zenguy_pc has joined #archiveteam-bs [02:53] *** Smiley has joined #archiveteam-bs [02:58] *** schbirid has joined #archiveteam-bs [02:59] *** Baljem has joined #archiveteam-bs [02:59] *** Baljem_ has quit IRC (Ping timeout: 258 seconds) [04:18] *** mistym has quit IRC (Remote host closed the connection) [04:32] *** Ravenloft has quit IRC (Ping timeout: 370 seconds) [04:45] *** mistym has joined #archiveteam-bs [05:16] *** schbirid has quit IRC (Read error: Operation timed out) [05:17] *** schbirid has joined #archiveteam-bs [05:29] *** BlueMaxim has quit IRC (Read error: Connection reset by peer) [05:45] can anyone here reccomend a hash function for file deduplication? I want to take the contents of an incoming file, hash it, check that against a database of hashes, and if it does not match save the file using the hash as a filename [05:51] sha256? [05:53] sha256 or even sha1 if you need something a bit speedier. [05:54] okay thanks [06:07] *** S[h]O[r]T has quit IRC (Read error: Operation timed out) [06:22] *** BlueMaxim has joined #archiveteam-bs [06:44] sha512 is faster on some hardware [06:48] how should i go about encoding the hash for a filename? [06:49] base36? [07:53] *** mistym has quit IRC (Remote host closed the connection) [07:58] *** dashcloud has quit IRC (Read error: Operation timed out) [08:01] *** dashcloud has joined #archiveteam-bs [08:22] *** dashcloud has quit IRC (Read error: Operation timed out) [08:30] *** dashcloud has joined #archiveteam-bs [08:53] *** midas1 is now known as midas [08:58] *** GLaDOS has quit IRC (Read error: Operation timed out) [09:39] *** SN4T14 has quit IRC (Quit: Leaving) [09:47] *** rejon has quit IRC (Ping timeout: 512 seconds) [09:54] *** rejon has joined #archiveteam-bs [10:10] *** primus104 has joined #archiveteam-bs [10:15] *** GLaDOS has joined #archiveteam-bs [10:24] *** GLaDOS has quit IRC (Ping timeout: 260 seconds) [10:27] *** GLaDOS has joined #archiveteam-bs [11:18] *** BlueMaxim has quit IRC (Quit: Leaving) [11:49] i'm starting to upload some twilight dvds [12:22] *** S[h]O[r]T has joined #archiveteam-bs [12:30] can anyone tell me what's wrong with this SQL statement? "SELECT * FROM `media` WHERE sha512base64_hash = %s ORDER BY version LIMIT 1" [12:33] Nothing [12:33] Are you getting a SQL Error or just nothing? [12:33] ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s ORDER BY version LIMIT 1' at line 1 [12:34] (I assume that you actually substitute %s to a string though) [12:34] Oh, you're using MariaDB [12:34] check_result = cursor.execute(check_query, sha512base64_hash), it's this library's way of passing them through [12:34] is that a problem? [12:35] You might want to stringify your string~ [12:35] WHERE shalololol = "%s" unless your framework does that for you [12:35] I believe that's what it does [12:35] Check that though [12:36] i think i copypasted that bit from the official docs [12:36] SELECT * FROM `Content` WHERE title = 'bombshells.mp4' ORDER BY id LIMIT 1; works in my MariaDB [12:36] and it's basically your query [12:36] it's this lib https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html [12:36] lol copypaste coding [12:37] if it's in the docs it's probably going to be the correct way to do it [12:37] also this is my second SQL project [12:37] writing a tumblr archiver [12:37] works is more important than works well [12:37] Well, you could at least terminate your query with ; [12:38] waitaminute [12:39] *** S[h]O[r]T has quit IRC () [12:39] no [12:39] i'm not sure the table has all the fields in it [12:39] Please just fix this before you start fucking with the tables though [12:39] Add ; to the end of the query [12:39] i just tried that [12:40] "SELECT sha512base64_hash FROM (media) WHERE id = %s ORDER BY sha512base64_hash LIMIT 1;" [12:41] That's another query [12:41] i'm basically copypasting from one that i think is working [12:41] Yeah, I'll go do something worth while instead. [12:41] okay [12:48] sorry for being terrible at this [12:49] *** S[h]O[r]T has joined #archiveteam-bs [13:46] https://archive.org/details/dvdrom-twilight-053 [14:27] *** primus104 has quit IRC (Leaving.) [15:07] SketchCow: so what happened to that Jason Scott Speech at Long Now? [15:07] the video of that is not posted yet from what i can tell [15:21] They will post it when they want to post it. Could be a while. [15:32] *** dashcloud has quit IRC (Read error: Operation timed out) [15:32] *** Start has quit IRC (Disconnected.) [15:38] *** dashcloud has joined #archiveteam-bs [15:43] ok [15:47] *** mistym has joined #archiveteam-bs [15:50] *** mistym has quit IRC (Remote host closed the connection) [16:02] *** Sanqui has quit IRC (Quit: .) [16:07] *** mistym has joined #archiveteam-bs [16:21] starting to upload the kbsworld (rki) audio english service: https://archive.org/details/kbsworld-rki-audio-english-service-2004-01-02 [16:21] *** primus104 has joined #archiveteam-bs [16:29] *** Sanqui has joined #archiveteam-bs [16:53] Thanks, godane. I'm just getting back into the swing. This is the week (after the weekend) of me going through your inbox again. [16:53] ok [16:53] i have slow lately [16:53] I know Kyan just left, but I'd like to get citation on "google selling public domain books" [16:54] *** SketchCow sets mode: +oooo antomatic Baljem bsmith093 Cameron_D [16:54] *** SketchCow sets mode: +oooo chfoo Coderjoe dcmorton dashcloud [16:54] *** SketchCow sets mode: +oooo Famicoman GLaDOS godane joepie91_ [16:54] *** SketchCow sets mode: +o joeyh [17:00] *** mistym has quit IRC (Remote host closed the connection) [17:28] *** Start has joined #archiveteam-bs [17:31] good thing i made logs when i started getting the kbs world english service [17:31] turns out that 2004-07-15, 2004-10-16 and 2004-10-22 shows are incomplete [17:32] i can scan whats incomplete by looking thur all logs for not have 'Everything' in them [17:43] *** mistym has joined #archiveteam-bs [17:46] *** Start has quit IRC (Disconnected.) [17:54] *** Start has joined #archiveteam-bs [18:06] *** Nertsy has quit IRC (Read error: Operation timed out) [18:07] Ctrl-S: go for postgresql while you are still fresh [18:07] it is so awesome [18:13] *** Nertsy has joined #archiveteam-bs [18:22] *** Nertsy has quit IRC (Read error: Connection reset by peer) [18:25] *** Nertsy has joined #archiveteam-bs [18:36] *** Nertsy has quit IRC (Read error: Connection reset by peer) [18:38] *** Nertsy has joined #archiveteam-bs [18:42] *** Start has quit IRC (Disconnected.) [18:44] so looks glenn was at LAUNCH event SF [18:45] he talked about mesh networks maybe taking down the NSA problem [18:45] i was thinking of that for while now [18:46] but i would think mesh network devices would have to be able to be in 5 to 20 miles range of broadcast to do it [18:48] *** mistym_ has joined #archiveteam-bs [18:57] *** mistym has quit IRC (Read error: Operation timed out) [18:58] *** sep332 has quit IRC (Read error: Connection reset by peer) [18:58] i'm grabbing the LAUNCH Festival [18:58] its +7gb just for wednesday sessions [19:55] wifi can go 100km with 2 meter dishes on mountains [19:56] free space transmissions are probably even easier to intercept than wired transmissions [19:58] s/probably// [19:59] it depends how collimated the beam is, how many side lobes, whether or not anyone would notice a huge dish marked "NSA" that suddenly appeared [19:59] but most "mesh network" proposals are omnidirectional transmitters [20:46] *** BlueMaxim has joined #archiveteam-bs [21:10] *** dashcloud has quit IRC (Read error: Operation timed out) [21:12] *** dashcloud has joined #archiveteam-bs [21:14] *** mistym_ has quit IRC (Remote host closed the connection) [21:22] *** dashcloud has quit IRC (Read error: Operation timed out) [21:25] *** dashcloud has joined #archiveteam-bs [21:47] https://antiboredom.github.io/audiogrep/ [21:48] *** dashcloud has quit IRC (Read error: Operation timed out) [21:52] *** dashcloud has joined #archiveteam-bs [21:58] *** mistym has joined #archiveteam-bs [22:24] *** mistym has quit IRC (Remote host closed the connection) [22:26] *** mistym has joined #archiveteam-bs [22:35] *** kyan has joined #archiveteam-bs [23:15] *** Start has joined #archiveteam-bs [23:29] *** Jonimus has quit IRC (Ping timeout: 370 seconds) [23:29] *** dashcloud has quit IRC (Read error: Operation timed out) [23:32] *** brayden has joined #archiveteam-bs [23:34] *** dashcloud has joined #archiveteam-bs [23:38] *** brayden_ has quit IRC (Read error: Operation timed out) [23:40] *** brayden_ has joined #archiveteam-bs [23:41] *** Jonimus has joined #archiveteam-bs [23:43] *** mistym_ has joined #archiveteam-bs [23:46] *** brayden has quit IRC (Read error: Operation timed out) [23:53] *** mistym has quit IRC (Ping timeout: 600 seconds) [23:59] *** dashcloud has quit IRC (Read error: Operation timed out)