<devyn>
trying to use every feature of SQL in one query, are you?
<devyn>
(sarcasm)
<devyn>
:p
<whitequark>
that's actually production code which does in minutes what the previous (ruby) version did for hours
<whitequark>
and it doesn't need a fucking task scheduler
<whitequark>
minutes? and by minutes I mean recalculating stats for entire lifetime
<whitequark>
for scheduled recalculation it's seconds at worst
<devyn>
awesome
<devyn>
I tried using redis and mongo and shit for a while, but then I realized I was doing a lot manually that PostgreSQL would do for me and probably faster, with a lot less database<->application bandwidth required
<devyn>
and it's not the CPU time that gets you, it's all the damn IPC or worse, TCP
<devyn>
postgres is really damn good at optimizing anyway
<whitequark>
postgres is a better mongodb than mongodb, if you use hstore
<whitequark>
you can write queries for json in real sql and it will even index that
<devyn>
I know
<devyn>
it's great
<devyn>
that and lots of NoSQL DBs advertise their lack of schemas as if that were a good thing
<devyn>
postgres' relatively strong typing is really great
<whitequark>
yeah, they still have a schema, it's just implicit and uncheckable
<glowcoil>
whitequark: omg your metamorphosis tweet
<glowcoil>
4:56:44 <+whitequark> now, what if it explicitly says "heroin" ?
<glowcoil>
5:09:51 <+joelteon> is it by the velvet underground
prophile has joined #elliottcable
<alexgordon>
glowcoil: you'lll like this
<whitequark>
glowcoil: what about that tweet?
<alexgordon>
glowcoil: GCD has dispatch groups, and it occurs to me that they can be passed to called functions for a very flexible concurrency model
<alexgordon>
ever feel like you're on to something but you're not quite smart enough to figure it out?
<prophile>
all the time
<prophile>
that's 99% of research right there
<prophile>
unless you happen to be richard feynman
alexgordon has quit [Quit: My iMac has gone to sleep. ZZZzzz…]
eligrey has joined #elliottcable
<glowcoil>
whitequark: i just really liked it
<glowcoil>
whitequark: haha
<glowcoil>
so when alexgordon gets back somebody tell him that
<glowcoil>
scope overloading is in c and haskell because types have different namespaces than variables :p
<glowcoil>
also gcd dispatch groups sound promising
<glowcoil>
or w/e
alexgordon has joined #elliottcable
perrier has quit [Remote host closed the connection]
perrier has joined #elliottcable
<glowcoil>
alexgordon: so, c and haskell basically have overloaded scopes because types etc. have diff. namespaces than variables
<glowcoil>
alexgordon: also gcd dispatch groups sounds cool
<alexgordon>
hey glowcoil
<alexgordon>
glowcoil: yeah but what you can do in furrow is have a function and a variable with the same name
<alexgordon>
if the compiler can eliminate one, then it will use the other one
<glowcoil>
alexgordon: aren't functions just plain old values?
<alexgordon>
glowcoil: yes
<devyn>
so, making a filesystem where everything is both a file and a directory