NEWS:

Archive for the 'PostgreSQL' Category

PGCon 2011 - schedule released

Sunday, March 6th, 2011

The list of talks and speakers for PGCon 2011 has been released. For 2011, we once again have a strong collection of talks that will appeal to a wide range of attendees. Registration will open later this week. Be sure to start making your travel plans.
Of particular note is the excitement within […]

Pentabarf hyperlinks

Sunday, March 6th, 2011

Links within events in Pentabarf are done like this:
[text](http://example.org/)

Pentabarf - exporting the schedule

Monday, February 28th, 2011

When exporting a Pentabarf schedule, your talks must be accepted and reconfirmed in order to appear on in the schedule. Not just accepted.
In this article, we assume your conference id = 7. Adjust to suit your situation.
This query gives you a list of the accepted talks:

SELECT event_id FROM event WHERE conference_id […]

PGCon 2011 - schedule delayed

Monday, February 21st, 2011

On Saturday, I tweeted that the schedule for PGCon 2011 would be released. I was wrong. We are having a hard time choosing from amongst all the talks we have received. Choice is a fine problem to have, but we apologize for the delay.
All submitters have been emailed about this delay. […]

Carved in stone

Wednesday, February 9th, 2011

This was said by me on IRC today:

You say ‘ignoring a large user base’ as if there is something wrong with that.

PostgreSQL has a long history of not catering to the masses. This is what makes it such a great tool.

Only well thought out and well conceived features go into PostgreSQL.

And someone else said: […]

Sending out a URL for password reset

Friday, September 17th, 2010

Quite some time ago, FreshPorts and The FreeBSD Diary both moved from clear text passwords to password hashes. As such, you are no longer able to recover your password. You had to email me. This is extra work for everyone. Let us automate this.
The first, step, is a table:

create table user_password_reset(
[…]

A simple nested loop

Sunday, July 11th, 2010

In a previous post, I wrote about a suspected LIMIT problem. It turns out that suspicion proved correct. The solution was to move to a nested query which limits the underlying data and then allows the outer query to grab all the associated fluff that surrounds it.
Here is the fix to the original […]

PGCon 2010 - schedule

Thursday, March 4th, 2010

The PGCon 2010 schedule has been announced. Have a read of our outstanding lineup, see where people come from to PGCon, and get your registration started.

HAST - High Availability Storage

Monday, February 22nd, 2010

HAST has just been added to FreeBSD:
HAST allows to transparently store data on two physically separated machines connected over the TCP/IP network. Those two machines together will be called a cluster and each machine is one cluster node. HAST works in Primary-Secondary (Master-Backup, Master-Slave) configuration, which means that only one of the cluster nodes can […]

Got ISO? Create USB boot image

Thursday, February 18th, 2010

The liveusb-creator is a cross-platform tool for easily installing live operating systems on to USB flash drives. It runs on various operating systems and allows you to create a bootable device from an ISO image.
This could be useful for advocacy purposes.