Catch up on stories from the past week (and beyond) at the Slashdot story archive


Forgot your password?

Comment Re:One of the advantages of Linux (Score 1) 433

If you're using a sensible DB (these are all Postgres examples), I may be able to make your life a little easier.

If you want to compare rows, don't bother with a slow and clumsy self-join, use a windowing function and the lead/lag functions. e.g. to list the interesting events and time between them:

select date, message, lead(date) over (order by date) - date as time_to_next from log where type='interesting';

That only shows 'interesting' events, of course. If you want to show all the other events between the interesting ones as well, add a partition by clause to the windowing function to highlight interesting events, and lose the where clause.

And yeah, vim is a good quick and easy way to explore data. So in postgres, add 'export PAGER="vim -"' to your ~/.psqlrc file, and your query results automatically pop up in vim (may want to switch to unaligned output in that case using the \a toggle).

Comment Holy shit (Score 1) 87

I know that slashdot is now pretty much famous for being behind the curve on geek news, but in this instance they got scooped by The Today Program on RADIO FUCKING FOUR.

For people not in the UK who don't know what that's like showing off your new liquid Nitrogen GPU cooling system and your grandma saying "Oh that's nice dear, it's like the one the nurses put in the home last year".

Comment Re:Finally (Score 1) 274

I was using the same workaround. Just installed the new flash .so, and no longer need to. THANK FUCK. I was definitely with Linus that whatever the specification of memcpy, if your optimisations break a ubiquitous piece of software it's a regression. But it's also a good thing that Adobe fixed their broken code, of course.

I also had issues where periodically Flash would bring my system to a crawl - I've not seen anyone else mention that problem, but fingers crossed this'll solve that too.


Google+ Already At 10 Million Users 1223

An anonymous reader writes "I project that Google will easily pass 10 million users tomorrow and could reach 20 million user by this coming weekend if they keep the Invite Button available. As one G+ user put it, it is easy to underestimate the power of exponential growth." I bet if people post in the discussion that they need invites, we can scratch each other's backs here. I've been using Google+ for a few days now (Yes I will put you in a circle ;) and have a lot to love, but unless I can gate twitter and Facebook, the best interface in the world won't help me until I can convince my kids' grandparents to move.

Comment Re:what we need to avoid this (Score 1) 887

That's a terrible idea. They're not going to put the only copy of the data in front of you on your own laptop for you to type what the hell you want and tamper with the only copy of evidence. They'll clone the drive and have you decrypt that copy.

Then, when they don't believe that all you had were copies of hello.jpg they'll compare the disk with the original, see all the unrelated blocks being written to, and know for sure that you have hidden data. Plus evidence that you've attempted to destroy evidence from their investigation.

Slashdot Top Deals

A physicist is an atom's way of knowing about atoms. -- George Wald