| Time |
Nickname |
Message |
|
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
🔗
|
Ctrl-S |
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
🔗
|
xmc |
sha256? |
|
05:53
🔗
|
garyrh |
sha256 or even sha1 if you need something a bit speedier. |
|
05:54
🔗
|
Ctrl-S |
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
🔗
|
joeyh |
sha512 is faster on some hardware |
|
06:48
🔗
|
Ctrl-S |
how should i go about encoding the hash for a filename? |
|
06:49
🔗
|
Ctrl-S |
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
🔗
|
godane |
i'm starting to upload some twilight dvds |
|
12:22
🔗
|
|
S[h]O[r]T has joined #archiveteam-bs |
|
12:30
🔗
|
Ctrl-S |
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
🔗
|
ersi |
Nothing |
|
12:33
🔗
|
ersi |
Are you getting a SQL Error or just nothing? |
|
12:33
🔗
|
Ctrl-S |
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
🔗
|
ersi |
(I assume that you actually substitute %s to a string though) |
|
12:34
🔗
|
ersi |
Oh, you're using MariaDB |
|
12:34
🔗
|
Ctrl-S |
check_result = cursor.execute(check_query, sha512base64_hash), it's this library's way of passing them through |
|
12:34
🔗
|
Ctrl-S |
is that a problem? |
|
12:35
🔗
|
ersi |
You might want to stringify your string~ |
|
12:35
🔗
|
ersi |
WHERE shalololol = "%s" unless your framework does that for you |
|
12:35
🔗
|
Ctrl-S |
I believe that's what it does |
|
12:35
🔗
|
ersi |
Check that though |
|
12:36
🔗
|
Ctrl-S |
i think i copypasted that bit from the official docs |
|
12:36
🔗
|
ersi |
SELECT * FROM `Content` WHERE title = 'bombshells.mp4' ORDER BY id LIMIT 1; works in my MariaDB |
|
12:36
🔗
|
ersi |
and it's basically your query |
|
12:36
🔗
|
Ctrl-S |
it's this lib https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html |
|
12:36
🔗
|
ersi |
lol copypaste coding |
|
12:37
🔗
|
Ctrl-S |
if it's in the docs it's probably going to be the correct way to do it |
|
12:37
🔗
|
Ctrl-S |
also this is my second SQL project |
|
12:37
🔗
|
Ctrl-S |
writing a tumblr archiver |
|
12:37
🔗
|
Ctrl-S |
works is more important than works well |
|
12:37
🔗
|
ersi |
Well, you could at least terminate your query with ; |
|
12:38
🔗
|
Ctrl-S |
waitaminute |
|
12:39
🔗
|
|
S[h]O[r]T has quit IRC () |
|
12:39
🔗
|
ersi |
no |
|
12:39
🔗
|
Ctrl-S |
i'm not sure the table has all the fields in it |
|
12:39
🔗
|
ersi |
Please just fix this before you start fucking with the tables though |
|
12:39
🔗
|
ersi |
Add ; to the end of the query |
|
12:39
🔗
|
Ctrl-S |
i just tried that |
|
12:40
🔗
|
Ctrl-S |
"SELECT sha512base64_hash FROM (media) WHERE id = %s ORDER BY sha512base64_hash LIMIT 1;" |
|
12:41
🔗
|
ersi |
That's another query |
|
12:41
🔗
|
Ctrl-S |
i'm basically copypasting from one that i think is working |
|
12:41
🔗
|
ersi |
Yeah, I'll go do something worth while instead. |
|
12:41
🔗
|
Ctrl-S |
okay |
|
12:48
🔗
|
Ctrl-S |
sorry for being terrible at this |
|
12:49
🔗
|
|
S[h]O[r]T has joined #archiveteam-bs |
|
13:46
🔗
|
godane |
https://archive.org/details/dvdrom-twilight-053 |
|
14:27
🔗
|
|
primus104 has quit IRC (Leaving.) |
|
15:07
🔗
|
godane |
SketchCow: so what happened to that Jason Scott Speech at Long Now? |
|
15:07
🔗
|
godane |
the video of that is not posted yet from what i can tell |
|
15:21
🔗
|
SketchCow |
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
🔗
|
godane |
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
🔗
|
godane |
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
🔗
|
SketchCow |
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
🔗
|
godane |
ok |
|
16:53
🔗
|
godane |
i have slow lately |
|
16:53
🔗
|
SketchCow |
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
🔗
|
godane |
good thing i made logs when i started getting the kbs world english service |
|
17:31
🔗
|
godane |
turns out that 2004-07-15, 2004-10-16 and 2004-10-22 shows are incomplete |
|
17:32
🔗
|
godane |
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
🔗
|
schbirid |
Ctrl-S: go for postgresql while you are still fresh |
|
18:07
🔗
|
schbirid |
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
🔗
|
godane |
so looks glenn was at LAUNCH event SF |
|
18:45
🔗
|
godane |
he talked about mesh networks maybe taking down the NSA problem |
|
18:45
🔗
|
godane |
i was thinking of that for while now |
|
18:46
🔗
|
godane |
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
🔗
|
godane |
i'm grabbing the LAUNCH Festival |
|
18:58
🔗
|
godane |
its +7gb just for wednesday sessions |
|
19:55
🔗
|
fenn |
wifi can go 100km with 2 meter dishes on mountains |
|
19:56
🔗
|
fenn |
free space transmissions are probably even easier to intercept than wired transmissions |
|
19:58
🔗
|
xmc |
s/probably// |
|
19:59
🔗
|
fenn |
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
🔗
|
fenn |
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
🔗
|
garyrh |
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) |