I didn't want to confuse the post much but, from the graphic, it's shocking how blunted serum melatonin is in both autism and schizophrenia relative to controls.

sometimes i'll go look at it when I need a little pickmeup lol

It's because their comments have significant zaps. I agree it's weird though

BTW is there a bug in the SN keyboard because if I make a spelling mistake, I can't delete it, it just keeps running through the suggested words

If you're on Android @sox is working on a fix.

The sound is the highlight for me

I've always though that philosophically what should be aimed for is the most coherent and easily expressible data model that minimizes redunancy, but with a syntax and subroutine library that allows for quick retrieval of even highly nested relational structures.

That is the aim. We call this database normalization. It's the right way to design these systems. In practice, you often denormalize data for performance reasons because there are limits to how fast a computer can access and process data especially when it is spread around.

When you're joining tables, which are each a collection of files on your harddrive, you are randomly accessing another collection of files for each join. Indices can help the database know exactly which file it needs to read to get a particular row, but any file read is slower than none.

I try to keep our data "normal," so we always know what is "true," whether I end up also denormalizing the data or not.

I think the SQL standard should evolve to address polymorphism like this directly though. It's incredibly common and has no direct solution afaict.

I'm chopping up some LED strips for my office and I bought a 12V power supply when I need a 24V. Much sad.

Seriously I'm not sure. It sounds like doing it right requires a lot of maintenance.

I just wanted a cool fish that I can nod to when I get into work or imagine is cheering me on when I'm troubleshooting a bug.

I hear good things. They are almost too elegant though.

I'm more of a goldfish kind of guy but from what I'm reading they are high maintenance.

Also give it a name plate.

Gulp Spa Manager

I want to name it Gulp.

I probably shouldn't get a fish.

Yes. It's been that way for awhile. Currently ranking is like this:

((sats + boost + (comment_sats * 0.25)) * 0.3) - downsats - (comment_downsats * 0.1)

I see that. It's kind of like a jukebox now. We're all at the mercy of the biggest spenders. We have to beat em or join em.

Or maybe we'll be forced to figure out a fair way to rank territories too.

nic carter is such an expert X troll that the best bitcoin X trolls are getting totally owned by him.

the neuron fry that is bitcoin twitter is so depressing.

At some point I started ignoring the top spot because it never changed.

Big boosts can dominate the front page for a day or two now.

I suspect that'll be better all things considered.

I'm already noticing myself zapping more to control ranking more. I can't use myself as a guinea pig, but I wasn't expecting that. Still, I suspect most of us long haulers got used to relying on our trust to influence ranking.

Thanks. I'll try to remember this next time I'm in that code.

I've removed top boost pinning given some of the recent ranking changes. If you'd like, I'd be happy to prorate a refund.