37400+ entries in 0.013s
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.
mircea_popescu: ahahaha this guy. "lawn colored bird" "rock colored bird".
mircea_popescu: asciilifeform, sure it's worth doing at all. you need >1 per agent, what.
mircea_popescu: "As in many municipalities, some of the largest employers are in the education, government, and healthcare industries."
mircea_popescu: kinda the same mental process that impels doods to save their largest booger.
mircea_popescu: someone somewhere has like... a very large pitchfork or something. "town attraction" "why, because you folk spend too long in the sun ?"
☟︎ mircea_popescu: if anything screams "deserted midwest" more than these "tall statue" shenanigans...
mircea_popescu: "Odessa is a city in western Texas. Downtown, Jack Ben Rabbit is an 8-foot-tall statue of a jackrabbit. "
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.
mircea_popescu: phf, a yeah, there was some of that too, it's coming back to me now.
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".
☟︎ 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.
mircea_popescu: how exactly does this work, something can "deprecate" in lisp ?
mircea_popescu: no, by all means, i like watching the "alf encounters technology" hour :D
mircea_popescu: just don't expect any backing to it for recursive elegance. it dun have what with.
mircea_popescu: it does nothing else. it doesn't impress chicks, it doesnm't win speed contests, it's not a car.
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.
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, " 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.
mircea_popescu: phf, possibly, i'm not really THAT close to the core of that beast.
mircea_popescu: asciilifeform, incidentally, your joins are all indexed yes ?
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: phf, i expect it'll still re-calc the temp on every pass.
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: yes dood, that's why i said what i said re your way of thinking.
mircea_popescu: but instead actually build the table you're trying to not-in, and do a join operation.
mircea_popescu: no, that was his previous suggestion. what i mean by ACTUAL is that you don't use tmp
mircea_popescu: but anyway. if your proggy includes a db you will have to ~DESIGN~ for the db.
mircea_popescu: incidentally, the inept way in which postgress handles this case is why mysql still official db for mp-wp
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.
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!)
mircea_popescu: BingoBoingo, amusingly, no further than today walking through town i was explaining to girl the source and meaning of pulgada
mircea_popescu: extant item slated for replacement anyways, hence all the protocol talk.
mircea_popescu: basically acquisition order would switch from "send plane ticket" to "send plane ticket + gpgstation".
mircea_popescu: atm i'm not really doing that ; but for more respectable cut of girlmeat there's ye olde ibms.
mircea_popescu: i'd buy some, give the visiting sluts. sorta like the titbits thing.
mircea_popescu: and evidently the empire of idiots is aware of this, hence the spaghetti bowl of just-so lenthy strands of nonsense composing "contemporary culture" ie pantsuit nonsense.
mircea_popescu: anyway, maybe not the best word for it. but the idea is that the wotless individual finds himself very vulnerable strategically : the enemy doesn't need to make sense, just needs to make LONG enough strings of nonsense.
mircea_popescu: basically, people whose heads work have the "choice" such as it is : republic, or man-alone.
mircea_popescu: they're there to prevent trade, not specifically hinder migration.
mircea_popescu: obviously won't apply to your collection of priceless ming vases and so on.
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.
mircea_popescu: asciilifeform, traditionally custom bills tend to average to about 50% of the shipping costs, in my experience / ppl i know about
mircea_popescu: and obviously have a customs agent ready to release it for you.
mircea_popescu: asciilifeform, oh and you should see bogota polution. holy hell, SMOG. like 1980s chicago or LA!
mircea_popescu: asciilifeform, lots and LOTS of german cuckbois do the whole travel bit with some woman they picked off the whatever-website-for-travelingcuckbois whom they'll respect very much etc.
mircea_popescu: asciilifeform, shared sales are what make or break you this year. there's large margin there.
mircea_popescu: the question is, how long are YOU going to sit tied to the snows of central mid center mod6
mircea_popescu: i was mildly thinking cinematic production company, actually.