tmsr - Search: a

35100+ entries in 0.284s

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

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

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

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.

phf: asciilifeform: oh there's a type

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

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.

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.

mircea_popescu: but instead actually build the table you're trying to not-in, and do a join operation.

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

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

mircea_popescu: but anyway. if your proggy includes a db you will have to ~DESIGN~ for the db.

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

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: asciilifeform, build the actual table and do a join then.

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: 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.

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!)

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 .

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: really only interesting from a 'almost cheap enuff to throw away' in-print comp pov

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

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

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

mimisbrunnr: Logged on 2018-04-21 19:06 mats: can i get an invoice for 1 q of rockchip service, a tar of the image, and build instructions for that image?

deedbot: http://www.loper-os.org/?p=2295 << Loper OS - A Clean Gentoo for Rockchip.

a111: Logged on 2018-04-24 19:00 phf: it is otherwise a typical gaming protocol, a single header that wraps a range of message types. i don't quite remember but i think existing eulora protocol works somewhat like that, just a smaller number of message types.

phf: well, i'm still going to post a comment about it though on diana_coman's blog, this is more or less thoughts out loud.

phf: there's also parts in the spec that describe the format, and you can infer the behavior from the format, but there isn't explicit description of behavior. for example movement type a.5.23-a.5.28 is presumably for moving things and self around, but without further details it's hard to say how it's supposed to work. so i can't really say much about the internal consistency of the protocol, i.e. are the message types sufficient to perform some set of in g

phf: it is otherwise a typical gaming protocol, a single header that wraps a range of message types. i don't quite remember but i think existing eulora protocol works somewhat like that, just a smaller number of message types. ☟︎

phf: http://btcbase.org/log/2018-04-24#1805075 << i did a first pass on the spec over the weekend, but haven't had time to formulate my thoughts. it looks like enough to do a prototype short of three things: handshake process is still work in progress, i noticed that it's missing type of data descriptor values for 4.3.2 (there's a list of data types, but not the values that indicate which type it is), and there's no format description for the encapsulated f ☝︎

asciilifeform: and incidentally diana_coman if you still need a kernel config with iptables etc support -- also ping me

asciilifeform: ( if anybody has a similar problem, and wants to know how to properly tune ramdisk -- write in )

danielpbarron: https://youtu.be/dht_3NziwSw << a man alone

a111: Logged on 2018-04-22 17:52 mircea_popescu: meanwhile it's become a fixation in the children ; now merge it with the church of self esteem and its holy youcandoanything, and the REASON http://btcbase.org/log/2018-04-16#1800094 ie "smart kids" always being found with their pants down acting the "man alone" part and never learning anything from the experience is pretty fucking clear.

a111: Logged on 2018-04-16 16:19 mircea_popescu: man acting alone is stuck with these "oh, a conclave of idiots bent on self preservation and avoiding the lowly station their idiocy warrants them holds all the power, and i'll act as man alone confronted by governemnt".

asciilifeform: i find it hilarious how they carry on pretending that a crypto lib where ~some~ of the functions are (supposedly..) constant-time, is worth half a shit

asciilifeform: 'BN_gcd gets called to check that _e_ and _p-1_ are relatively prime. This function is not constant time, and leaks critical GCD state leading to information on _p_.' and a few moar.

asciilifeform: in other lullies, https://eprint.iacr.org/2018/367 >> 'Most of OpenSSL's constant-time code paths are driven by cryptosystem implementations enabling a dedicated flag at runtime. This process is perilous, with several examples emerging in the past few years of the flag either not being set or software defects directly mishandling the flag...' 'granularity issues due to word-size operands to the GCD function' etc

BingoBoingo: Anyways, I'd like to try sticking with Uruguay for at least a passportable length of time. Gotta move past the black mark of KYC

mircea_popescu: BingoBoingo, they have a point, at that.

