wulczer

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.

wulczer

11 anni fadiscuss

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

wulczer

11 anni fadiscuss

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.

wulczer

12 anni fadiscuss

Sorry, ticked off my OCD :)

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

wulczer

12 anni fadiscuss

Thanks!

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

wulczer

12 anni fadiscuss

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!

wulczer

12 anni fadiscuss

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.

wulczer

12 anni fadiscuss

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.

wulczer

12 anni fadiscuss

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.

wulczer

12 anni fadiscuss

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/

wulczer

12 anni fadiscuss

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.

wulczer

12 anni fadiscuss

http://xkcd.com/447/

wulczer

13 anni fadiscuss

Logs subpoenaed from your ISP show that you were using Tor between 3:10 and 5:23 PM on 02/05/2012.

Logs from forensic analysis of a breakin to EvilCorp show that the attacker came in from Tor and was downloading secret data from 3:10 to 5:23 PM on the same day.

Not enough to prove anything, but there's definitely some circumstantial evidence there.

wulczer

13 anni fadiscuss

Why can't you use a connection that has issued LISTEN for anything else? In fact, I'm fairly sure you can use it normally.

We're using NOTIFY to broadcast database changes to services that should react to them and it's quite a nice way to separate concerns: process A just writes to the database, a trigger issues a NOTIFY, process B checks and notices there's been a change.

Edit: I see, the code in the post suggests that the connection needs to be stuck in a select() (I should know, I contributed a largre chunk of psycopg2's async code handling). You just need to use an asynchronous driver and you can happily LISTEN and do queries at the same time (of course you won't get notifies while a query is processing - the Postgres protocol has no concept of multiplexing).

We're using Twisted and happily mixing queries and NOTIFY.

wulczer

13 anni fadiscuss

Reminds me of http://www.supersimplestorageservice.com/

wulczer

13 anni fadiscuss

BTW, I think at least in Peninsular Spanish you'd say "Viva Brasil" (omitting the article).

wulczer

13 anni fadiscuss

We wrote a similar utility for our ORM-for-SaaS library some time ago, using lxml if available and falling back to ElementTree:

https://github.com/ducksboard/libsaas/blob/master/libsaas/xm...

Bear in mind that both approaches are lossy - trying to support every XML quirk would quickly lead to reimplementing the libxml wheel...

wulczer

13 anni fadiscuss

Not really, the ones calling down to date_trunc should be marked as STABLE, since the underlying function is STABLE.

  psql=$ \df+ date_trunc
     Schema   |    Name    |      Result data type       |        Argument data types        |  Type  | Volatility |  Owner   | Language |    Source code    |                     Description                      
  ------------+------------+-----------------------------+-----------------------------------+--------+------------+----------+----------+-------------------+------------------------------------------------------
   pg_catalog | date_trunc | interval                    | text, interval                    | normal | immutable  | postgres | internal | interval_trunc    | truncate interval to specified units
   pg_catalog | date_trunc | timestamp without time zone | text, timestamp without time zone | normal | immutable  | postgres | internal | timestamp_trunc   | truncate timestamp to specified units
   pg_catalog | date_trunc | timestamp with time zone    | text, timestamp with time zone    | normal | stable     | postgres | internal | timestamptz_trunc | truncate timestamp with time zone to specified units

wulczer

13 anni fadiscuss

I've been thinking about switching to sup a few times, but the inability to sync changes back to the IMAP server is a deal breaker to me.

If I mark an email as read in sup, I don't want it to show up as unread on my phone. If I delete an email on the phone, I don't want it to stay in sup.

I know there's been a branch of sup that synced IMAP flags from the local repo to the server, solving at least the read status problem. But it seems the version linked here does not include that branch.

wulczer

13 anni fadiscuss

We have one on https://demo.ducksboard.com/ too :)

Submissions

In which the widgets are set free

Making Twilio calls from Zabbix

What Ever Happened To... Start Pages

Show HN: Ducksboard launched a new API and is giving away free subscriptions

WebSockets, Erlang and shattered glass

We have a real-time API and we're not afraid to use it. Are you?

PostgreSQL 9.1 released

Runtime code modification. Erlang? No, Python

The Vietnam of Computer Science

Show HN: Ducksboard, from nothing to private beta in four months

Show HN: ducksboard, a real time dashboard using websockets

Nuclear Power Plant Locations and Global Seismic Activity

Nose unit testing achievements

Hack && Ship

comments