Andrew McMillan
Andrew McMillan
Andrew has been wandering around the open source world for about 15 years, getting increasingly involved in Debian, and in software projects involving the web, with PostgreSQL as a back-end database. In 1997 he got together with a bunch of mates and founded Catalyst IT ( http://catalyst.net.nz/ ), and was instrumental in the focus on free and open source software at Catalyst. He retired from Catalyst late last year to dedicate him more directly to free software development and the promotion of free and open source software.
He is currently responsible for three web-based applications, the most widely used of which is DAViCal ( http://www.davical.org/ ), a CalDAV server written in PHP. All three applications use PostgreSQL for their back end storage, including relatively advanced use of in-database functions, updateable views, and so forth. His real-world experience with these is extensive, and very relevant to the subject and content of the proposed talk. He has been a Debian Developer since 2002, and has been on the Debian policy committee since earlier this year.
Outside of the open source world his wife Heather have recently celebrated their 20th wedding anniversary, and we have two sons, aged 8 and 11, neither of whom can understand why their friends all use expensive and crappy operating systems. He started programming professionally in the early 1980s while working as an electronics technician. He jumped the fence as soon as possible thereafter and has subsequently held positions at all levels from programmer to application development manager. He has also been involved as a board member for Parents Centres of New Zealand, and as immediate past branch president for the Wellington branch of the New Zealand Association for Gifted Children.
Captain Abdul's Guide to PL/PirateSQL
This talk is intended as a fun overview of the PL/PgSQL language, presenting most of the interesting constructs of the language in the context of solving a real-world problem.
In this talk Andrew will endeavour to give the audience some appreciation of the capabilities of PL/PgSQL, including some of the newer possibilities of the language, approaching this using the real-world example of implementing a parser for the RRULE of an iCalendar, which is a real-world application used in the DAViCal CalDAV server for calculating the repeat occurrences of an event.
This talk was developed to provide people with an introduction to PostgreSQL's in-database functional language. Although PL/PgSQL bears some resemblance to Oracle's PL/SQL the differences are many and varied enough that it is a different language. Indeed most PostgreSQL users have never used Oracle or PL/SQL at all so have even less context to value this language. As a result, PL/PgSQL is something which is not well-understood, and this presentation was developed to help remedy that.
Published Oct 24, 2009.
Wow! Sounds like fun! - I think I might have to go to this one :-)
I propose not to wait until you earn big sum of cash to buy different goods! You should get the business loans or just term loan and feel yourself fine
Not every thing can connected with term papers I’m having, but students still shouldfind essays.
It sounds like an enjoyable conference for other open source developers, just came by while working on my sudoku solver site sudoku solver and thought id say hi!
I found this is an informative and interesting post so i think so it is very useful and knowledgeable. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing ability has inspired me. Really the article is spreading its wings rapidly...
This is the interesting information. Especially fascinating is the family's description!