asciilifeform: !#born polarbeard

asciilifeform: http://btcbase.org/log/2018-04-25#1805447 << exactly that. iirc he said nothing at all re own biography, on top of it all. ☝︎

asciilifeform: and gotta narrowly focus on subject, rather than 'hey look i turned 17 knobs at once'

asciilifeform: he didn't seem to grasp the notion that the patches are meant to be read and understood.

asciilifeform: http://btcbase.org/log/2018-04-25#1805426 << not quite how i remember it. d00d was demonstrably inadherent to the concept of vpatch hygiene , persisted with creation of shithub-style megaturds ☝︎

asciilifeform: ( possibly also it is better to have folx purchase the raw material locally, and flash the rom themselves ? )

asciilifeform: original q was 'is this worth doing at all'

asciilifeform: http://btcbase.org/log/2018-04-25#1805494 << i can't picture who ( other than mircea_popescu in his described possible use case ) would need more than 1 ( or perhaps 2, 1 as a spare ) ☝︎

asciilifeform: http://btcbase.org/log/2018-04-25#1805475 << lol somehow nobody but me noticed the bug. i fixed it this morning, all that remains is to clean the crapola from the db, will do this after backup ☝︎☟︎

asciilifeform: !Q later tell spyked http://www.loper-os.org/?p=2295&cpage=1#comment-19403 ☟︎

asciilifeform: lol

asciilifeform: ty phf , trinque , mircea_popescu

asciilifeform found , seems , a working formulation, set up experiment...

asciilifeform: amazing, how many old rusty razors this steamroller has randomly glued to the controls, to the seat, to the floor...

asciilifeform: ah what i needed was 'select mod from ...' and so ends up with 'column reference 'mod' is ambiguous'

asciilifeform: ikr!

asciilifeform: ( where it returns nil )

asciilifeform: interestingly, phf's algo worx from cmdline but not from PQexec("....")

asciilifeform: ty phf !

asciilifeform: nao all i gotta do is find out why...

asciilifeform: oh hey, phf's algo appears to work

asciilifeform: mircea_popescu: if not too many cans, and compass points in just the right direction and planets aligned...

asciilifeform: mircea_popescu: this'd be in the actual cruncher, a c proggy

asciilifeform: because it looks like sql is simply a 1970s ms winblowz, infinite font of unspeakable horror

asciilifeform: trinque: i'ma stop polluting, at this point, the logs, and solve the problem programmatically outside of the abjectly retarded sqltron

asciilifeform: entirely sinks the thing.

asciilifeform: i do. not. want. to. write. to. disk.

asciilifeform sets stopwatch...

asciilifeform: ( naturally there are more results, by factor of 1,000 , in the 'not in ....', but outputting all 9+ mil mods from db without ~any~ filtration, takes about 7min )

asciilifeform: mircea_popescu: yes

asciilifeform: i still don't grasp why the everliving fuck a 'not in ...' should be any slower than an 'in ....'

asciilifeform: trinque: all of them.

asciilifeform: phf: eggog, missing FROM-clause entry for table "module" LINE 1: ...tors) select * from moduli left outer join foo on module.idx...

asciilifeform: trinque: what do you mean 'shape of'

asciilifeform: ( reasonably cost being, 0 writes )

asciilifeform: what am i missing, does mircea_popescu know of another way of thinking, that actually solves the problem with the available tooling at reasonable cost ?

asciilifeform: this is ruinously expensive when the dataset is 10s of GB.

asciilifeform: ( 'build the table and do join' )

asciilifeform: mircea_popescu: i thought your algo involved a temporary table

asciilifeform rereads log, possibly missed sumthing

asciilifeform: trinque, mircea_popescu : how would this look in the given item ?

asciilifeform: so far errything i tried, gives same result ( query that promises to run in months, rather than the allotted ~halfhr)

asciilifeform: this was the q to begin with

asciilifeform: how wouldja unroll this ?

asciilifeform: mircea_popescu: right, it is designed for ( what i know of ) the db, and thereby lacks many knobs that i'd dearly like to have

asciilifeform: phf your query's been running since you gave it to me, but produced sadly 0 output

