Show Idle (>14 d.) Chans
← 2022-03-13 | 2022-03-15 → ↓
14:08 asciilifeform $ticker btc usd
14:08 busybot Current BTC price in USD: $38902.92
14:08 asciilifeform !w poll
14:08 watchglass Polling 15 nodes...
14:08 watchglass 205.134.172.26:8333 : Could not connect!
14:08 watchglass 205.134.172.6:8333 : (172-6.core.ai.net) Alive: (0.081s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=727311
14:08 watchglass 71.191.220.241:8333 : (pool-71-191-220-241.washdc.fios.verizon.net) Alive: (0.097s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311 (Operator: asciilifeform)
14:08 watchglass 205.134.172.27:8333 : Alive: (0.084s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311 (Operator: asciilifeform)
14:08 watchglass 54.39.156.171:8333 : (ns562940.ip-54-39-156.net) Alive: (0.172s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:08 watchglass 208.94.240.42:8333 : Alive: (0.083s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:08 watchglass 205.134.172.4:8333 : (172-4.core.ai.net) Alive: (0.150s) V=70001 (/therealbitcoin.org:0.7.0.1/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:08 watchglass 94.176.238.102:8333 : Could not connect!
14:08 watchglass 205.134.172.28:8333 : Alive: (0.083s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=727311 (Operator: whaack)
14:08 watchglass 54.38.94.63:8333 : (ns3140226.ip-54-38-94.eu) Alive: (0.262s) V=88888 (/therealbitcoin.org:0.8.88.88/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:08 watchglass 82.79.58.192:8333 : (static-82-79-58-192.rdsnet.ro) Alive: (0.382s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:09 watchglass 103.6.212.28:8333 : Alive: (0.550s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Return Addr=0.0.0.0:8333 Blocks=260011 (Operator: whaack)
14:09 watchglass 103.36.92.112:8333 : (terebe.ns01.net) Alive: (0.299s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727312
14:09 watchglass 75.106.222.93:8333 : Alive: (0.412s) V=99999 (/therealbitcoin.org:0.9.99.99/) Jumpers=0x1 (TRB-Compat.) Blocks=727311
14:10 watchglass 143.202.160.10:8333 : Busy? (No answer in 100 sec.)
~ 2 hours 18 minutes ~
16:28 PeterL I'm thinking I am going to stop scoopbot here and just have it reporting in #pest
↖
16:29 asciilifeform PeterL: ideally in both, but if impractical, better in #p
16:30 PeterL I guess I can leave it running here too for now
~ 1 hours 5 minutes ~
17:36 verisimilitude I found this, but still barely understand what it's trying to be: http://csr.bu.edu/rina/index.html
17:37 asciilifeform verisimilitude: loox like a rather snoarworthy academitardism in '90s style
17:37 asciilifeform verisimilitude: for a working/industrial example of subj, see e.g. erlang.
↖
17:37 dulapbot Logged on 2020-08-12 18:28:11 asciilifeform: edef: outta curiosity, are you familiar with 'erlang' and its 'mnesia' db ?
17:38 verisimilitude I'd not made that connection. I know an Erlang programmer who likes it.
17:39 asciilifeform afaik the only extant item which actually delivered on the 'transparent ipc' thing
17:39 asciilifeform and almost 3decade ago, at that
17:39 verisimilitude I found this RINA while reading someone involved with the Internet bemoan its broken nature.
17:39 verisimilitude Well, bemoaning.
17:40 asciilifeform verisimilitude: observe how 'bemoaners' ~never point to working examples from '70s-'90s, of ~anything
17:42 verisimilitude That's a very good point. I wasn't thinking of Chaosnet at all while reading about this.
17:43 verisimilitude I tried to download the source code for this RINA, but the page is a form for me to give them an e-mail address so they can send it manually.
17:43 asciilifeform verisimilitude: the 'why' is simple -- over8999 outta over9000 times the 'bemoaners' are pushing a bluehairism of some kind
17:44 asciilifeform verisimilitude: academitards ~never share working src. because typically there aint one (if there's anyffin resembling a proggy -- it's a pile of rigged demo bullshit which shits out the charts that go into the paper liquishit, rarely anyffin moar)
↖ ↖
17:49 asciilifeform verisimilitude: one could easily spend whole life digging in papers and failing to find ~any actually working examples of ~any of the claimed 'progresses'.
17:49 * asciilifeform almost did.
17:51 asciilifeform once you realize that academitards aint actually trying to 'move field forward', but rather carrying out a grotesque religious ritual -- very easy to stop.
17:53 asciilifeform consider how e.g. a catholic church aint a pub, even tho on sundays hands out a token qty of food and wine. similarly modern university aint a research org in any useful (to outsider) sense.
17:53 asciilifeform simply anuther kind of church , with over9000x moar funding
17:54 PeterL your field is messed up
17:55 asciilifeform PeterL: which 1 healthy ?
18:03 verisimilitude Finance is certainly healthy.
18:03 asciilifeform lol
18:03 signpost depends on what one considers the function of finance.
18:11 signpost https://www.tradingview.com/x/YnNRQAjE/ << picture of health, lol
18:14 asciilifeform from the pov of the perps -- for whom 'function' is 'keep the yachts afloat' -- never been healthier
↖ ↖
18:14 signpost dunno, I think we're approaching parasite-kills-host
18:15 signpost though perhaps best times for the parasite are just before this.
18:15 asciilifeform patient may have week to live, but if one asks the basketball-sized tumour -- 'a++ healthy'
18:15 signpost mhm
18:20 verisimilitude It sure would be nice to receive funding for research, though.
18:22 asciilifeform verisimilitude: it aint a 'fountain of dough' tho, but typically a rather abject kind of whoring
18:22 dulapbot Logged on 2022-03-10 12:24:59 asciilifeform: whaack: seems like crt was looking for 'magick fountain of dough' tho, rather than a salt mine job. much taller order.
18:23 verisimilitude Sure, but I mean the fountain of dough.
18:23 asciilifeform ( e.g. wage of tenured prof at asciilifeform's old uni, is approx same as of entry level grunt in typical salt mine)
18:24 verisimilitude I just remember being told ``Maybe you'll find a place to talk with other smart people like you.'' and responding ``That's what college was supposed to be.''.
18:24 asciilifeform lol
18:28 billymg !c net-summary
18:28 crawlerbot Bitcoin Network (IPv4 Nodes Active Within the Last 48 hours) Global: 8576; TRB-Compatible: 61; TRB: 14
18:28 crawlerbot TRB-Compatible by Country: United States: 23; Canada: 5; Singapore: 4; Romania: 4; South Africa: 3; Italy: 2; France: 2; Germany: 2; Russia: 2; Lithuania: 1; Norway: 1; Saudi Arabia: 1; Australia: 1; Chile: 1; Belgium: 1; Spain: 1; Ukraine: 1; Netherlands: 1; Bulgaria: 1; Mexico: 1; United Arab Emirates: 1; United Kingdom: 1; South Korea: 1;
18:28 crawlerbot TRB by Country: United States: 8; Canada: 1; Romania: 1; Singapore: 1; Lithuania: 1; France: 1; Norway: 1;
18:28 billymg i figured out the problem with the global count, and it pissed me off when i found out why the count was slowly increasing
18:29 asciilifeform billymg: noades w/ dynamic ip ?
18:29 billymg i set up a test script to run the query every 60 seconds, and it indeed would slowly drift higher from the true count
18:29 billymg asciilifeform: nope, i suspect something weird under the hood in psycopg2: http://paste.deedbot.org/?id=Lp4b
18:30 billymg that's my test script, i tried to mimic the relavent bits of the bot code as much as possible, that's why there's more there than needs to be
18:30 billymg but note the commented out version of the query vs the active one
18:30 asciilifeform hm if bug, not obv from the paste
18:30 billymg the commented out version is what i was doing previously, using postgres's 'now()'
18:31 billymg i was looking for nodes where difference between now and 'last_alive' was less than 48hrs (172800 seconds)
18:33 billymg i suspect that in psycopg2, or somewhere else, the 'now()' was getting cached
18:34 billymg that's the only conclusion i can draw from this test. because that query by itself in psql works fine every time
18:35 thimbronion I wonder if erlang would be a good lang in which to implement a pestron.
18:35 thimbronion totally forgot about it
18:36 signpost cool idea there might be IPC over pest between erlang instances
18:36 verisimilitude The Erlang programmer whom I know wasn't interested, but I can ask again.
18:37 signpost fuck buterin's world computer, you know?
18:37 asciilifeform thimbronion: traditionally erlang 'wins' for distributed processes / db; so not particularly, afaik. tho no reason wai not, if someone concretely an enthusiast of subj
18:37 * asciilifeform would rather see a clean commonlisp pestron, fwiw
18:37 verisimilitude Would a single-threaded Pest implementation work well?
18:38 asciilifeform verisimilitude: depends what means 'work well', if you can in fact handle your particular max line rate on 1 cpu, then sure
18:44 billymg !c net-summary
18:44 crawlerbot Bitcoin Network (IPv4 Nodes Active Within the Last 48 hours) Global: 8179; TRB-Compatible: 61; TRB: 14
18:44 crawlerbot TRB-Compatible by Country: United States: 23; Canada: 5; Singapore: 4; Romania: 4; South Africa: 3; Italy: 2; France: 2; Germany: 2; Russia: 2; Lithuania: 1; Norway: 1; Saudi Arabia: 1; Australia: 1; Chile: 1; Belgium: 1; Spain: 1; Ukraine: 1; Netherlands: 1; Bulgaria: 1; Mexico: 1; United Arab Emirates: 1; United Kingdom: 1; South Korea: 1;
18:44 crawlerbot TRB by Country: United States: 8; Canada: 1; Romania: 1; Singapore: 1; Lithuania: 1; France: 1; Norway: 1;
18:45 billymg anyway, fixed by working around what i suspect is a bug, or at least a malimplementation, in psycopg2
18:58 signpost billymg: multiple calls of now() in the same db transaction?
18:58 signpost those will indeed return the same value
18:59 billymg signpost: are they in the same transaction though?
18:59 verisimilitude s/will/should/
19:00 signpost billymg: don't recall what the default transaction behavior is with psycopg2
19:02 signpost the `with` statement starts one for you, commits at end of block
19:02 signpost iirc default is otherwise autocommit, so it'd be unexpected to get the same now() for different queries.
19:03 billymg signpost: you could be right about the open transaction thing, i'm looking at this now: https://www.psycopg.org/docs/faq.html#problems-with-transactions-handling
19:03 billymg i figured doing a cursor.close() in between queries would be enough, but maybe not
19:04 billymg also when i looked up the docs for 'commit' and 'rollback' it looked like those were for write operations (and i'm only doing a select)
19:05 signpost right, but if something's opening a transaction for you at the beginning in your actual bot code, could possibly cause this.
19:05 signpost you only really need to use explicit transactions when you need atomicity over multiple queries; otherwise you're just incurring additional overhead
19:07 billymg signpost: "explicit" meaning "discrete" or "manually opened/closed"?
19:07 signpost manual, as opposed to autocommit
19:10 billymg in this usecase it seems to me like i don't (shouldn't) need to manually manage transactions. i want a simple COUNT(*) of a table where entries meet a certain criteria
19:11 billymg i.e. when '!c net-summary' is run the results should be for that moment in time, having nothing to do with the last time it was run
19:12 billymg so i think you're saying i should be using 'autocommit'
19:12 billymg so that each time the query is run, it's in a new transaction
19:12 signpost yeah something to try
19:13 signpost (if I was wrong and the default isn't already autocommit)
19:13 billymg but that adds overhead, or no?
19:13 signpost nah, being in manual transactions when you don't need them does
19:13 billymg ah ok
19:13 signpost forces the database to keep forked worlds alive until the connected client does commit/rollback/disconnect
19:13 billymg yeah, possibly autocommit was not the default for me, given the behavior i was seeing with 'now()'
19:14 signpost ah dingdingding https://www.psycopg.org/docs/connection.html
19:15 signpost "By default, Psycopg opens a transaction before executing the first command: if commit() is not called, the effect of any data manipulation will be lost."
19:15 billymg yeah, here too: https://www.psycopg.org/docs/connection.html#connection.autocommit
19:15 signpost when I used this, it was as part of django for a big webturd. https://docs.djangoproject.com/en/4.0/topics/db/transactions/
19:16 signpost which was apparently changing the default behavior to autocommit
19:16 signpost so cool, that explains.
19:20 billymg sweet, re-running my test script with autocommit to confirm
19:20 billymg ty for the explanation
19:21 signpost np
← 2022-03-13 | 2022-03-15 → ↑

Random(asciilifeform) | Download hourly DB snapshot | Get Source Code

Theme: Light | Dark | System Default