448900+ entries in 0.287s
decimation: ^ also note most people are unwilling
to pay for something who knows how
to db
assbot: Logged on 02-07-2015 21:36:09; phf: maze of
twisty little passages, all alike
ben_vulpes: and because none of
them were designed for
that in
the first place because a) it's hard and b) fucking retards write nosql stores for hackernooz points
the algebraic layer
turns out
to never actually work. or it locks everything up while running queries
that a real db would plan handle like a boss
decimation: I'm suggesting an intermediate step where you query your nosql db properly and place
the results into a structured relational db
ben_vulpes: much like any c project eventually grows a miserable half-assed implementation of an eighth of common lisp any nosql project eventually
tries
to implement relational alggebra
decimation: well, yeah
that's
the real-world situation.
ben_vulpes: otherwise you're going
to start running
the kind of braindamaged queries your 'nosql' layer support and
then glomming it all
together into something representing a query in application code
decimation: nosql can be used
to sort
through your shit into a proper db
decimation: the only situation I can imagine is if you have a gigantic pile of disorganized data,
that probably has a structure
ben_vulpes: (and even
that can be handled by mother postgres at rather high efficiencies
these days)
ben_vulpes: i've yet
to see
the real world problem
that a nosql db was actually
the right solution
to
that wasn't actually a cacheing/cdn problem
decimation: yeah,
there are situations where 'nosql' is appropriate, but plenty of situations where you want structured queries
too
ben_vulpes: decimation: i'm finally seeing
the
tide receed from mongo's highwater
ben_vulpes: you can even derp
the raw binary into pg if you're so inclined
ben_vulpes: if you're storing as
the appropriate ints, floats, doubles, strings etc
decimation: or using it
to feed another
tool, like has been accomplished
ben_vulpes does not see
the problem with hashing values queried directly out of
the db
ben_vulpes: but perhaps
there's a good reason for writing
the blocks directly
to disk
that i'm not grasping
ben_vulpes: the whole
thing should be in sqlite at
the very least
decimation: I suspect satoshi intended on making a
transactional database using
the block .dat files at a later date
ben_vulpes: i've lost weeks, months of my life
to
the unqueriability of mongo and phriendz
decimation: I can see 'saving space' for
the
transactional
table, but why also keep
the blockchain in binary form?
ben_vulpes: p. sure
the
transaction indices were
tossed for space saving reasons aka shitgnomery
ben_vulpes: i was under
the impression
that it was either not relational or was only being used in bitcoind as a kv store
shinohai: I just now got connected
to mp's node so i guess i got
to start over
ben_vulpes: has anyone verified
the full chain as puked out from asciilifeform's `shitblock`?
ben_vulpes: if you had
the whole blockchain querieable in postgres, you could infer account balances in
the usual fashion and sell reads over a pg connection
ben_vulpes: decimation: now is when i confess
to a quarter-implemented blockchain->relational db importer
☟︎ decimation: such a
thing would be needed for
the 'private wallet query service'
that ascii and I discussed last night
decimation: or is it just saying
that
they aren't databased efficiently?
decimation: wait why don't
they have
the
transactions?
assbot: Logged on 02-07-2015 20:44:30; ascii_field: 'getdata is used in response
to inv... ...t can be used
to retrieve
transactions, but only if
they are in
the memory pool or relay set - arbitrary access
to
transactions in
the chain is not allowed
to avoid having clients start
to depend on nodes having full
transaction indexes (which modern nodes do not).'
decimation: oh no
the reddit owners
treat
the
tens of
thousands of people
that work for
them for free as slaves!
☟︎ decimation: lul "As much as Victoria is loved,
this reaction is not all a result of her departure:
there is a feeling among many of
the moderators of reddit
that
the admins do not respect
the work
that is put in by
the
thousands of unpaid volunteers who maintain
the communities of
the 9,656 active subreddits, which
they feel is expressed by, among other
things,
the lack of communication between
them and
the admins, and
their disregard of
the
thou
Vexual: yeah
they wash up here like flotsam
Vexual: lol, u run on
tin cans
too?
diana_coman: I did not really check it, but if it works even in
this neck of
the woods, it can't really be
Vexual: yeah, i might need
to find some flotsam before i find some flotsam
diana_coman: btw Vexual, once you get it, you might want
to come by
to me as I can give you some stuff
to get started
diana_coman: there was some concrete info on
this in
the last post on
trilema I
think
diana_coman: and lol, I actually did not manage
to wear out even one of
those
jurov: diana_coman: do you still have
the harness pic somewhere?
jurov: not gonna answer
them, come out
there
Vexual: thanks for
the insight conman
jurov: as diana_coman can
testify
jurov: yes. you must
take a photo with a chair on
the head
to receive it ingame
Vexual: i'll
take
two cruddy hos and a clump of fat slag please
Vexual: faark
theres a cookbook (tm)
Vexual: chairs for
the head is a pillow?
Vexual: oooh, screenshots,
thanks
Vexual: yeah i googled it, i felt a bit silly
typing "is witcher multiplayer"
Vexual: "whats it all about?" "just
try it" <when did games become like lsd?
HeySteve: but
there's no experimenting in what you can make from
them
HeySteve: the
thing about Witcher 3 is you can amass a huge inventory of weird parts, like monster
tongues and bits of string
jurov: HeySteve:
there's mining delay in eulora now, so you can multitask :D
HeySteve: once I'm done with Witcher 3, I want
to see if I can make some progress in figuring it out
Vexual: i must say im more
than a little intigued, even discounting
the favours you mentioned
davout: pm me a postal address and i'll send
them
davout: jurov: if you want a couple pogos i can send
them
to you
trinque: in
that case I'd like
to claim my family's pre-mussolini wealth from italy
assbot: Logged on 30-06-2015 04:33:53; asciilifeform:
http://log.bitcoin-assets.com/?date=30-06-2015#1181553 << yes,
there will be plenty of 'work'
to be had
there, re-converting
the island back into a u.s. bordello as it was in batista's
time; 'privatizing' and demolishing
the spiffiest pharama plants in
the western hemisphere; shipping
the best doctors
to drive cabs in nyc; etc
trinque: something suitable for
the human-like creatures eating food-like matter on a couch-like object in a home-like hovel
they quasi-own
trinque: Since Facebook's 2012 IPO, it has needed a compelling "story"
to
tell corporate investors, says IBRS analyst Guy Cranswick. << btw
the new meaning of
the quotation mark in english is herein lie lies
mod6: seems like
this is going faster, but we'll see how long it
takes
to go from 300k-350k
mod6: typical sync via irc seeding
took me ~6 days
decimation: note
that scamarkets were generally
the only market for most of history
decimation: maybe if we end up in
the same sharishka we can work on identifying
the voice of
traitors
together
decimation: asciilifeform:
this is
terrible news, now all learning algorithms are going
to need 'political filters'
decimation: apparently if you commit a felony involving violence,
the police can summarily execute you if
the 'feel you pose a
threat'