asciilifeform: ( and if it were to finally rewrite it, i'd ditch sqlism forever and entirely, like a bad dream )

asciilifeform: sadly my whole orchestra is firmly cemented into postgres..

asciilifeform: nifty.

asciilifeform: mircea_popescu: does 'in ...' run at same speed as 'not in ...' in mysql ?

asciilifeform: implementing sqltrons

asciilifeform: i.e. idiocy that is not in any way implicit in the mathematical structure of the underlying primitives (e.g. btree) but comes from agglomeration of programmers dropped as children

asciilifeform: mircea_popescu: actually 'looked in' plenty, and always run into this nonsense

asciilifeform: needs to run in-place.

asciilifeform: mircea_popescu: ludicrously slow

asciilifeform: lit suggests that 'not in' operation in postgres is pathologically slow

asciilifeform: phf: looks like STILL geological

asciilifeform: i suspect this dunwork on postgres ?

asciilifeform: LINE 1: ...ds) from factors) select * from moduli where idx not in tmp;

asciilifeform: ERROR: syntax error at or near "tmp"

asciilifeform: eggog

asciilifeform goes to try this..

asciilifeform: for completeness of picture, 'mods' is a column in factors, which contains indices of moduli (in 'moduli' table) that said factor is a factor of.

asciilifeform: ( all i want above, is to produce a select of all unphuctored moduli. )

asciilifeform: blew hours on this, with no result.

asciilifeform: is it possible to rewrite this so that postgres doesn't do the retarded thing that it evidently does ( this being, to compute the mods in the () , again and again FOR EVERY ROW in moduli )

asciilifeform: i have a proggy which wants to select * from moduli where idx not in (select distinct unnest(mods) from factors) ; but this runs in geological time. for no afaik good reason.

asciilifeform: i have a puzzler.

asciilifeform: hey trinque -- or other serious sqlist -- around ?

asciilifeform: painfully small display, tho, at least for grown man's eyes

asciilifeform: ( believe or not, thing seems to contain some sort of 3d gpu )

asciilifeform: in principle you could, then, put even eulora, on the c101.

asciilifeform: ( not suggesting to put ~server~ on arm, lol )

asciilifeform: aha

asciilifeform: mircea_popescu: does eulora run on arm64 ? ( or, perhaps better q, does it contain any gnarly x86-specific asm )

asciilifeform: ( webcam built into lid )

asciilifeform: there is afaik no adult rng on board ( in what, exactly, is there one ? ) but it has usb socket for FG; and the typical shit webcam for gurl-powered rng in principle.

asciilifeform: ( picture, 6-core arm64 )

asciilifeform: theoretically has moar horse than asciilifeform's beloved x60 , even

asciilifeform: thing has all of the (few) virtues of the crapple (e.g. 9 hrs on battery, 16 days of suspend , charge from usb ) , and , in principle, none of the barfology

asciilifeform: better gift than crapple, verily

asciilifeform: ( i saw'em at civilian electronics stores over here )

asciilifeform: and made in , seems, gigantic numbers

asciilifeform: mircea_popescu: it's starvation-cheap. sorta the appeal. 1 to 2 hundy usd

asciilifeform: iirc same vendor also sells a slightly larger comp, a 'c201pa' iirc.

asciilifeform: would need a few additional massages for video card and nic. but otherwise ready to eat.

asciilifeform: in principle, the gentoo i posted earlier, oughta boot on these.

asciilifeform: well, that and the (theoretical) possibility of 100% turdless operation.

asciilifeform: really only interesting from a 'almost cheap enuff to throw away' in-print comp pov

asciilifeform: there's a u-sd socket tho.

asciilifeform: soldered

asciilifeform: ( ^ see also. tldr -- vendor sells these as a kind of nintendo, https://archive.li/zTEkd , with google crapola on the flash )

asciilifeform: !#s c101pa

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 . ☟︎☟︎

asciilifeform: loox like... half of the pilot plant, is occupied nao

asciilifeform: oh hey hey

asciilifeform: !Q later tell mats http://logs.bvulpes.com/pizarro?d=2018-4-21#342015 <<<< >>>> http://www.loper-os.org/?p=2295

asciilifeform: grr

asciilifeform: !!later tell mats http://logs.bvulpes.com/pizarro?d=2018-4-21#342015 <<<< >>>> http://www.loper-os.org/?p=2295

asciilifeform: aa ok