log☇︎
▁▁▁▁▁▁▁▁⏐︎ 8241
asciilifeform: ok...
mircea_popescu: perelman says so!
trinque: dunno what's hard about the notion that look, you do not get computers until you have both the leadership category and engineering category maxed on your character
asciilifeform currently brain-melting over the total and airtight lack of any public data re beta-luminescence of lanthanide-strontium aluminate vs metal-doped zinc sulphide
trinque: and that the folks that "tried" in the first round lost because of deficiency of character
asciilifeform: *lanthanide-doped
asciilifeform: i've been looking for weeks. 0 result.
asciilifeform: trinque: one possibility was 'too many chiefs, not enough indians' (tm)
asciilifeform: which is sorta opposite, as i understand, to your hypothesis
mircea_popescu: i didn't perceive this cheifdom in the chief characters. mebbe my antennae too blunt, but who ? how ?
asciilifeform: self-perceived, this chiefdom.
asciilifeform: greenblatt thought he could lead. etc
mircea_popescu: but he was more or less irrelevant. moon, knight etc.
mircea_popescu: anyway, imo the principal point of the discussion is that knowledge, any knowledge, enacts a partition upon the world. this is the only difference - chucka and man are distinguished not by skin color, not by anything else but the overpowering fact that chuka doesn't know what to do with the rtg ; or with pushkin ; or with etcetera.
mircea_popescu: disconsidering this fundamental in any manner opens the chasm of hell, in all its presentation from evil to insanity.
asciilifeform: so far i follow the logic..
phf: chukcha brings his novel to a su publishing dept. the editor reads it and goes "you know, you ought to read some classics, pushkin, turgenev, etc." chukcha goes "naw, chukcha is a writer, not a reader"
mircea_popescu: aha
mircea_popescu: asciilifeform there's realy no more to it. ☟︎
mircea_popescu: but as a side point : i went to town yest, bought jug of milk. guy kept trying to warn me it's not milk! i bought it anyway. it is FABULOUS buttermilk. best i ever had. also got a strong sheep cheese and a mellower one. i am happy like i've not been in a long time - finally, food! like god at home made it! ☟︎
mircea_popescu: long have i sought the native foods of my land, and never have i found them before,
mircea_popescu: UNTIL I HAD THE FUCKING SENSE TO GO ON A HILL.
mircea_popescu: i tell you people - do not live with the plainsdwellers, for they are retarded and eat shit.
asciilifeform: mircea_popescu did not encounter all of this on his last run of CR ?
mircea_popescu: that was 10 years ago.
asciilifeform: they had not yet learned to make cheese then ?
mircea_popescu: i evidently wasn't in the right place.
asciilifeform: iirc mircea_popescu was by the sea then
mircea_popescu: in fairness, i also wasn't nearly as much of a lord a decade ago.
shinohai: http://btcbase.org/log/2017-04-10#1641243 <<< Hope it was much better cheese than the floating in ice, triple-wrapped variety from a few days previous. ☝︎
a111: Logged on 2017-04-10 01:05 mircea_popescu: but as a side point : i went to town yest, bought jug of milk. guy kept trying to warn me it's not milk! i bought it anyway. it is FABULOUS buttermilk. best i ever had. also got a strong sheep cheese and a mellower one. i am happy like i've not been in a long time - finally, food! like god at home made it!
mircea_popescu: anyway, today watched sunset by the pool, with dog and woman. dog is a friendly pitbull, woman has nice tits. there could be worse fates.
mircea_popescu: shinohai much better.
mircea_popescu: asciilifeform cheese, in fairness, is very much like dealing with fromphuctors. gotta have lots of patience for duds.
shinohai: Cheese is art.
asciilifeform: now this, is so.
asciilifeform spends moar on cheese than typical homo redditicus does on rent. with quite variable results, in these savage lands.
phf: there's a benedictine monastery in bangalore where make italian style cheese. considering how bad cheese is otherwise in the country, i'm contemplating making a pilgrimage to bangalore just to see how they do, next time i'm there
shinohai: I have no nearby monasteries unfortunately .... there is a farm in this little place called Ellijay nearby that makes decent goat cheese.
shinohai mmmmm, chèvre
BingoBoingo: From here good cheese involves inconvenient drive to Wisconsin
mircea_popescu is more than willing to share his dollar-a-lb bounty with l1 all-comers. i also made myself fruit salad out of [actually ripe] mango, [actually ripe] pineapple, [actually ripe] banmanas, drenched in fresh oj etc. ☟︎
mircea_popescu: gallon bowl, went in one evening.
shinohai: You can always opt for the other udder cheese in your neck of the woods, BingoBoingo
BingoBoingo however has planted what should yield and incredible and constant variety of tomatoes until this fall's first frost.
mircea_popescu: tomatoes go well with soft cheese...
BingoBoingo: Tomatoes also go well eated whole like an apple so long as consumed no further than 100 feet from the vine
shinohai has only planted radishes and cucumbers, has shitty soil in new locale.
BingoBoingo: Have planted Black Krim, Cherokee x Carbon heirloom cross, Juliet Roma x Grape cross, Obligatory yellow cultivar, Beefmaster hybrid, and obligatory cherry tomatoe cultivar
BingoBoingo: * shinohai has only planted radishes and cucumbers, has shitty soil in new locale. << Protip: till a plot and sow densly with turnips/radishes. Do not harvest and burn down with glyphosate before first frost. Till vastly improved soil next year.
shinohai: Thx BingoBoingo will note protip
shinohai: Whoreticulture!
mircea_popescu: beans / lentils prolly work better for same purpose.
shinohai: But then I'd *really* want to eat the tasty lentils
BingoBoingo: Technique can be adapted to the lawn. Sub tilling with overseeding root crops, and instead of glyphosate burn down with 2,4-D and substitute last tilling with patience
BingoBoingo: <mircea_popescu> beans / lentils prolly work better for same purpose. << Clover works well too. Assuming shinohai's climate is too hot to get big legumes going
mircea_popescu: shinohai most of the legume soil improvement happens through the root anyway
mircea_popescu: they fix Ncompounds
shinohai: There are only two seasons in Georgia, slightly chilly and sweltering, humid summer
mircea_popescu: why did i think you liverd in like, southern spain
BingoBoingo: <shinohai> There are only two seasons in Georgia, slightly chilly and sweltering, humid summer << Too cold for citrus, too hot for legumes and cole crops
BingoBoingo: Unless you like Collared greens
BingoBoingo: Or at least that is my vague impression.
shinohai: No thanks to Spain, I can't be running of Moors from my garden all day.
BingoBoingo: Maybe yall sow your spinach in December?
shinohai: I've never tried personally. The woods behind my house however are chock full of Phytolacca decandra.
shinohai: Better known locally as "Poke Salad"
BingoBoingo: Also that shit is incredibly poisonous
shinohai: Older folks go nuts over the shit here though, eat it like spinach.
shinohai: With fatback, even.
BingoBoingo: After substantial effort to boil out the poisons. Ain't nobody got time for that.
shinohai: To me, just easier to grow damned spinach
shinohai: In other locations to plant cucumbers: https://pbs.twimg.com/media/C7sufNFXUAMnGFx.jpg
BingoBoingo: That looks like a zucchini
ben_vulpes: christ what even is the point of a unary predicate in a language without closures
ben_vulpes: oh i know, just establish some more global state
ben_vulpes: you know, before calling the unary predicate
ben_vulpes: EACH TIME
ben_vulpes: wait hang on i have a different critique
ben_vulpes: what even is the point of programming languages that don't in2 closures
ben_vulpes: http://btcbase.org/log/2016-01-21#1380019 << what entails "corrupted gcc"? ☝︎☟︎
a111: Logged on 2016-01-21 18:33 asciilifeform: that is, using corrupted versions of gcc
ben_vulpes: whatever, does not matter in the slightest.
mircea_popescu: real men just goto where the closure is!
ben_vulpes: oh is that how the world works
mircea_popescu: gotta object orients to orient objects yo!
ben_vulpes: mircea_popescu is in high spirits, must be nuts deep in something other than cpp
mircea_popescu: lol. guess so huh.
asciilifeform: http://btcbase.org/log/2017-04-10#1641304 << 5+. ☝︎
a111: Logged on 2017-04-10 05:34 ben_vulpes: http://btcbase.org/log/2016-01-21#1380019 << what entails "corrupted gcc"?
asciilifeform: !#s gcc5
a111: 6 results for "gcc5", http://btcbase.org/log-search?q=gcc5
asciilifeform: ben_vulpes ^ .
asciilifeform: e.g., http://btcbase.org/log/2016-09-13#1541250 ☝︎
a111: Logged on 2016-09-13 17:49 asciilifeform: even gcc5 no longer does.
shinohai: https://twitter.com/theonevortex/status/851439547749548034 "Greatest journalists in crypto"
ben_vulpes: asciilifeform: what was the reasoning behind your call that replacing trb's boostisms with c++11isms was an assault on grandfathers pistols? trb mustest compile with old gcc's?
asciilifeform: ben_vulpes: my contention was that it must compile with < 5 .
asciilifeform: whatever 11isms are properly implemented (with 0 special cases) in 4.9 -- fair game
Framedragger: asciilifeform: just fyi i attempted a single wget (single http request) of sadmods, got 500, phuctor main page now 500's :/
Framedragger: prolly needs flask restart.
asciilifeform: lol, thousand 'postgres: phuctor phuctor [local] SELECT' processes zombieing ☟︎
Framedragger: huh, queries should be cancelled upon a failed http request.. if backend connects to db over tcp socket perhaps check https://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-TCP-KEEPALIVES-IDLE
asciilifeform: i'ma ask everybody, nicely, to quit all automated querying of phuctor.
asciilifeform: Framedragger: 'In sessions connected via a Unix-domain socket, this parameter is ignored and always reads as zero.'
Framedragger: that's why i preluded with "if backend connects over tcp"
Framedragger: ok.
asciilifeform: it doesn't.
asciilifeform: also i'm getting 20+ (!) second disk latencies.
Framedragger: have you checked if maybe google army is attacking you now that you've changed the robots policy?..
asciilifeform: nope, it isn't.
asciilifeform: there's a megatonne of zombie postgres liquishit hanging.
asciilifeform: to the point where restarting the thing doesn't even do anything.
Framedragger: (there's a `pg_terminate_backend(process_id)` which can be fed rows from `pg_stat_activity`, just fyi)
asciilifeform: i have 0 idea what this means.
Framedragger: asciilifeform: does the new-factor/key-adder write to db under a different db user than the db reader which reads data for the web backend?
asciilifeform: nope.
Framedragger: ok
asciilifeform: well, phuctor is back up, until somebody else starts auto-massaging it.
danielpbarron: phuctory reset ☟︎
trinque: haw
Framedragger: the following should output stale queries:
Framedragger: COPY (SELECT pid, client_addr, query_start, query FROM pg_stat_activity WHERE state <> 'active' ORDER BY client_addr ASC, query_start ASC) TO '/tmp/pg-zombies.txt' WITH CSV DELIMITER ' ';
asciilifeform: i know what the stale queries are, already.
asciilifeform: they're normal requests.
Framedragger: oh but like, *active* requests? the use of the word "zombie" implied to me that the web requests themselves may have already died. okok.
asciilifeform: Framedragger: they're zombies in the sense that there were a thousand+ of the liquishit processes whereas there never has any business being > 1 or 2.
asciilifeform: requests with no serious hope of being serviced.
Framedragger: aha ok.
BingoBoingo: Phuctor, in addition to.. you know its stated mission, is possibly the greatest intelligence gathering exercise so far in "single box vs. hordes" problem
asciilifeform: nah that'd be trilema ☟︎
phf: i take it phuctor is more like btcbase. a couple of thousand requests a day, with an occasional massive bot spike
asciilifeform: loads per se can't hose it, in theory; there is a cache
asciilifeform: submits, however, can.
BingoBoingo: asciilifeform: Trilema is "common" application of single box. Many people thusly blog. Phuctor is great because it is a big ball of weird RDBMS-BDSM
BingoBoingo: A micro-lol https://www.insidehighered.com/news/2017/04/10/lack-irs-data-tool-may-harm-fafsa-application-rates-and-already-hurting-students
phf: they laughed at me when i said btcbase doesn't use a database, who's laughin now ☟︎
asciilifeform: phf: i've been searching for how to lose the db, for years now.
asciilifeform: as soon as i figure it out -- it's gone.
trinque: are we doing the "I used it wrong; this proves my political views" thread again?
asciilifeform: trinque: 'there is a right-also, and asciilifeform is a moron' is not a political statement ?
trinque: there are many reasons to hate rdbms. "cannot *at all* run something like phuctor" is not one of them
phf: trinque is the resident psql guru, he managed to wire his 50 request lisp process to a postgresql database ☟︎
trinque: yes phf; this is the only work I've ever done
trinque: live in a garbage can with g_l
asciilifeform: i'm quite certain that it ~could~, trinque . just not at acceptable cost.
phf: tmsr work is primarily defined by its voluntary nature, if i had to do things same way i do it at the office i wouldn't bother. ascii doesn't know intricacies of psql from his day job, and i think it's cruel and inhuman to make him study psql ~as part of tmsr work~. it's not the kind of know how you get to learn by sitting down with a cup of tea and a large printout.. ☟︎
trinque: I think it's dishonorable to prattle on in propaganda mode when there are plenty of statements to be made about why the thing's shit from the position of understanding it.
trinque: nobody's forcing him to use it; now that he has one, I've made a few suggestions to lessen the pain
asciilifeform: all of the constructive suggestions thus far ( from trinque et al ) require full rewrite.
phf: ascii actually can criticize postgresql from the position of understanding. knowing intricacies of psql is not knowledge (rtrees, caching, etc.), it's trivia ("you have to turn lever 3 and depress button Y"). ascii knows what he needs to express, but he can't express it directly, because he's running against architectural constraints of his tool. from that perspective a general "databases are shit" is an entirely valid perspective. ☟︎
asciilifeform: ^
trinque: this conveniently missing the point is shameful on you both.
trinque: he *has one*
trinque: can either bitch like a woman or fix the pain now and also move off later ☟︎
asciilifeform: what part of 'the suggested fixed require full rewrite' is hard to understand ?
asciilifeform: and of 'full rewrite, regardless of what else it features, will NOT feature sql'
asciilifeform: *fixes
trinque: so then your site is going to be down in teh meantime because of a combo of prior technical decisions and present political ones
asciilifeform: the site is up trinque
asciilifeform: and if folks insist on trying to bring it down, i will ban as much of ipv4 space as i have to. ☟︎
asciilifeform: until rewrite.
trinque: I will wager one source of load is my RSS thing, which you bitched wasn't producing results quickly enough
asciilifeform: actually that part creates 0 load, it gets cache ~always
asciilifeform: worx great.
trinque: phf: knowing how to use it is trivia, but tell me, where can I put a dataset now, which I do under no circumstances want to lose, which must be served concurrently to a wide number of clients, which, and so on
deedbot: http://trilema.com/2017/how-to-take-control-of-your-provider-a-guide-for-whores/ << Trilema - How to take control of your provider, a guide for whores.
trinque: I'm not going to recite how mvcc works to you, nor what atomicity is, you're being dishonest
trinque: none of that is trivial, and I'm aware of one mature such example in common lisp, and you have to pay for it
trinque: which is fine, but I assume you're not over there running btcbase on allegro cache
trinque: for that matter, your common lisp can't even dump a textual representation of its entire state which can be loaded elsewhere disregarding arch
trinque: but we weren't talking about that; we were sidewinding onto whatever
asciilifeform: trinque ^ this is both true and imho a serious problem ☟︎
asciilifeform: ( afaik -- mccarthy's lisp -- ~could~ )
trinque: no reason it can't; certainly should
trinque: anyone who thinks I'm defending SQL here is deaf
phf: you're just ranting
asciilifeform: re lisp state -- not sure this is doable on unix -- how do you dump and restore textual representation of posix threads ? fd's ? ☟︎
Framedragger: http://btcbase.org/log/2017-04-10#1641384 << not to rain on your parade but -- without any currently active crawl process, i've tried to wget /sadmods by hand just now, just to have a single copy to serve on the cached site. so far two 504 in a row ☝︎
a111: Logged on 2017-04-10 16:19 asciilifeform: and if folks insist on trying to bring it down, i will ban as much of ipv4 space as i have to.
Framedragger: (so not exactly an 'insist to bring it down')
trinque: phf: you can avoid the point as you choose. "there is a better land and we'll be there someday; don't eat til we get there, best food on earth, they have." has sunk many companies, and many people
asciilifeform: Framedragger: you ~could~ stop hammering it
Framedragger: asciilifeform: i'm not hammering it. check your logs.
Framedragger: i'm trying to request a copy of sadmods.
asciilifeform: didntcha just say 'consecutive 504s'
asciilifeform: what's the 'consecutive' mean if not hammering.
Framedragger: that's wget, it *retries*.
Framedragger: after it gets a 504, it tries again. sequential.
asciilifeform: didn't i ask nicely to quit this ?
asciilifeform: all of it
asciilifeform: anything with auto-retries.
Framedragger: i'm running wget *by hand*. wtf. you expose a href on the site. i try to get it. it fails. ?
asciilifeform: at any rate, thing loaded here.
Framedragger: but that's the last time i brought this up. i wanted to clarify that nobody's hammering it.
asciilifeform: it will start loading again for other people when Framedragger stops autowgetting it.
trinque: lol!
asciilifeform: i have actual work to do, and do not have time to babysit the process all day, every day. ☟︎
Framedragger: ok this is ridiculous, i'm done ☟︎
Framedragger: "your http client tries to re-request after request failed. DDoS!!"
asciilifeform: Framedragger: yes, it is weak! but no, i don't have a five-second fix
phf: trinque: my point is ~why do you do what you do~. there's no hard pressing imperative to freak out, which is the bezzle way of things anyway.
asciilifeform: 'this is a small boat, friends, please refrain from going in more than 5 at a time' 'we'll ALL go in! you should have BIGGER boat, you dummy!111'
trinque: phf: I'm speaking from the perspective that this data storage thing eventually gets solved in the republic.
trinque: can't shitbag the entire notion of "db" and expect to do that correctly
trinque: I've said before the thing needs to be split into many specific tools
trinque: still stand there.
phf: well, right, but you're not going to learn how to db by ~running~ databases. the whole "db" thing is an illusion anyway. rtrees, btrees, indexes, locking mechanisms, mvcc are all concrete algorithms, that you can implement in an adhoc manner for your task at hand and actually see how they work and what they do. ☟︎☟︎
asciilifeform: as it is, sql db is a very effectively opaque black box, full of liquishit, that reliably generates full employment for millions of 'perlists' who memorized the trivia.
phf: allegro cache is actually a lot closer to how btcbase does it, than the postgresql way. internally the two are very different. if you treat both as "a database" you're not going to learn anything
trinque: no disagreement there.
phf: another alternative to doing the sql way is column stores (as an aside allegro cache is really more of a column store), where something like kdb is going to be a reference (the apl approach to databasing in general, of mmaping files with fixed size entries that you can offset into).
asciilifeform: sql is a car with a gas and break pedal for each wheel. ☟︎
asciilifeform: imho life is too short to use it to study such a thing.
asciilifeform: *brake
trinque: I would like to hear of the large firm that did their accounting on another type of db.
trinque: sincerely.
asciilifeform: trinque: i linked to an auto parts shop that does accounting on commodore64 last year...
asciilifeform: and the year before that -- somebody who used... hypercard
trinque sighs
asciilifeform: hey, trinque asked!111
trinque: they don't have a billion of anything
asciilifeform: probably not.
asciilifeform: but sure, sql is 'industry standard'. so is -- winblows.
asciilifeform: it is genuinely the worst possible argument in support of anything.
trinque: no, consider the bundle of questions that enterprise (oil firm, whatever) must ask itself on an ongoing basis
trinque: over *massive* dataset which *is* relational regardless of the db you choose
trinque: that is the standard, not some piece of software
phf: talk about political
asciilifeform: if your operation seriously relies on the db, it implements custom db, from scratch, like the hft trading folks do. ☟︎
trinque: phf: the data is political??
trinque: asciilifeform: ~whole point~ is what the implemented item would look like
trinque: what problems do you encounter at that scale
asciilifeform: it won't look like sql.
phf: trinque: you've asked a question, that i was about to answer, but it turned out to be a rhetorical question, that you then used as a platform to make a political point, yes
trinque: SQL is a language
asciilifeform: because the flexibility has a price.
trinque: phf: ah, then wasn't my intention
trinque: go ahead, answer
trinque: my point was that the customer for the item has these requirements; what does the item which satisfies them begin to resemble?
phf: and you're wrong as far "everyone uses sql11". merril lynch is famous for storing massive datasets in kdb. deutsche bank uses kdb as well as a handful of other datastores (i have some knowledge here), also two of the banks that i consulted for used object stores. that's just the projects that i consulted
trinque: phf: I didn't claim everybody uses SQL
trinque: I claimed that they will satisfy all the requirements by whichever means they choose
asciilifeform: trinque: this seems tautologically true; it doesn't tell us much
phf: most of them ~also use sql~. but likewise there's no such thing as "the database" there's also no such thing as "the database company uses to store its data". banks typically have 50-100 different large data stores, that serve different purposes ☟︎
phf: but the reason that they don't all use sql, is because sql is really bad for certain narrow kinds of tasks and suboptimal for a slightly larger set of tasks
phf: anything involving real time data, anything involving time series, anything involving datasets > 100mil
phf: but on the other hand also anything involving objects of non-trivial topology (that's where you want object stores)
trinque: so we agree that this thing called "database" is really distinct tools which some idiot welded together ☟︎
trinque: say atomic writes on a filesystem, transactional versioning atop that, ...
trinque: or referential integrity, indispensable for bitcoinating
shinohai: !~later tell BingoBoingo http://wotpaste.cascadianhacker.com/pastes/KAp0s/?raw=true
jhvh1: shinohai: The operation succeeded.
trinque: http://btcbase.org/log/2017-04-10#1641468 << what ends up being the problem in an environment with this many data stores? ☝︎
a111: Logged on 2017-04-10 16:51 phf: most of them ~also use sql~. but likewise there's no such thing as "the database" there's also no such thing as "the database company uses to store its data". banks typically have 50-100 different large data stores, that serve different purposes
trinque: I'll tell you; the glue between them by weight comes to dominate
trinque: (he's going to claim I'm arguing for ubiquitous SQL again and miss the point)
phf: what ~is~ the point you're trying to make? you say things, i address them, you immediately move on to some other point
shinohai: The only way to truly settle this matter is with swords.
trinque: phf: I'm having the same experience over here!
trinque will re-engage this in a bit
phf: trinque: ~what is the point you're trying to make~
asciilifeform also puzzled
Framedragger: very unrelated old story for good humour in the forum: https://thedailywtf.com/articles/Special-Delivery
trinque: http://btcbase.org/log/2017-04-10#1641431 << that this is wrong, and letting data access patterns ~between distinct algorithmic components of your system~ be built in ad-hoc manner destroys fits-in-head for the entire system ☝︎
a111: Logged on 2017-04-10 16:37 phf: well, right, but you're not going to learn how to db by ~running~ databases. the whole "db" thing is an illusion anyway. rtrees, btrees, indexes, locking mechanisms, mvcc are all concrete algorithms, that you can implement in an adhoc manner for your task at hand and actually see how they work and what they do.
trinque: I can't sit down with something like that and ask it ANYTHING
trinque: because I'll be here for years creating glue
trinque: that is a statement of the ~problem
trinque: and not a statement of any particular solution
trinque: the database as (extremely poorly) implemented by sql rdbms is a generalization of the glue
lobbes: But re: fits in head. Isn't phf's/alfs argument that you cannot really even audit said generalized glue?
trinque: you have to be able to audit *two* things; the code, and the data, and independently
trinque: the guy who loves hard theory is going to claim the latter always derives from the former
trinque: the manager says... sure buddy
lobbes: I do come from the 'let the data speak for itself' school, so that makes sense to my limited understanding
phf: the "glue" point is a strawman, because you don't know how i write my code. as far as problem/solution though
phf: writing out each one of those concerns separately will teach you how to do it (or whether it can even be done, like with "atomic file system")
phf: but i don't think that working with a black box of rdbms will
phf: yes, you can't sit down with a collection of independent algorithms combined in a specific way and use it in a different way without writing extra code, but that's what repl is for
phf: ok, i guess we both know what the problem is. my solution is "study db related algorithms until you know enough to write a db", your solution, unless i misunderstand, seems to be "use an existing database a lot". i don't understand how learning, say, postgresql will get you from not knowing anything about db internal design to writing your own ☟︎
trinque: I'm sure I've said SQL dbs are terrible a hundred times now.
trinque: and not to use them
trinque: asciilifeform did, so I didn't mind trying to help with that car wreck, having been in plenty of them myself
trinque: I don't criticize that he used it; I do all the time for lack of alternative which has the properties I want
trinque: and I agree with phf that my recourse is to write the thing I want
trinque: neither asciilifeform nor I did in particular cases due to practical tradeoffs of taking that time
trinque: the things pg did exceptionally well never come up in the "omg db sux" thread
trinque: and I'd question the ability of anyone to replace it who didn't bother with that list of things which has fuck all to do with SQL
asciilifeform: the things winblows does exceptionally well also ~never come up in discussions by sane folx.
trinque: yep, I'm out of this thread.
asciilifeform: and my contention is that 'replacing sql' is guaranteed to fail, the problem it solves is intrinsically braindamaged.
phf: in db sucks threads you necessarily talk about pain points. i don't think ~anybody~ here disputes that postgresql is a solid piece of engineering
phf: i'm not sure it's worthwhile to fetishize that quality either. if you attempt to write a db from scratch, postgresql internals is not the first place to look.
phf: but i don't think you're even talking about cracking open the covers? so what does the knowing of these "exceptionally well" things entail?
trinque: what'd you expect as a response to that first bit?
trinque: whole point having been that there are useful items in there that all got welded together ☟︎
trinque: pg's versioned on-disk heap could've held trees as well as rows, eh?
trinque: and in fact does; that's how the versioning works
trinque: later versions pointing upward to previous
asciilifeform: in other lulz : https://archive.is/orEsB : 'Nick Mead, 55, discovered the five gold bars in the Russian T54/69 while restoring it to add to his collection of 150 military vehicles. He and mechanic Todd Chamberlain were filming themselves prising open the diesel tank in case they found munitions and needed to show it to bomb disposal crews. ... Instead, they pulled out the bars, weighing up to 12lb — 5kg — apiece.' and, wtf, '...
asciilifeform: After calling police, two officers took away the bars and gave them a receipt. ... A Northamptonshire Police spokesman said they could not comment “for operational reasons”.'
asciilifeform: meanwhile, elsewhere in the glorious monkey empire, https://archive.is/meEGA : 'A doctor trying to return home to his patients was dragged by his hands from an overbooked United Airlines (UAL.N) flight... Video of the incident posted to Twitter account @Tyler_Bridges shows three security officers huddling over the seated passenger, who appears to be an older Asian man, before dragging him on the floor.'
trinque: pointedly, where's my transactional, versioned, fault tolerant, *persistent* lisp system?
trinque: where disk is not some idiotic file storage but merely an implementation detail of persistence of memory
phf: well, that wasn't a rhetorical question, i was interested. so the second question remains, what does knowing entail in this case
trinque: the re-implementor of modern computing doesn't dispense with these as "you didn't really need that"
phf: that still doesn't answer my question, but the question is at the core of my point. you don't read existing implementations, you don't attempt to write new implementations, you're ~using~ a system that does these things for you. so what is ~knowing~ in this case.
trinque: I've both read postgresql source, several other db turds, written own, extended pg and mucked about heavily in internals
asciilifeform: in other lulz - https://archive.is/us9d8 -- purportedly - 'Decrypted content of eqgrp-auction-file.tar.xz' , 'Passphrase: CrDj"(;Va.*NdlnzB9M?@K2)#>deB7mN'
phf: trinque: well, then why not say it when i asked if you were talking about crackign open the source code? now i actually think that you're lying
trinque: I described how the thing writes rows to disk.
trinque: about done having my character attacked by this guy.
shinohai: https://arstechnica.com/security/2017/04/booby-trapped-word-documents-in-the-wild-exploit-critical-microsoft-0day/
phf: but that's a roundabout way, and you could just read about it in a blog. if the position is that "we should study postgresql source code extensively, as a necessary prerequisite to writing our own database", then i would agree with you, but that doesn't seem to be what you're saying ☟︎
trinque: I could quote myself several times in this thread saying exactly that.
phf: please do
trinque: I'm done speaking with you.
phf: if anybody else can find a trinque quote that says an equivalent of http://btcbase.org/log/2017-04-10#1641538 i will apologize, otherwise i guess this stands. ☝︎
a111: Logged on 2017-04-10 19:35 phf: but that's a roundabout way, and you could just read about it in a blog. if the position is that "we should study postgresql source code extensively, as a necessary prerequisite to writing our own database", then i would agree with you, but that doesn't seem to be what you're saying
asciilifeform: fwiw i still don't grasp what trinque was disagreeing with phf about.
trinque: you made the assumption that when I was speaking of the things merits, I was speaking of what, the lever you pull and not what it actuates?
trinque: phf: ^
trinque: you did that aiming to pin me on something easily argued
trinque: that running forward with a bare assumption and then spending the whole thread trying to smash opponent into it has been the rule with you
phf: you clearly have some twisted issues related to me. ~that was not my intent~. ~i genuinely think that you were speaking of pulling levers~ ~because there's nowhere in the thread where you attempted to dissuade me of my notion~
phf: that's why i asked you point blank if you're talking about reading code, omg
phf: if that was such an obvious assumption, then why evade addressing it? that would've saved the whole thread! my assumption was ~very obvious~ as you yourself state ~all through the thread~, because ~that's what i assumed~
trinque: I'm not defending every fucking "OP is a redditard" you throw at me
phf: then why speak to me at all? i was arguing in good faith, as an attempt to move on from our previous alteration
phf: apparently that's not how they do things down south. once a grudge always a grudge. fine. we can agree not to talk to each other at all, nor mention each others names. i was sticking to that policy, and it worked fine for me. good day.
asciilifeform: meanwhile, owned boxes list extracted from earlier: http://wotpaste.cascadianhacker.com/pastes/gO3io/?raw=true
asciilifeform: mircea_popescu et al ^
asciilifeform: ( or for anyone else with good logging on his boxes and a strong sense of lol )
asciilifeform: https://archive.is/HDN6Y << seems to be the ~same thing, organized by orifice type
asciilifeform: Run Moar Slowaris
asciilifeform: i386-pc-sco3.2v5.0.5 << apparently someone, somewhere! (in a cave?!)
trinque: phf: one thing they don't do is speak for the other, then proceed from there as if it'd been said
trinque: probably about as southern as it gets, that one
trinque: and I don't see that you get much "culture of honor" without it
lobbes: In unrelated lulz, american consumerism moves ever closer to its apex: http://m.imgur.com/Npg7IWR ☟︎
CompanionCube: lobbes: eh, if people want to buy it
CompanionCube: besides, plush pillows are normally good for cuddling when you want to
shinohai: https://twitter.com/VitalikButerin/status/851307750495801348 "I'd rather have a consensus failure every year than intense constant bickering."
asciilifeform: wtf is a 'consensus failure' ?
ben_vulpes: "just remember you can't take your words back, these aren't Ethereum transactions"
mircea_popescu: you know, when trump gets elected. when the niggers who figured they were gonna use "consensus" to get the delicious chicken fail to get the delicious chicken.
mircea_popescu: "failed to do what we wanted it to do dammit"
asciilifeform: what's it called when trump hands them the delishious-syrian-chicken after all ?
mircea_popescu: i dunno, remedial of consensus failure ?
asciilifeform: reorg!111
mircea_popescu: algo asi.
shinohai imagines Vitalik reading the logs an thing mircea_popescu meant `Asi` is a new groundbreaking algorithm .....
shinohai: s/thing/thinking/
mircea_popescu: lol
BingoBoingo: <lobbes> In unrelated lulz, american consumerism moves ever closer to its apex: http://m.imgur.com/Npg7IWR << I have seen those for sale at my local "Circle K"
deedbot: http://qntra.net/2017/04/altcointradingbot-io-is-very-sorry-for-your-loss/ << Qntra - Altcointradingbot.io Is Very Sorry For Your Loss
mircea_popescu: http://btcbase.org/log/2017-04-10#1641325 << this sounds like a horribru locking job. ☝︎
a111: Logged on 2017-04-10 15:25 asciilifeform: lol, thousand 'postgres: phuctor phuctor [local] SELECT' processes zombieing
BingoBoingo: * shinohai imagines Vitalik reading the logs an thing mircea_popescu meant `Asi` is a new groundbreaking algorithm ..... << Ass Sort Integrals, some very deep "Ito calculus"
mircea_popescu: o brother. you were here for the ito experts huh.
asciilifeform: mircea_popescu: i have it running instrumented presently, soon will see why zombies.
BingoBoingo: lol, poor usagi was a great outcome
asciilifeform: was 'ito calculus' authored by same 'genius' as 'igonvalue' ?
mircea_popescu: incidentally, for all the ulterior leonization, the actual wild west was very much like this : buncha children captive in adult bodies trying to cope.
mircea_popescu: asciilifeform https://pastebin.com/mKui8iHr
mircea_popescu: ancient lulz.
BingoBoingo: <mircea_popescu> o brother. you were here for the ito experts huh. << Nah, came for the drinks, stayed for the revolution.
BingoBoingo: <asciilifeform> was 'ito calculus' authored by same 'genius' as 'igonvalue' ? << I see "ito calculus" as catchall for weaponized labels of Usagidiocy type
asciilifeform: oh hah it turns out to actually have existed, somewhere
asciilifeform: attempts to model brownian motion.
asciilifeform puts on conveyor
mircea_popescu: http://btcbase.org/log/2017-04-10#1641343 << ahahaha ☝︎
a111: Logged on 2017-04-10 15:43 danielpbarron: phuctory reset
mircea_popescu: asciilifeform it's a narrow interest item, perfectly respectable in its niche. as bb says, ended up being a sort of shorthand for internet expert in here because randos and history.
asciilifeform: actually pertinent to my current kick, even.
asciilifeform: ( models of bad rngs, such as shitoshi's )
mircea_popescu: fwiw, math finance goes through one of these every 3-4 years (ie, every time a new crop of collegiate tards ends up dominating the hiring pool)
mircea_popescu: was "gauss copula" for a while famously. was a buncha things, i have notes somewhere.
asciilifeform is not and has not ever been employed as an astrologer, cannot comment usefully
mircea_popescu: http://btcbase.org/log/2017-04-10#1641354 << this is an iffy discussion. trilema does very little backend but more front end. phuctor the reverse. i think they're very complementary wrt the load type. ☝︎
a111: Logged on 2017-04-10 15:53 asciilifeform: nah that'd be trilema
mircea_popescu: as asciilifeform correctly points out, there's not THAT much of a deal to insert an article once a day / a comment once an hour and otherwise serve reads.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641360 << they didn't laugh, they were taken aback at the magic. ☝︎
a111: Logged on 2017-04-10 15:57 phf: they laughed at me when i said btcbase doesn't use a database, who's laughin now
mircea_popescu: http://btcbase.org/log/2017-04-10#1641366 << lmao i take it this supply of zingers will last a while. ☝︎
a111: Logged on 2017-04-10 16:03 phf: trinque is the resident psql guru, he managed to wire his 50 request lisp process to a postgresql database
mircea_popescu: http://btcbase.org/log/2017-04-10#1641370 << it all revolves on whether the $item is fundamental or not. if it's fundamental -- not inhuman to make him study, inhuman to allow him to squeak past without studying. ☝︎
a111: Logged on 2017-04-10 16:07 phf: tmsr work is primarily defined by its voluntary nature, if i had to do things same way i do it at the office i wouldn't bother. ascii doesn't know intricacies of psql from his day job, and i think it's cruel and inhuman to make him study psql ~as part of tmsr work~. it's not the kind of know how you get to learn by sitting down with a cup of tea and a large printout..
mircea_popescu: but if not fundamental, yes inhuman.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641374 << this is a perfectly reasonable view, and it'd carry were it not be tinged by a history of asciilifeform on occasion producing overgeneral statements not because he ran against design constraints of the space but because he ran against mental constraints of his own. ☝︎
a111: Logged on 2017-04-10 16:15 phf: ascii actually can criticize postgresql from the position of understanding. knowing intricacies of psql is not knowledge (rtrees, caching, etc.), it's trivia ("you have to turn lever 3 and depress button Y"). ascii knows what he needs to express, but he can't express it directly, because he's running against architectural constraints of his tool. from that perspective a general "databases are shit" is an entirely valid perspective.
asciilifeform did, ftr, end up descending into the darkest depths of his chamber of pain and cracking a b00k, with the aim of determining -- which. this op has not yet returned.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641378 << you now have cold sores. can either bitch about it or... wait for them to pass ? ☝︎
a111: Logged on 2017-04-10 16:17 trinque: can either bitch like a woman or fix the pain now and also move off later
mircea_popescu: asciilifeform i did same, also not yet returned.
mircea_popescu: in unrelated news : me goes into shop where girl has bought nice shot glasses to buy shot glasses. "do you have these in a box ?" "yes" "how many in the box ?" "uhh..." nicaraguan chick is very much willing to be picked up but has nfi how many shot glasses in 3x4 case.
mircea_popescu: "15". "usure ?" "uh..." "it's 12" she counts... 12.
mircea_popescu: then... she doesn't know how much for the dozen. if they're 400 each then 12 is... 3600...
asciilifeform: mircea_popescu described argentines as borderline tards but i don't recall hearing a story like this about them...
mircea_popescu: i never saw unmath this bad aside of us college educated girls.
asciilifeform: cr must be near the peak of the equator's stupification field
mircea_popescu: chick was imported though.
mircea_popescu: and nicaragua is... let's say only fit for fauna.
mircea_popescu: 40 degrees with 90% humidity sorta deal.
asciilifeform misread '90% humanity'
mircea_popescu: lol
mircea_popescu: the humidity is the killer.
asciilifeform: it's one of the worst things in dc, it is
mircea_popescu: even in buenos aires, of every 10kw the ac ate, 7 to 8 made water.
asciilifeform: asciilifeform once switched planes in panama and ( it had outdoor walk, instead of the customary human pipe ) thought 'just like home'
mircea_popescu: btw -- i have no ac here. the girls are naked indoors. it's fabulous.
asciilifeform: i do know that there are places where the air is hot and ~dry~, and ac has no drain pipe -- but never yet been there.
ben_vulpes: i rather dislike "conditioned" air
mircea_popescu: ben_vulpes aha. me too.
asciilifeform: ben_vulpes: i always wished there were such a thing as an ac with a throttle
ben_vulpes: too dry, doesn't have the nasty taste of reality
mircea_popescu: asciilifeform that'd be egypt for instance.
shinohai: Now you can just have naked girls fan you mircea_popescu - win-win!
asciilifeform: summer for asciilifeform is an alternating 10min of 'hot' and 'cold'
mircea_popescu: it rained once while i was there. took 5 minutes, most of the water was gone before touching soil.
mircea_popescu: shinohai i'm not even hot, it's pleasant.
ben_vulpes: asciilifeform: why the hysteresis?
mircea_popescu: asciilifeform you could get your ac connected to the water pipe -- like the fridges with built in ice maker.
shinohai: It's 83 degrees on my patio and sun is going down
ben_vulpes: dang
asciilifeform: mircea_popescu: what would that do ? if you cool the air, and lower the dew point, not even garden hose will make it hold any more water than remained in it after the cooling
ben_vulpes: pac nw is still extricating itself from winter
mircea_popescu: asciilifeform save on electricity through spraying it in finely i think ? not sure, never took one apart.
trinque: 77 out; I was promised warming apocalypse
trinque: best april we've had in recent memory
asciilifeform: mircea_popescu: many folx here have a 'humidifier', separate gadget
asciilifeform: humidifier + ac is disaster though, damp everywhere.
asciilifeform: for the reason described earlier.
mircea_popescu: i was there in winter, so not much call for anything of the sort.
ben_vulpes: schizophrenic weather gods will continue with the increasingly bipolar weather until the humans die off adequately to restore ecological sanity
mircea_popescu: http://btcbase.org/log/2017-04-10#1641396 << well, solved problem in sql since a while back. ☝︎
a111: Logged on 2017-04-10 16:25 asciilifeform: trinque ^ this is both true and imho a serious problem
mircea_popescu: http://btcbase.org/log/2017-04-10#1641421 << ahahaha. ☝︎
a111: Logged on 2017-04-10 16:31 asciilifeform: i have actual work to do, and do not have time to babysit the process all day, every day.
mircea_popescu: now you know how "www engineer" became a thing.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641422 << take it easy m'lord, jus' needs a little time. ☝︎
a111: Logged on 2017-04-10 16:31 Framedragger: ok this is ridiculous, i'm done
asciilifeform: www engineer << at one point there were furnace stokers, also.
mircea_popescu: actually the english word engineer denotes furnace stoker.
asciilifeform: ( on train they were even called, in english-speaking world, engineers!! )
asciilifeform: lol
mircea_popescu: unlike the french word ingenieur, for instance. which comes from genius, or whatever, ingenuity
ben_vulpes: i'll take ingenues over ingenieurs any day
mircea_popescu: i bet.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641431 << there are some advantages to having a standard package of these things everyone uses (this is called maturity) and no serious drawback to calling that package "a database". ☝︎
a111: Logged on 2017-04-10 16:37 phf: well, right, but you're not going to learn how to db by ~running~ databases. the whole "db" thing is an illusion anyway. rtrees, btrees, indexes, locking mechanisms, mvcc are all concrete algorithms, that you can implement in an adhoc manner for your task at hand and actually see how they work and what they do.
asciilifeform: https://youtu.be/tnnCHmSJpg4?t=4m9s << see also oblig.
asciilifeform: ( good film btw . )
ben_vulpes: sweet chevy
asciilifeform: mircea_popescu: problem is, 'database' as commonly seen in sqlworld is not 'collection of btrees, rtrees, etc.' in encyclopaedic algorithmic form, but a misbegotten attempt at ai.
mircea_popescu: http://btcbase.org/log/2017-04-10#1641436 << and yet this is exactly how multi-engine airplanes work. ☝︎
a111: Logged on 2017-04-10 16:43 asciilifeform: sql is a car with a gas and break pedal for each wheel.
asciilifeform: which purports to choose a one-size-fits-all set of algos for a given data bag.
trinque: http://btcbase.org/log/2017-04-10#1641520 ☝︎
a111: Logged on 2017-04-10 19:16 trinque: whole point having been that there are useful items in there that all got welded together
mircea_popescu: asciilifeform this, i am aware. but i suspect the "concept of db" trinque defends is "here is the set of definitive -- because mature -- things that handle data ; fucking use it".
trinque: ^ not coming across is why the thread was ridiculous
mircea_popescu: not the nonsensical "oh, paperclip!" microsoft access / lotus 1-2-3 / novell bs approach
asciilifeform: trinque: i entirely agree re above -- there could be such a thing as 'reusable encyclopaedia of data structures'. problem is, it dun exist yet.
trinque: aha.
asciilifeform: it ~will~ exist, as a vtronic item.
mircea_popescu: well, alfie, there could ALSO EXIST SUCH A THING AS A PROGRAMMABLE COMPUTER
trinque: double-aha.
mircea_popescu: now guess what the problem is.
shinohai: lolz
mircea_popescu: heh.
asciilifeform: would be a mighty fine thing, indeed.
mircea_popescu: you're both welcome now shake hands and stop being so pissy all the time. life's too square and my fruit salad too good to waste suchly!
trinque: lol. you got it boss.
shinohai still wants to see a sword duel, failing that.
mircea_popescu: anyone saw liz taylor playing a jew ?
mircea_popescu: (ivanhoe. great film. there's trial by combat!)
mircea_popescu: http://btcbase.org/log/2017-04-10#1641453 << the hft trading folk are about as dumb as the "serious www publishing folk". the "implement from scratch" thing is a fiction, there to justify insane and unjustifiable expense. exaclty how and exactly why any third hand "outside consultant" in third world sells random dopes on "whole new cms!!11" for their "project" so it is "for srs professional". ☝︎
a111: Logged on 2017-04-10 16:47 asciilifeform: if your operation seriously relies on the db, it implements custom db, from scratch, like the hft trading folks do.
mircea_popescu: but in truth and behind the scene it's 100% code reuse in the most "found on forum and pasted in" manner.
mircea_popescu: i am aware this sounds incredible. it's factual.
mircea_popescu: about half the "pro" trading houses do about half of their trading on the basis of poorly understood and badly maintained excel spreadsheets.
mircea_popescu: on it goes.
asciilifeform: mircea_popescu: whether or not the 'nanosecs matter and we write it in asm' hft traders are real -- or mythical -- i do not know. but if hft worked the way it is purported to work, they ought to exist.
mircea_popescu: asciilifeform same relationship as between script kiddie and trojan writers
mircea_popescu: yes, someone somewhere wrote the asm
mircea_popescu: then someone piled a java machine on top of that.
asciilifeform: ( it they do not exist, it is then a piece of evidence in favour of 'hft does not actually exist, you cannot actually make any money by undercutting by nanosecond ' )
asciilifeform: *if
mircea_popescu: it's a complicated discussion to carry in those terms.
mircea_popescu: essentially speaking, front running is a natural crown monopoly, like hunting.
mircea_popescu: how exactly this is disbursed, whether you need rifle to hunt and then crown taxes rifles, ie, through a technically mediated barrier, or purely conventional, is not properly speaking a technical discussion.
asciilifeform: the people paying megabux for cage near nyse, nasdaq, either exist or are product of elaborate disinfo. if the former, it would make sense for them to carry out the -- comparatively inexpensive -- software optimization prior to buying $mil cage.
mircea_popescu: the people paying themselves megabux aren't going to be doing for the reason they told you they did it.
asciilifeform: now i could easily picture 'crown tax is so high, only imbecile hapsburg can afford it, so no optimize'
mircea_popescu: asciilifeform picture this : if tomorrow north korea came up with superlight hft method and tried to apply it... suddenly front running would be simply illegal.
asciilifeform: ( in combination with 'it dun matter if you make it 5ns faster, packets from goldman sachs still take magical priority on the other end, For Reasons' )
asciilifeform: aha.
mircea_popescu: so, with some regret, i will confess that no, high finance doth not qualify as that place where they have real software (tm).
mircea_popescu: au contraire, you'd be petrified what they run on.
asciilifeform: that makes for at least 2 publicly-known designated-winners-losers equivalence classes. probably there are more.
mircea_popescu: and no, the excel mentiuon was not a throwaway joke. it is factual reality, even today.
asciilifeform: in what sense could a system that runs on excel etc. be described as 'high frequency' ?
asciilifeform: can you even get 1Hz out of it ?
mircea_popescu: ah no, separate concerns.
mircea_popescu: i didn't propose they run the hft over excel
asciilifeform: and for what does jane street co. hire ml, lisp, etc. programmers ?
mircea_popescu: random.
mircea_popescu: that's the problem of wastage in opaque faux capitalism.
mircea_popescu: you get hired randomly.
trinque: the accountant fellow I mentioned, for $100mil scale oil contract compliance, also excel macros. ☟︎
mircea_popescu: heh.
trinque: might be a feature (TM) (R)
asciilifeform: trinque: i wonder how much of this is from a cargo-cult preference for 'what programmer monkeys WOULDN'T use'
asciilifeform: 'send in a code nigger, if he barfs, our system is proper'
mircea_popescu: from what i could discern, it's because of familiarity bias.
mircea_popescu: "excel i understand" "no you don't" "but i've been using it forever" "not even that."
mircea_popescu: "it makes me feel good." "go to the strip club."