a111: Logged on 2018-04-24 19:28 phf: diana_coman: is the protocol the entirety of documentation for client writers or there's more stuff in the pipeline?
a111: Logged on 2018-04-24 23:41 asciilifeform: mircea_popescu, diana_coman , et al, other folx who travel -- i'd like to get a picture of whether there is 'market' in l1/l2 for a pre-engentooated ( laugh at the laddel-ism, but it promises to be a somewhat painful process involving crocodile and eeprom writer ) 'c101pa' rockchip lappy .
mircea_popescu: i'd buy some, give the visiting sluts. sorta like the titbits thing.
mircea_popescu: atm i'm not really doing that ; but for more respectable cut of girlmeat there's ye olde ibms.
mircea_popescu: basically acquisition order would switch from "send plane ticket" to "send plane ticket + gpgstation".
mircea_popescu: extant item slated for replacement anyways, hence all the protocol talk.
mircea_popescu: BingoBoingo, amusingly, no further than today walking through town i was explaining to girl the source and meaning of pulgada
mircea_popescu: (as "that length of knife blade that hurts but doesn't seriously injure, obtained by holding the instrument a certain way so the thumb covers the blade". PRISON SLANG!)
BingoBoingo wonders what gabriel_laddel is up to, and how the foot is.
phf: with tmp as (select distinct unnest(mods) from factors) select * from moduli where idx not in tmp;
phf: oh i suppose with tmp as (select distinct unnest(mods) as mods from factors) select * from moduli where idx not in (select mods from tmp);
mircea_popescu: asciilifeform, build the actual table and do a join then.
mircea_popescu: you will soon discover your heavily recursive way of thinking is deeply inadequate for the strengths and useful work of a db ; which may explain why you've not been looking into them to this advanced age.
mircea_popescu: incidentally, the inept way in which postgress handles this case is why mysql still official db for mp-wp
mircea_popescu: but anyway. if your proggy includes a db you will have to ~DESIGN~ for the db.
phf: asciilifeform: other option is to do a left outer join, and then filter by nulls, but i'm trying to recreate the exercise at home so that we're not doing tedious roundtrip through irc
trinque: except operator might be faster than "not in"
mircea_popescu: no, that was his previous suggestion. what i mean by ACTUAL is that you don't use tmp
mircea_popescu: but instead actually build the table you're trying to not-in, and do a join operation.
mircea_popescu: yes dood, that's why i said what i said re your way of thinking.
mircea_popescu: a db is a good tool for pre-given solutions for some kinds of problems. it is not a tool for implementing arbitrary expressivity.
trinque: asciilifeform: what's the shape of *
phf: mircea_popescu: maybe try this with foo as (select distinct unnest(mods) as mod from factors) select * from moduli left outer join foo on module.idx = foo.mod where foo.mod is null;
mircea_popescu: phf, i expect it'll still re-calc the temp on every pass.
trinque: asciilifeform: what are the cols there that you want
mircea_popescu: that's the only available juice to squeeze there, communicate to the engine that your db is slow, the tmp doesn't move. and you do this by not making it a tmp.
trinque: lol yes, that's what star means
mircea_popescu: asciilifeform, incidentally, your joins are all indexed yes ?
phf: mircea_popescu: i'm not sure that the problem is the recalculate, i think the problem is actually not in in combination with temp calculate
mircea_popescu: phf, possibly, i'm not really THAT close to the core of that beast.
trinque: asciilifeform: you know of "explain" ?
phf: asciilifeform: oh there's a type
phf: with foo as (select distinct unnest(mods) as mod from factors) select * from moduli left outer join foo on moduli.idx = foo.mod where foo.mod is null;
mircea_popescu: asciilifeform, " select * from moduli where idx not in (select distinct unnest(mods) from factors)" << 1.make a new table ; 2.run "select distinct unnest(mods) from factors" and dump the result into this new table ; 3. index it by idx ; 4. run your select as an outer join between moduli and the new table.
trinque: I'm backing away. asking us to optimize a query in isolation for you without the explain and knowing nothing of your schema is ridiculous
phf: you can keep from writing to disk by doing a materialized view. do a materialized view for your temp query, and then run second query against it. that would be my last resort though
mircea_popescu: the only way out is if he ever gives up trying to ask sql for lisp support and instead writes his python around the sql like god meant it.
mircea_popescu: asciilifeform, dude. it's a tool. like a steamroller. it does the following thing well : if you have cans, it makes them flat.
trinque: nobody's here to defend sql to you, fucks sake
mircea_popescu: it does nothing else. it doesn't impress chicks, it doesnm't win speed contests, it's not a car.
trinque: you came in asking for help with the one you already stuck dick in.
mircea_popescu: just don't expect any backing to it for recursive elegance. it dun have what with.
phf: asciilifeform: is the original query faster than the most last rewrite? asking for personal enlightenment
phf: perhaps try select * from moduli left outer join (select distinct unnest(mods) as mod from factors) as foo on moduli.idx = foo.mod where foo.mod is null
phf: but there's only so few rabbis i can pull out of a hat
mircea_popescu: no, by all means, i like watching the "alf encounters technology" hour :D
phf: i treat the exercise as a chinese room wired to explosives. making a mistake elevates danger level, passage of time elevates danger level, there's a random factor when it's going to blow anyway, etc.
mod6: I am currently in the early stages of next steps; re-implementation within the existing framework. More to come on that front as I have updates.
phf: heh, main changes in recent versions of slime: additions of mezzano interaction (lisp "operating system"), but the lulzy part additions of large variety of deprecation errors and warnings.
☟︎ phf: ah apparently deprecation "framework" exists in sbcl since 1.0.50..
mircea_popescu: how exactly does this work, something can "deprecate" in lisp ?
phf: anything that's not covered by standard, but is available in the implementation, like threading
phf: though sbcl found a way to fuck with the standard do, using style warnings (ambiguity in the standard can be encouraged in a specific direction along the "mktemp is unsafe!1" lines)
trinque: mod6: I've got a sendrawtxn patch sitting over here
trinque: got one that rips out the noui.h idiocy too, and a few others that need finishing before I fork a walletless trb
trinque: (got the walletless patch too; trb node on pizarro is walletless)
trinque: I'm blocked on not having the manifest, so next on my plate is to regrind every patch with a manifest entry.
trinque: mod6: what was wrong with polarbeard's exactly? my patch is more or less his.
phf: trinque: there wasn't anything wrong with polarbeard's patches in general, he just happened to be doing his work when there was a lot of regrinds going on in the tree and after third time he was asked to regrind he decided he had enough and quit
☟︎ mod6: Yeah, nothing really wrong there I suppose, as stated, basically undertook the exercise as "educational". Just to see what could be done.
mod6: I've been working a bit further on my own, seeing how it could be done by what exists. I should look back at polarbeards stuff too.
mod6: but hey hey! trinque: if you're sitting on some patches for this, please send along when you get the manifest part working.
mod6: re: polarbeard is right, guy simply isn't in the wot (afaik), so partly, I'm trying to solution on my own without polluting my path too much.
mod6: bah. *re: polarbeard, phf is right...
mircea_popescu: he made one megapatch, people were like "yeah, nice, now split it out in bits" ; he tried but didn't find a ready way to do it and kinda went silent.
trinque: mod6: "patch exists" is no reason to not go exploring on your own
mod6: That said, it doesn't make a ton of sense to be off tilting at wind-mills if there are already reasonable solutions.
trinque: the wallet rm -rf is something of a megapatch, but at least mostly redlining.
mod6: So im trying to balance all that a bit.
trinque: I don't expect to make that one mainline "trb" though, unless somewhere down the line somebody also breaks off script.cpp into a tx compiler, breaks off a signer, etc
trinque will keep the spatchcocking to his own blog for now
mod6: sure, you're doing good work. looking forward to your submissions when ready.
phf: mircea_popescu: he had one megapatch that i remember being somewhat controversial, it's the one where he reworked the logging facility, but the other two look reasonably small (rm unused functions and add sendrawtransaction rpc). i remember there being some issues with asciilifeform_malleus_mikehearnificarum and asciilifeform-programmable-versionstring that required at least two regrinds, which was around the time he was working on his.
mircea_popescu: but in the general i suppose polarbeard's adventure is kinda illustrative of YET ANOTHER failure mode of personal heroics. besides the "lalala i can't hear" style there's apparently also the "oh, who has time for small steps, i'ma make huge contributions as a virtual unknown".
☟︎ mod6: <+trinque> mod6: I've got a sendrawtxn patch sitting over here << actually, i should mention that i /did/ create a trb sendrawtransaction (just this one rpc call) vpatch late last year, but never sent -- really wanted the rest of the gang 'create', 'sign', etc.
mircea_popescu: phf, a yeah, there was some of that too, it's coming back to me now.
trinque: mod6: yeah makes sense. not much use by itself without.
phf: yeah, it was a combination of factors. his logging facility patch received a lot of criticism, though i now regret voicing mine. it's a bit of a bike shed problem, everyone has their own idea of how to do it "right", but it's not done to this day.
mod6: phf: this is a solid point. I think everyone wants their own way of logging/logging statements.
mircea_popescu: goes right back to the problem of the unknown. i CAN shoot down bikeshedding if i know the person. i can't if they're unknown, because then it's legitimate part of dogs sniffing butts getting to know each other.
mod6: One vpatch that is looking pretty nice is ben_vulpes's logging sub-string chop chop.
mod6: mircea_popescu: yeah.
trinque: I forgot you had the wandering patches too.
mod6: thx for posting the links gentlemen.
phf: aha, it's either in experimental or in deprecated
trinque: long day, little sleep. spent the morning directing movers.
trinque: to digress, one of the guys called the porch a "pollo" and I swear he was fucking with me.
trinque: after that, he says his computer didn't work (hey, you're a computer guy, right?) and showed me a picture of a dell laptop docking station, so who knows. maybe he goes out and drinks beer on his chicken
phf: pivo and pollo mexican russian fusion food odessa, tx
☟︎ mircea_popescu: "Odessa is a city in western Texas. Downtown, Jack Ben Rabbit is an 8-foot-tall statue of a jackrabbit. "
mircea_popescu: if anything screams "deserted midwest" more than these "tall statue" shenanigans...
mircea_popescu: someone somewhere has like... a very large pitchfork or something. "town attraction" "why, because you folk spend too long in the sun ?"
☟︎ phf: well it's the world's LARGEST jackrabbit, so ya gotta see it!
mircea_popescu: kinda the same mental process that impels doods to save their largest booger.
mircea_popescu: "As in many municipalities, some of the largest employers are in the education, government, and healthcare industries."
mod6: I went through midland/odessa once, didn't stop. Kept foot on gas.
mod6: "This is the birthplace of First Lady Laura Bush!" ... zoooooom
mod6: That day I think I set a PR for furthest driven in one single day: OKC->Dallas->El Paso->Tucson
trinque: lots of oil out there; only real reason to go
mod6: yeah, i remember smelling it in the air.
a111: Logged on 2018-04-24 23:41 asciilifeform: mircea_popescu, diana_coman , et al, other folx who travel -- i'd like to get a picture of whether there is 'market' in l1/l2 for a pre-engentooated ( laugh at the laddel-ism, but it promises to be a somewhat painful process involving crocodile and eeprom writer ) 'c101pa' rockchip lappy .
a111: Logged on 2018-04-25 04:27 mircea_popescu: someone somewhere has like... a very large pitchfork or something. "town attraction" "why, because you folk spend too long in the sun ?"
spyked: the biggest win point is imho the chair they placed there: "please sir, to admire this fine fork"
lobbesbot: asciilifeform: The operation succeeded.
a111: Logged on 2018-04-25 03:53 phf: trinque: there wasn't anything wrong with polarbeard's patches in general, he just happened to be doing his work when there was a lot of regrinds going on in the tree and after third time he was asked to regrind he decided he had enough and quit
a111: Logged on 2018-04-25 04:01 mircea_popescu: but in the general i suppose polarbeard's adventure is kinda illustrative of YET ANOTHER failure mode of personal heroics. besides the "lalala i can't hear" style there's apparently also the "oh, who has time for small steps, i'ma make huge contributions as a virtual unknown".
a111: 2016-01-22 <polarbeard> hi
a111: Logged on 2018-04-25 03:25 phf: heh, main changes in recent versions of slime: additions of mezzano interaction (lisp "operating system"), but the lulzy part additions of large variety of deprecation errors and warnings.
a111: Logged on 2016-09-17 16:40 asciilifeform: and the hardware ~is~ shit. boot up one of these (if you can actually get it to boot.) and say hello to 1 fps graphics, disks without dma (you don't know what these feel like until trying personally), nic that works when the moon is full strictly, etc.
deedbot: trinax voiced for 30 minutes.
mircea_popescu: asciilifeform, sure it's worth doing at all. you need >1 per agent, what.
mircea_popescu: ahahaha this guy. "lawn colored bird" "rock colored bird".
BingoBoingo: mircea_popescu: Seriously, most hoppable fence of them all so far. Except well, Panama but they don't have a fence at all. Front door opens into the street.
phf: asciilifeform: i would be pleasantly surprised if the machine can have a blobless video/wifi
mircea_popescu: yes well, not everyone's an asshole. i don't recall the last time someone came up with the idea of assaulting ro embassies.
mod6: Nice pics BingoBoingo, funny comments too
phf: asciilifeform: aha, i figured as much, idle curiosity about where the hardware boundaries lie. we'll find out soon enough!
mircea_popescu: such a good thing five successive generations of nulands did in germany.
mircea_popescu: hey phf can i get a count of words / day in my loglines ?
trinque: ugh, shame on me. that was running in a tmux
trinque: massive uptime has its upsides and down
deedbot: beeteecee voiced for 30 minutes.