log☇︎
67800+ entries in 0.499s
Framedragger: btw, i once screwed around with memoization in flask. iirc something can be done here as well, asciilifeform (it may be as trivial as adding a decorator before the function which handles GET request)
asciilifeform: and i certainly don't want html in my db wtf
asciilifeform: trinque: i don't like state
asciilifeform: trinque: that sounds potentially useful. i'll have to investigate
trinque: they are useful for calculating aggregates as I was describing.
asciilifeform: a very recent one . but i'll have to get back to you Framedragger re : which
Framedragger: obtw which postgres version on phuctor asciilifeform? those two features not available in old versions. i don't remember which ver is in debian stable
trinque: which is why I interact with it through means that do *not* block as it does
asciilifeform: mno. i refuse to marry sql db !!!
trinque: could get me a pg connection and I could listen for pg_notify on a trigger of that table
mircea_popescu: a db write is either insert or update ; finding out things is usually a select. it ~may~ be worthwhile to separate your reads from the writes, because it is technically possible (thopugh i'd hope unlikely) the db is dumb enough to put write locks in for something like "update x on y" even though it should be "select y if z then update x".
asciilifeform: maybe i misunderstand what means 'update' ?
mircea_popescu: pretty sure you weren't able to do it after i fucked it
asciilifeform: mircea_popescu: fwiw i was not able to load trilema while this was taking place.
mircea_popescu: asciilifeform no, i on occasion do multi-row updates. such as (lolz) recently when i made every entry of the 50k items in article db read the same thing.
trinque: i.e. counts are always correct
mircea_popescu whenever i do maintenances.
trinque: man, I've worked on pg databases that did nothing but write *and* read concurrently while sitting on a few hundred million rows
mircea_popescu: yes but i know it in fact does from you know, running trilema.
asciilifeform: the use of python for frontend was a mistake. i did it to avoid having to write gpg disasmer from 0, and www liquishit from 0
asciilifeform: http://btcbase.org/log/2017-04-07#1639649 << i would like to static the whole thing, but currently have nfi how to do that while retaining the 'what are all keys with mod M ?' , 'what are all mods with factor F?' , 'search for string S in userids' etc ☝︎
Framedragger: 'i fucked up and also was on drugs'
Framedragger: bhah she's actually retracting her words so i guess not!
mircea_popescu: i might be a little slow on the uptake, but what is tomahawk supposed to do to airstrip ?
phf: i thought that's 9mm, but i guess that makes sense. fwiw cheapest round at the range
phf: i was just shooting that earlier today...
mircea_popescu: ah lol. i thought for a moment they actually were going for the fortifications there.
asciilifeform: meanwhile, https://archive.is/b7Ggr >> deathray treason! and plot! i know of no reason! why deathray treason, should ever be forgot !!1111
trinque: still very much open whether he says "alright, I did something" and leaves, or starts another Iraq
mircea_popescu: for the record, i was trying to watch a comedy. half hour in i'm like... feh, i wonder what trilema's up to
asciilifeform: https://94.85.167.67/smartdomuspad/modules/system/externalframe.php << what are these -- i've nfi
asciilifeform: i meant -- it may be an incredible feat of akmanship, or a snore, or a lucky shot (ww2-style), depending on distance, neh.
asciilifeform: but from here i cannot currently see through the cam.
asciilifeform: i have nfi, 'need plugin to display'
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/67292F9B4E5202A528710EB964E9DE8072D79EA211065FA83B8414E214207E8F << all of them, i think.
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/12E33F9E49E155F1A0FC54B92E8D60A589DE15017A5D4FC9B6F1D9E3046E615E << i'd still luvvv to know what these are, 111 modulus dupes, but none seem to ping.
shinohai: First one I am privy to in recent memory.
shinohai: I'm actually impressed some fromloper finally speaks
fromloper: thank you. I will.
fromloper: actually, I found sweet rants on clojure, and followed the crumbs.
mircea_popescu: to think i nearly lost trilema over this bitch!
fromloper: I was hungry and I smelled smores.
doppler: I didn't even notice it was comic sans until I happened to browse on my windows box
Framedragger: (apparently some couple of russians had a fight and one shot the other over a dispute regarding kant. i can believe that)
trinque: (wherein phf gets mad at me re: that's how set theory works and I scratch at my left stump)
trinque: I by way of a sad life always write the where clause first
mircea_popescu: Framedragger i whined at person actually in charge of this who gave me the backup.
mircea_popescu: and THEN i interrupted it so it lost its indexes too.
mircea_popescu: I UPDATED EVERY SINGLE CONTENT FIELD FOR EVERY ARTICLE TO THE NEW ONE
mircea_popescu: Framedragger i dun think you've grokked the depths of my idiocy
Framedragger: i mean even if mircea_popescu aborted a db write, it shouldn't have forked into gigs of crap?..
shinohai: So I noticed thestringpuller has changed his location on twitter from "La Serenissima" to " Wakanda "
shinohai: This is why I am not Secretary of State.
gabriel_laddel_p: Oh, and I learned the price of lispworks - 4.5k
mircea_popescu: UPDATE table SET content field = '(the 2mb content of the post i wanted ADDED goes here)'
Framedragger: mircea_popescu: by text-only i meant the *output*, it can certainly handle binary blobs
mircea_popescu: i don't imagine anyone can actually intuit what i in fact did.
Framedragger: but actually, i haven't run mysqldump in forever and not 100% certain about docs, so i don't know
Framedragger: i don't know what that is
mircea_popescu: MYD i mean
Framedragger: (i don't know about that "db" file, tho, i mean, that one's binary)
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..
mircea_popescu: i wasn't aware .sql is supposed to be a text file.
Framedragger: but i'll check lest i'm talking out of ass
Framedragger: i don't know how it would encode it, but in general, yes. more like, escape nonprintable chars with "\0" i guess
mircea_popescu: asciilifeform i'm reasonably happy with the format tbh.
mircea_popescu: Framedragger and if i store a jpeg the dumper is supposed to do what, base64 it ?
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 :/
gabriel_laddel_p: asciilifeform: in that conversation I dropped "rich webpage" & "text" archives into the log, which were OK'd, given that word-wrapping was removed.
asciilifeform: gabriel_laddel_p: what am i looking at
gabriel_laddel_p: http://btcbase.org/log/2017-04-06#1639114 < I didn't realize that this "sharing" link would open in google drive. Here is a link to the same file that you can open in emacs, curl etc https://raw.githubusercontent.com/gabriel-laddel/masamune/master/slate-star-codex-no-wrap80.txt ☝︎
mircea_popescu: sadly the output is over 8gb already. apparently i got more crap in there.
mircea_popescu: (i suspect /g doesn't work well with mb lines)
asciilifeform: sed -i 's/\x0//g' file
mircea_popescu: looks like i got about 40mb of them
mircea_popescu: now then : how do i wipe null chars from file ?
mircea_popescu: here's a heads-up : head has been going for ~4 minutes. i expect it to crash without output.
mircea_popescu: how will i hexdump ?
mircea_popescu: and what am i, mafalda ?
mircea_popescu: -- Dump completed on 2017-04-06 15:10:30 << at least i know for a fact i got an integral mysqldump. sadly it's 40.9 gb.
Framedragger: i am very interested in i/o of `tail` while it's running. wtf. would apt-get install iotop
Framedragger: (ah it's not installed by default i'm afraid)
mircea_popescu: i can see the theoretical "benchmarks" online too. the problem is they're bs, "test file generated by seq 100mn". hurr. how about generate a file with lines of random length between 1kb and 1mb, then benchmark it.
mircea_popescu: anyway, im dumping teh table as a sql and will be wanting to hack it up. but i have no tools with which to identify the CUT HERE spot
mircea_popescu: i suppose.
mircea_popescu: i checked it and it's fine
mircea_popescu: i am plagued by cursed bs.
mircea_popescu: i dunno why this is such a tall order.
mircea_popescu: what i want is non-freezing tools.
mircea_popescu: i guess i'm naive to imagine standard tools can do the job of fixing the mess standard tools created huh
mircea_popescu: i dun have it ;/
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)
asciilifeform: damn, i was quite certain i recalled it read 'sad coke hell'
jhvh1: asciilifeform: haskell :: 1 -- A general purpose, polymorphicly typed, lazy functional programming language largely based on lambda calculus. 2 -- A constant source of frustration for those who have been brainwashed by the OO paradigm. [ex:] You: How do I write a 'while' loop with Haskell?Me: You can't, freshman. [/ex] | A town in Northern New Jerse located between Ringwood and Pompton Lakes, smaller district of (5 more messages)
mircea_popescu: trinque i certainly don't see anything wrong with teaching the stupid how to be even stupider until the time they're actually ready to hands and knees.
ben_vulpes: trinque: w-what?! i just want to make life better for historically disadvantaged groups!
ben_vulpes: i think it's awesome
mircea_popescu: i thought it's obvious ubi is for the incompetent sluts that are "going to college" and the assorted ghetto scum "tryna make it in dis game"
ben_vulpes: "you know i really like this ubi idea; imagine the cambrian explosion of art and culture that would happen if people didn't have to work to eat, right? well imagine if *everything* were free, not just food internet and housing. it's not like we need tax receipts to pay for it, just increase the national debt a little! i doubt it would even come close to the cost of an f35 to make everything free."
CompanionCube: I don't think that's the idea of UBI