104800+ entries in 0.06s
mircea_popescu: asciilifeform, seems
to me you can always fill
the cracked moduli
table at
the
time you announce
them
to deedbot. shouldn't lock your main moduli
table in being a diff
table.
mircea_popescu: i can't see how
this could possibly work ?! so you made a special, "this is where we copy cracked moduli"
table, and inserted into it, and
this slowed your querties on your main
table ?
mircea_popescu: if it's cheap enough for deedbot
to broadcast, it's cheap enough for an insert
mircea_popescu: well, i imagine eg
the cracked moduli get sent
to a
table of
their own.
mircea_popescu: SELECT LAST_INSERT_ID(); always faster
than select count*
a111: Logged on 2017-03-10 19:34 asciilifeform: Framedragger: i am increasingly finding
that 'general purpose db' is, like
the infamous 'vise-grip',
The Wrong
Tool For Every Job
mircea_popescu: asciilifeform, from
the same "first principles" you can expect impossible properties in extended geometries. you're familiar with
this, yes ?
mircea_popescu: which is why i don't agree "wild west ie wisconsin in 1860" is "braindamaged". notwithstanding
the sheer lack of convenience stores.
mircea_popescu: now, whether
the abstrusity has any good practical reason,
that's a different concern. but in principle you can end up with
the sad fate where both "trying
to go
to
the store" is a lifetime adventure and
there's very good reasons for it being so.
mircea_popescu: asciilifeform,
there ~can~ be a reason for it. you're saying "whether
the geometry is braindamaged or not depends on whether my naive assumptions of metrics are satisfied or not,
therefore only some of
the n-spheres are valid geometry". not so.
mod6: Most of
these need not exist. But, alas, sacred cow. Na na na na. Can't
touch
this.
mod6: For instance,
the database in
the salt mine here, is 400+
tables and growing.
mod6: I kinda like
trying
to performance
tune databases a bit... just as long as I don't have
to "own"
the db.
mircea_popescu: and since most people a) have
to deal with "idea men", ie dorks whose undisciplined mental process was never really checked by reality and b) don't ever have
the authority
to
tell
them off... well... of course
the result is
temptation
to suicide.
mod6: Ususally
these guys come in and have
to wrangle
this mess of shit.
mircea_popescu: but databases have
this problem asciilifeform ran into,
too, whereby
they dun care about your mental models, adapt
to
their needs or go awya.
mircea_popescu: i
think
the problem is rather
that people
try
to do it as work for hire. which works well enough for "flash programmers" and php copy-pasters and i guess "web designers".
mircea_popescu: mod6, amusingly, dba is one of
the few it fields i'm somewhat familiar with. never wanted
to kill self.
mod6: this is
true, explain plans can be hard
to decipher when you first start looking at
them.
mircea_popescu: asciilifeform, as a general rule, when diagnosis
tools are 0 help pretty much everywhere
the problem is not
the "poor quality of
the ultrasound". you gotta be a doctor
to read
those.
mod6: No,
Thank You for playing. I'll go make screwdriver handles instead.
mod6: "OMG YOU CAN'T PUT IN KEYS!?
THINK OF
THE CHILDREN!!1"
mod6: It can be especially bad when you inherit a wing-ding pile of garbage (i.e. no constraints,
the usual nonsense)
that also happens
to be a sacred cow.
mod6: That's one role
that I've never wanted
to have. I've watched
these people wanna kill
themselves for 20 years.
mod6: It was recently
that someone was like, "Hey, come work for us,
there is a role as Database Arch..." "Umm. No
thanks..."
mod6: I've always
thought
that DBAs are
the most masochistic of
the bunch.
a111: Logged on 2018-04-26 03:41
trinque: re: db, I'm reserving a lul now for when asciilifeform discovers
that postgresql does, in fact,
tell you what an operation will cost before you run it.
trinque: goodnight, many heads of
the
tit hydra
trinque: mircea_popescu had it, industrial machinery, organizes gigantic sets, does a few
things
to make sure
the wad isn't lost.
trinque: re: db, I'm reserving a lul now for when asciilifeform discovers
that postgresql does, in fact,
tell you what an operation will cost before you run it.
☟︎ ben_vulpes: hey, one of my deliverables failed
the external
tests once
trinque sees untested deliverables on
two legs every day
ben_vulpes: "can never demonstrate
the absence of bugs" notwithstanding, i don't know why folks don't slow down and
test
that
their deliverables do what
they claim before making claims
ben_vulpes: links
to
the ml advocates,
their jupyter notebooks, and
the
troubles
they have "getting from research
to production"
too i'd hazard
mircea_popescu: there's a very deep link between "putin doesn't understand how
the world works ; notwithstanding which he stole our election" and "cell (5,7) on your screen".
mircea_popescu: that it's popular with
the sort of meat puppets populating
the pantsuit vatfarms is unsurprising -- it's pretty much engineered
to cater
to
their batshit insane worldview.
mircea_popescu: worst possible assumptions made for
this gui-centric non-db system.
mircea_popescu: unlike vbasic and moreover,
the very fucking NOTION of "here is a list of cells, grapghically displayed"
ben_vulpes: i exaggerate, db constraints and stored procedures and
transactionality and permissions are all very nice
things.
ben_vulpes: when will it fire will it fire
today let's find out
mircea_popescu: ben_vulpes, i dun agree ; excel is clown car.
the db stuff... not really.
ben_vulpes: btw mircea_popescu #templeos-irc is a wall of noise,
terry is out
to lunch
ben_vulpes: trinque: you know i
tell folks i squirt grease on
the largest $problem-domain spreadsheet
they could possibly imagine when
they ask what i do; i can laugh and cry about it allll day
ben_vulpes: that said
the rigorish
typing of postgres has been a boon in
this one circumstance where
the
tower of complexititus
threatens
to overwhelm me at every step
trinque: ben_vulpes: you should hear my oil buddy
talk about excel sometime
mimisbrunnr: Logged on 2018-04-25 01:18 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.
trinque: ugh, shame on me.
that was running in a
tmux
mircea_popescu: such a good
thing five successive generations of nulands did in germany.