But that's because IBM has a strong presence in the SQL standard committee and can nudge it to standarise (post-factum) things they already implemented in DB2.

Since all of the previous states are there in the repo history, you can make that gif yourself at any moment!

  for c in `git log --oneline --reverse | awk '{print  $1}'`
  do
    clear; echo "$c"; git --no-pager show $c:README; sleep 1; 
  done

is what one could use on a terminal

You can remove the pipe to awk by replacing:

  --oneline

with

  --pretty=format:"%h"

Postgres at least will store rows roughly in insert order. So whether you're using integers or UUIDs for primary keys won't affect on-disk layout.

When scanning the index, the database will be traversing it in btree order, anyway, so as long as the values are comparable, ints or UUIDs shouldn't matter much.

Sorry, ticked off my OCD :)

It's better to say "key text" instead of "key varchar(1024)" and primary key already implies not null.

He was just going for an insult, it's not like he knows what he's talking about.

Obligatory Show HN where we first showed Ducksboard to the world (1301 days ago): https://news.ycombinator.com/item?id=2332464

Thanks for all the feedback and interest we got from the community through all those years and just because we now work at New Relic doesn't mean we'll stop procrastinating on HN!

congrats, will you still be working from Spain or do you have to relocate?

Thanks!

We're staying in Spain and there are plans to further grow the Barcelona office.

What is the epiphany here? What is the insight or enlightenment to be gained from this story?

I have my own, but I'm curious about what people believe is the moral of the story.

Don't be the chump who offers the rational middle ground as your opening bid.

I'd say there are at least 2 morals.

First: You don't get what you don't ask for. the other person might really only want a quarter of the cake, but by asking for more than your "fair share" you open the door to allowing them to give you what you want.

Second: By asking for the whole thing, you have placed yourself in a position of power and privilege. The mere act of asking for more implies that you think you deserve it. Someone mentioned posturing in another comment.

Selfishness is a virtue and not a sin as taught and propagated through society, religion and culture.

If you wish to get what you want, you have to use any means possible. And there is nothing wrong in it.

Actually if you look at it that is how most successful people get successful.

Think of your own good first, even if that's not very helpful to the other guy.

That's also why, when you go to the movies and it turns out tickets cost the same regardless of the film, you should go for the one with the longest running time.

One of the important reasons Postgres connections are serviced by a separate process is that if that process segfaults, you only disconnect other connections (because if might have tainted shared memory when it died), but the main database process keeps running and you can reconnect immediately.

Not quite. If a backend segfaults, postgres will detect it and immediately terminate all connections and exit. When it restarts, it will enter recovery mode. It does this because a segfaulted backend may have corrupted shared memory. The only way to fix that to restart in recovery mode and replay the WAL.

Almost two years ago the "The Pulse of Spain" was made, based on the same idea (disclaimer: the designers of this are also designers for our product (and dear friends)).

It's in Spanish, unfortunately. You have to click on the tiles to activate them and they'll start pulsating. If you have Flash, there'll be sound.

The link is:

http://img.actibva.com/pulso2/

The use of the sound is very interesting, since it seems to allow to create loops.

This is awesome. It came up with some cool rhythms as well. Nicely done, kudos to your friends.

Since everyone is plugging their own: here's a identity provider daemon written in Go:

https://github.com/wulczer/persona-idp

It uses my Mail Transfer Agent to identify, so I can just use me email password to log in to Persona-enabled sites, but you can easily swap it out for a different credentials checker.

That's quite cool - actually that'd be exactly what I want to host myself.

Not a fan of go (cough The stripe CTF made it again clear that go get isn't exactly what I want, ever), and don't want to build stuff on my box, but I'll certainly check it out. Thanks for chiming in!