PostgreSQL – Page 5 – Dan Langille's Other Diary

Speakers and travel

1 Comment / Open Source, Pentabarf, PostgreSQL / By Dan Langille / March 14, 2011

The following query pulls back the speakers and their travel: SELECT distinct S.name, S.email, CP.conference_person_id, arrival_from, arrival_to, arrival_number, arrival_date, arrival_time, departure_from, departure_to, departure_number, departure_date, departure_time FROM event E, view_event_person P, view_mail_all_speaker S, conference_person CP, conference_person_travel CPT WHERE E.event_id = P.event_id AND P.person_id = S.person_id AND E.conference_id = 7 AND CP.conference_id = E.conference_id AND E.event_state = […]

Speakers and travel Read More »

PGCon – keynote… made your travel bookings yet?

Leave a Comment / Conferences, Open Source, PGCon, PostgreSQL / By Dan Langille / March 14, 2011 / PostgreSQL

Although PGCon 2011 is just 9 weeks away, that time will fly past. People will start gathering in Ottawa early in the week for the two days of tutorials followed by two days of talks. PGCon is also a social event, so there will be many opportunities to mingle and meet other members of your

PGCon – keynote… made your travel bookings yet? Read More »

PGCon 2011 – registration now open

Leave a Comment / Conferences, Open Source, PGCon, PostgreSQL / By Dan Langille / March 9, 2011 / PostgreSQL

Registration for PGCon 2011 has opened. The list of talks is impressive. You’ll find something there for everyone. Again this year, as every year, we bring together developers and users from all over the world to meet and to learn from each other. PGCon has a consistent history of providing high quality for low cost.

PGCon 2011 – registration now open Read More »

PGCon 2011 – schedule released

1 Comment / Conferences, PGCon, PostgreSQL / By Dan Langille / March 6, 2011 / PostgreSQL

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 the GIS

PGCon 2011 – schedule released Read More »

Pentabarf hyperlinks

Leave a Comment / Open Source, Pentabarf, PostgreSQL / By Dan Langille / March 6, 2011

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

Pentabarf hyperlinks Read More »

Pentabarf – exporting the schedule

Leave a Comment / Pentabarf, PostgreSQL / By Dan Langille / February 28, 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 =

Pentabarf – exporting the schedule Read More »

PGCon 2011 – schedule delayed

Leave a Comment / PGCon, PostgreSQL / By Dan Langille / February 21, 2011 / PostgreSQL

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. The Call For

PGCon 2011 – schedule delayed Read More »

Carved in stone

Leave a Comment / PostgreSQL / By Dan Langille / February 9, 2011 / PostgreSQL

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

Carved in stone Read More »

How much are those volumes in the library?

Leave a Comment / Bacula, Open Source, PostgreSQL / By Dan Langille / December 22, 2010

I pretty much ignore my tape library. It asks for tapes when it runs out. However, I think I should be looking ahead and anticipating requests. Thus, I came up with this SQL query: [dan@ngaio:~] $ psql bacula psql (8.4.5) Type “help” for help. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, volbytes FROM media,

How much are those volumes in the library? Read More »

Sending out a URL for password reset

Leave a Comment / FreshPorts, Open Source, PostgreSQL / By Dan Langille / September 17, 2010 / PostgreSQL

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( user_id int

Sending out a URL for password reset Read More »