17700+ entries in 0.127s
jurov: coinbr orders fixed.
mircea_popescu pls to process
☟︎ trinque:
mircea_popescu: reads block nobody, never block. I understand the where clause of an insert statement to be a condition on a read query that gets fed into a write, just as my "common table expressions" ('with' keyword) feed into each other.
trinque:
mircea_popescu:
https://www.postgresql.org/docs/current/static/mvcc-intro.html << "Internally, data consistency is maintained by using a multiversion model (Multiversion Concurrency Control, MVCC). This means that each SQL statement sees a snapshot of data (a database version) as it was some time ago, regardless of the current state of the underlying data. This prevents statements from viewing inconsistent
BingoBoingo: <asciilifeform>
mircea_popescu: on contemplation, cars may not be a very good hiding place, they ( esp in usa ) routinely move through chokepoints - toll archs, and these are already equipped with camera and radio receivers << Depends on region and car
a111: Logged on 2015-08-24 18:01
mircea_popescu: previous flight lost an engine foil, concorde ran it over, it cut a wheel, wheel exploded, large fragment of tyre hit underwing, shockwave broke a fuel tanker, fuel gushed out and caught, engineer cut the engine next, at which point they had 2km worth of runway left and needed 3 to abort.
a111: Logged on 2017-04-07 18:08 Framedragger:
mircea_popescu: i thought one of the parts was a c proggy. quite certain it is, asciilifeform mentioned it multiple times. python is the web backend afaik
Framedragger:
mircea_popescu: re "nothing here" the idea would be that upon user submitting gpg key, page reloads *instantly* (vs. near-instant page load on current phuctor - reloads only after key inserted into db), shows permalink and "waiting for insertion" msg; html could have property to auto refresh every second until master responds with any links to other keys. but i understand asciilifeform's reasons against this
Framedragger:
mircea_popescu: i thought one of the parts was a c proggy. quite certain it is, asciilifeform mentioned it multiple times. python is the web backend afaik
☟︎ a111: Logged on 2017-04-07 14:44 trinque:
mircea_popescu: more clearly stated, I do not see a www as part of the algorithm of phuctor. it is one source of input where there could be many, and one output idem. with a clearly defined line between www and phuctor (even allowing for that www may require cached copies of phuctor data to operate properly), this gives you something you can nuke later and replace.
trinque:
mircea_popescu: more clearly stated, I do not see a www as part of the algorithm of phuctor. it is one source of input where there could be many, and one output idem. with a clearly defined line between www and phuctor (even allowing for that www may require cached copies of phuctor data to operate properly), this gives you something you can nuke later and replace.
☟︎ a111: Logged on 2017-04-07 11:52
mircea_popescu: tits for btc -> redemption.
Framedragger:
mircea_popescu: in materialized view, postgres can persist results of query in table-like form. so it *does* cache them; hence you can't say it's convenience only.
a111: Logged on 2017-04-07 13:16
mircea_popescu: the problem was that db waits for writes to read iirc.
deedbot:
mircea_popescu rated skydragon 1 << seems hardworking enough.
trinque:
mircea_popescu: the fucking syntax though eh? cut all dicks off all males, then you back it down to particulars!
Framedragger:
mircea_popescu: so you went through every row checking if it has turd at start, and removing that turd? or found binary log to roll back the transaction (which should have aborted and rolled back, something something)
Framedragger: i mean even if
mircea_popescu aborted a db write, it shouldn't have forked into gigs of crap?..
CompanionCube:
mircea_popescu: do you plan to write an article about mysql being a shit?
Framedragger:
mircea_popescu: by text-only i meant the *output*, it can certainly handle binary blobs
Framedragger: typical small .sql is usually just a set of "INSERT INTO .. VALUES ..", but
mircea_popescu is running a large escher megasite, so i'm less certain..
Framedragger:
mircea_popescu: .sql is a set of statements which you can run on db to put it back into the state which produced the .sql in question, no? but, if there's mysql specific convention bullshit tho, i wouldn't know :/
a111: Logged on 2017-02-14 00:14
mircea_popescu: gabriel_laddel_p if it could detect and wipe the idiotic wrap(80) thing that'd be great.
Framedragger:
mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so that in itself is alarming.. weird
Framedragger:
mircea_popescu: recently had to tail multigb files, it was *instant* (because, seeks to end of file). seems like a disk prob to me
a111: Logged on 2017-04-06 19:05
mircea_popescu: head doesn't work on a large file.
jhvh1:
mircea_popescu: bannon :: When a person or animal gets high on a substance, often in unexpected places. This usually ends in chaos for everyone. [ex:] At school all my friends bannoned on sharpies. [/ex]
jhvh1:
mircea_popescu: trump :: 1. To have superior power over.2. To surpass or outdo.3. When a person says "trump," you are required to do whatever you just claimed you would do, no matter how exaggerated it was. If you don't do it, you get a [spartan kick] to the chest. [ex:] 1. Bob: The president's word trumps yours, Joe, you homeless piece of shit. When he says something it must be done.2. Joe: Man, I'll trump your ass (5 more messages)
jhvh1:
mircea_popescu: obama :: The Messiah for brain-dead Democrats. [ex:] No matter what he says, no matter what he does, they'll worship the great Obama. [/ex] | An acronym standing for One BigAss Mistake,America! [ex:] Q: What was the result of the 2008 election?A: OBAMA [/ex] | Has no real experience, because most of his time as "senator" was spent campaigning for his own election to President. Is praised (10 more messages)
jhvh1:
mircea_popescu: ERROR: 'woke whore' not defined on UrbanDictionary.
shinohai: Turned !~ud bqck on
mircea_popescu ... cheers!
trinque:
mircea_popescu: universal basic income
jhvh1:
mircea_popescu: Error: "ud" is not a valid command.
Framedragger:
mircea_popescu: hm.. okay. wonder why it failed. (i guess in the future consider LONGBLOB for this (and encode/decode as needed), but it wasn't..that large, even.. huh.)
Framedragger: mebbe you had a separate /var partition from linux install long ago,
mircea_popescu.. this can bite
BingoBoingo: <
mircea_popescu> incredible. this is even legal ? << O hai I R the packet interceptor. Pls to pay again for delivery.
lobbes:
mircea_popescu: Nah nothing really. I noticed you pasted that link earlier but bot didn't quote. I think you were just too fast for it
lobbesbot: Logged on 2017-04-06 00:05:55: <
mircea_popescu> until trinque's deedbot payment is on i dunno what lightweight to recommend you
Framedragger:
mircea_popescu: sorry i forgot or didn't know that you actually in fact restarted it.
Framedragger:
mircea_popescu: well you can still kill the particular mysql process which is handling the query, `show processlist` (may show "Waiting for table metadata lock" under "State" column; "Info" column should display the query in question), then `Kill IDGOESHERE`
Framedragger: do you still have a running mysql cli session
mircea_popescu?
a111: Logged on 2016-12-30 17:16
mircea_popescu: it really should be up to operator wtf, if i want to read dirty let me read dirty what sort of decision is this for designer to make.
Framedragger: hmh it should at least fail, or sth. is it still running
mircea_popescu? can you do `show processlist` with separate mysql client session? (NB, am not a mysql guy)
Framedragger:
mircea_popescu: you're putting it in mysql aren't you, and making php generate a table or sth?
a111: Logged on 2017-04-06 12:43
mircea_popescu: lel. the cheapest is for the site to support it natively!
a111: Logged on 2017-04-06 12:33
mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
Framedragger:
mircea_popescu: ahahahaha it does say "MUM" (should be "Mon" of course)
Framedragger: that is exactly what it means
mircea_popescu lol
a111: Logged on 2017-03-29 16:25
mircea_popescu: if you find it within yoruself to post forms you were issued that'd be grand.
shinohai: They might read trilema, see
mircea_popescu in earlier days with joofro and start pogrom
shinohai hopes
mircea_popescu 's Russian chicks aren't anti-semitic
a111: Logged on 2017-04-06 02:27
mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
BingoBoingo: <
mircea_popescu> anyway, no explaining, ridiculous move. << perhaps move to lure pantsuits into self hanging? Either that or clog fake news circuit.