asciilifeform: ( they did not give half a fuck re the 1u's, for instance )

asciilifeform: the observations from asciilifeform's voyage suggest that the UY customs folx don't actually give a shit about anything that doesn't look like it is new and sellable

BingoBoingo: Unlike the rest of the residency process mod6, if had with what to fill a container I would retain a profession for it.

mircea_popescu: anyway, for 50k or thereabouts worth of used goods you can expect to pay a few thousand to ship and maybe a grand or two in tax. something like that.

BingoBoingo: mod6: Depends. Uruagay has a process tied to Residency application which lets you bring one for customs free as long as it is your "household"

mircea_popescu: and obviously have a customs agent ready to release it for you.

mircea_popescu: mod6, traditionally, you rent a container.

BingoBoingo: <mod6> So here's a practical question that I struggle with... how am I going to get all of my gear to $country? << Container, slowboat

mod6: So here's a practical question that I struggle with... how am I going to get all of my gear to $country?

BingoBoingo: Uruguay the country continues growing on me as a base of operations. Uruguayos the people however suck.

mod6: I've been trying to figure out how to gtfo for some time now. And I'm not sure. Could be a few years yet.

asciilifeform: BingoBoingo is a very formidable advance-guard scout

mircea_popescu: asciilifeform, incidentally, do you see it as a mid term you use pizarro as your springboard to move in uy, releasing BingoBoingo into my hand for further adventures ? ☟︎

mod6: Christ on a cracker.

BingoBoingo: mod6: It is an accomodation open to the public. If I am not there actively enforcing the norms of civilization they will be swiftly forgotten or a german will try to overwrite them with pantsuit.

mod6: Ah. That kinda bites. So they reserve you "a spot", but not "the choice spot".

BingoBoingo: Habits die quickly. I might lose my hard won spot on the balcony where I can enjoy a gringo bubble in the evenings

BingoBoingo: mod6: In US-istani terms it isn't too expensive, but on current shoestring budget upfront costs of a flat are prohibitive

asciilifeform: and right nao he can't even decamp to , say, buenos aires for a few days, without losing his berth

mod6: ah. then we're not too far away from a real place to hang his hatt.

a111: Logged on 2018-04-24 14:59 BingoBoingo: mod6: Going fairly good. Alf's detarture has served to highlight the comparative inhumanity of the locals, but if alf can survive as long as he did in Mordor, I guess I am going to have to get used to life as a man without a physical country

asciilifeform: http://btcbase.org/log/2018-04-24#1805086 << once we get to troo +ev -- and iirc asciilifeform discussed this with BingoBoingo in BingoBoingostan -- oughta get a proper conspiratorial flat there, and then we can rotate ( say asciilifeform does a shift, BingoBoingo goes on shore leave ) ☝︎

deedbot: http://qntra.net/2018/04/microsoft-again-introduces-new-vulnerabilities-via-update-this-time-in-a-meltdown-patch/ << Qntra - Microsoft Again Introduces New Vulnerabilities Via Update: This Time In A "Meltdown" Patch

BingoBoingo: mod6: Going fairly good. Alf's detarture has served to highlight the comparative inhumanity of the locals, but if alf can survive as long as he did in Mordor, I guess I am going to have to get used to life as a man without a physical country ☟︎

a111: Logged on 2018-04-22 10:24 mircea_popescu: ben_vulpes, hey, can i get a shared acct for hosting minigame's files etc ?

a111: Logged on 2018-04-09 14:45 mircea_popescu: phf i guess next on your plate is make a prototype proper grapher for all time ? then mod6 can put that in v and avoid further such wtfs.

a111: Logged on 2018-04-24 02:52 trinque understands spyked to be working on a superior rsstron

spyked: http://btcbase.org/log/2018-04-24#1804959 <-- /me can confirm. I have a toy prototype, irc side is in process of consolidation; rss grabbing and parsing side (the cl-feed-parser thing) is kinda brittle and might have to be replaced. ☝︎

trinque understands spyked to be working on a superior rsstron ☟︎

trinque: the !!subscribe lever is detached, yes, since it used to run back to a pretty sad pile of duct tape. ☟︎

asciilifeform: after these get eaten, prolly will be ripe for a refresh of sks

asciilifeform: ... meanwhile i've resumed feeding the thing. we're on parcel #8 of the Framedragger set ( of a total of 13 ) .

asciilifeform: danielpbarron: my link to http://danielpbarron.com/2017/fucking-goats/ is a 404...

ben_vulpes: fg is a nice addition

asciilifeform: didn't occur to me for even a moment that it doesn't make a btree for all params!!

ben_vulpes: ah i actually had a conversation with a little lady about the 'dirty read' thing last night

asciilifeform: mircea_popescu: is there a working mpex url ? i am standing snsa www / phuctor up today

mircea_popescu: well wait a second, wtf fix is this, "you can either edit your files or have them served by apache but not both" ?!

diana_coman: I'm not sure how this will work if groupownership of file changes from apache to my user every time I modify a file

mircea_popescu: shit internal references broken also. diana_coman when you have a moment run a sed /minigame.bz/minigame.biz/ plox.

BingoBoingo: My bad, I forgot a line break answers now http://p.bvulpes.com/pastes/ME8bh/?raw=true

mircea_popescu: http://btcbase.org/log/2018-04-23#1804815 << in this particular case it's nothing but a filestore, mostly for things like ... o hey look lobbes , eulora log no-go. ☝︎

ben_vulpes: i'm all ears, i've erred to date on what i think is safer but i lack a model

deedbot: http://thetarpit.org/posts/y04/070-bucharest-botanical-garden.html << The Tar Pit - Bucharest botanical garden in the spring, as viewed through a couple of camera lenses

BingoBoingo: Aite, there is a zone on ns1.qntra.net and ns2.qntra.net for minigame.bz

mircea_popescu: they do not give a flying fuck over here, use 1/4 lb of fresh ground coffee for one cup, throw it away.

mod6: I saw on of your pictures (I think from a breakfast table), where it looked like there was a funnel/filter direct into the cup.

mod6: That'd be wonderful. I'd like to give real coffee a-go.

mircea_popescu: why don't you come over ? i'll buy you a bag.

mod6: The weather has finally turned here! A few nice spring days we've had, after 6 months of winter.

mircea_popescu: they still have to create a zone for you.

mircea_popescu: diana_coman, this usually goes the other way around : he tells you a ns, and i set the domain to point to it.

mircea_popescu: you already set a server for her yes ?

lobbes: I appreciate the suggested course correction earlier mircea_popescu. Now, after a week or so of toiling, I come out of the experience with more knowledge about V, sbcl, and postgres instead of painfully acquired trivia about dead-end things such as 'tcl' or the not-long-for-this-world gribble

lobbes: Once I migrate this to pizarro shell, I plan to harvest my notes for a detailed n00b guide on standing up a 'vanilla' logbot (with focus on operating out of /home for pizarro shellists)