asciilifeform: $ticker btc usd
busybot: Current BTC price in USD: $39226.49
asciilifeform: !w poll
watchglass: Polling 15 nodes...
watchglass: 54.39.156.171:8333 : (ns562940.ip-54-39-156.net) Alive: (0.111s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 71.191.220.241:8333 : (pool-71-191-220-241.washdc.fios.verizon.net) Alive: (0.094s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757 (Operator: asciilifeform)
watchglass: 205.134.172.6:8333 : (172-6.core.ai.net) Alive: (0.142s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=733757
watchglass: 205.134.172.27:8333 : Alive: (0.146s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757 (Operator: asciilifeform)
watchglass: 205.134.172.26:8333 : Alive: (0.134s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=733757
watchglass: 208.94.240.42:8333 : Alive: (0.143s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 205.134.172.28:8333 : Alive: (0.272s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=733757 (Operator: whaack)
watchglass: 54.38.94.63:8333 : (ns3140226.ip-54-38-94.eu) Alive: (0.255s) V=88888 (/therealbitcoin.org:0.8.88.88/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 94.176.238.102:8333 : (2ppf.s.time4vps.cloud) Alive: (0.315s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733265
watchglass: 82.79.58.192:8333 : (static-82-79-58-192.rdsnet.ro) Alive: (0.393s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 205.134.172.4:8333 : (172-4.core.ai.net) Alive: (0.732s) V=70001 (/therealbitcoin.org:0.7.0.1/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 103.36.92.112:8333 : (terebe.ns01.net) Alive: (0.589s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=733757
watchglass: 103.6.212.28:8333 : Alive: (0.331s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=502788 (Operator: whaack)
watchglass: 143.202.160.10:8333 : Busy? (No answer in 100 sec.)
watchglass: 75.106.222.93:8333 : Busy? (No answer in 100 sec.)
asciilifeform: !q seen-anywhere BingoBoingo
dulapbot: BingoBoingo last seen in #asciilifeform on 2022-02-28 12:49:43: In the past month US down ~19% versus Brasil's Real, 5.3% versus Peso Uruguay
asciilifeform: BingoBoingo: if you dun intend to renew your subscription, plox to gpggram re: snailmail addr for return of yer colo machine.
dulapbot: Logged on 2022-04-06 10:24:12 asciilifeform: BingoBoingo: yer subscription expired apr. 3. do you intend to renew ?
billymg: asciilifeform: do you happen to know if that's the box BingoBoingo is using as the 'piz lifeboat'? if so my blog's still hosted on that
asciilifeform: billymg: not afaik. (tho you oughta be able to see if yer blog www lives in asciilifeform's ip block)
billymg: ah, right, looks like no 192.187.114.50
asciilifeform: iirc 'lifeboat' was a leased box operated by BingoBoingo pro bono
billymg: yep, the same one
asciilifeform: ( and pre-dates asciilifeform's rack )
asciilifeform: apparently serves BingoBoingo's www to this day
billymg: !. uptime
bitbot: billymg: time since my last reconnect : 87d 12h 20m
billymg: !. version
bitbot: I am bot version 719639.
billymg: !. uptime
bitbot: billymg: time since my last reconnect : 0d 0h 0m
billymg: !. version
bitbot: I am bot version 733831.
billymg: http://logs.bitdash.io/asciilifeform/2022-04-27#1099323 << not bad, seems like my db issues from before finally went away
bitbot: Logged on 2022-04-27 18:13:08 bitbot: billymg: time since my last reconnect : 87d 12h 20m
bitbot: Logged on 2022-04-14 15:32:43 asciilifeform: prolly oughta make it bidirectional. has been on pheature wishlist for aeons
bitbot: Logged on 2022-04-14 15:30:40 signpost: [40%][https://www.census.gov/quickfacts/fact/table/TX/RHI725220#RHI725220] of texas is hispanic.
asciilifeform: hmm, odd, loox outta order
bitbot: (pest) 2022-04-27 bitbot: I am bot version 733831.
asciilifeform: billymg: only worx w/ own links ?
bitbot: Logged on 2022-04-01 01:54:08 asciilifeform: (nao erry 2bit fishwrap embeds MB of font, lol)
asciilifeform: billymg: the 'x minutes' indicator is nifty
billymg: asciilifeform: which, the backlinks?
asciilifeform: billymg: right, loox like they only work w/ bitdash links ?
billymg: oh, no, the backfill script is currently churning through the historical logs
asciilifeform: a hm
dulapbot: Logged on 2022-04-27 14:19:59 asciilifeform: billymg: right, loox like they only work w/ bitdash links ?
asciilifeform: indeed no backlink there
billymg: aha, yeah, forgot that piece with the bot
billymg: lol backfill will catch it by the time it gets there
asciilifeform: a ok
billymg: but yeah, i need to fix that
billymg: in the bot
billymg: http://logs.bitdash.io/asciilifeform/2022-04-27#1099340 << ty, right now it's a constant set at 15 min threshold but should probably be a config knob
bitbot: Logged on 2022-04-27 18:20:05 asciilifeform: billymg: the 'x minutes' indicator is nifty
billymg: asciilifeform: ok backfill finished, but didn't get the last few lines, but see e.g. http://logs.bitdash.io/trilema/2016-12-21#1587491
bitbot: (trilema) 2016-12-21 asciilifeform: 'MINE -- WORX!111'
billymg: the first backlink is from a dulap ref
asciilifeform: seems to work. neato
billymg: asciilifeform: here's the backfill script: http://paste.deedbot.org/?id=vC4E
billymg: takes 190 seconds to run on two of my laptops (not even that high powered), but 1205 seconds on my rk
asciilifeform: notbad
billymg: i wanted to include ossasepia links too, but out of sync
billymg: i also added a knob to the config that looks like "other_loggers = logs.nosuchlabs.com/log" and takes a comma-delimited list of other active logotron-based loggers
billymg: to enable the link tunneling feature you built for the era1 and era2 loggers
billymg: asciilifeform: i'm gonna also do a light theme, perhaps after you see that variation you'll want to use it on your www
asciilifeform: possibly. tho would rather not have the font load thing
billymg: that's optional, there are fallbacks specified
asciilifeform: aok
asciilifeform: wb whaack
whaack: asciilifeform: ty
whaack: billymg: nifty new logs
billymg: ty whaack, wb
signpost: nice billymg. would be interesting to do something like this with the cross-reference data sometime
billymg: signpost: that's a nice visualization, i've been meaning to start experimenting with d3 (would rather use that than tableau)
whaack: billymg: bitdash seems to take a while to load when i click any link (it's always been slow) are you sure that it's the db lookup that's eating the time, and not that you're loading a new python environment every page view?
billymg: whaack: it now takes extra slow when clicking a dulap link because it's doing two redirects
billymg: i might have to disable that for now until i move it to faster hardware
billymg: takes extra long*
billymg: whaack: do logs.bitdash.io links also seem slower than before?
billymg: i really think i just need to get it on a faster box regardless
billymg: asciilifeform: do you have anything available atm?
whaack: billymg: idk about slower than before, but it's more noticeable with the new backlink feature
billymg: the backlink feature does add one extra sql query to each load
whaack: oh wow the new dashboard looks real nice as well, just seeing that now
billymg: ah thanks
signpost: if the db's postgres, turning on pg_stat_statements might be helpful
billymg: yeah the crawler www is on ec2 now, the rk couldn't handle all the work done for the homepage
signpost uses that often when diagnosing slow queries
billymg: signpost: ok, some quick testing with the queries: the query to get the lines for one day takes about 6ms on both my laptop and the rk. the query to get the backlinks for one day takes 133ms on my laptop and 600ms on the rk
billymg: so that's the culprit, i will see if adding an index on the backlinks field helps (doesn't currently have one)
billymg: well, unfortunately not solved with the index
signpost: might need to see what `explain analyze` tells ya on the query to figure out whether the query's using the index you created
billymg: aha
billymg: fixed it
signpost: cool!
billymg: it needed an index on the serial id
signpost: yeah seems zippy now, wd
billymg: the query (with sample values) looks like: SELECT * FROM loglines WHERE ser IN (SELECT unnest(backlinks) FROM loglines WHERE chan='asciilifeform' AND t BETWEEN '2022-04-26' AND '2022-04-27');
billymg: so in that subtable creation it's looking up by 'ser', but there was no index on that
billymg: err, not in the subtable, in the main select
billymg: anyway it brought it down from 600ms to around 4-6ms like the other query
phf: billymg: solid
billymg: phf: ty
billymg: phf: i actually never noticed the 'title' attributes on the backlinks in btcbase.org until cribbing from it while working on this version, thought it was a nice touch