PL/Parrot is the Parrot Virtual Machine, embedded into the PostgreSQL relational database. This means that any Parrot language has the opportunity to become a PostgreSQL Procedural Language (PL). PL/Parrot supports writing stored procedures in the following languages:

This talk will give a quick introduction to Parrot VM and Rakudo Perl 6, and why you would want them in your database, including a status update of the current feature set of PL/Parrot and PL/Perl6. Example stored procedures in each language will be shown and, time-permitting, the internals of how PL/Parrot works will be described. More information can be found at pl.parrot.org .

Bio: Jonathan "Duke" Leto

Jonathan is an open source hacker who currently focuses on the Parrot Virtual Machine and Rakudo Perl 6, as well as being the maintainer of many CPAN modules. He has been involved with Google Summer of Code since 2008 and is currently organization administrator for The Perl Foundation and Parrot Foundation, as well as a mentor for RTEMS on Parrot. Jonathan received a masters in mathematics from University of Central Florida and has published several papers in the field of differential equations. He enjoys discovering wheels within wheels.

Location-based services are all the rage these days, and almost everyone has a latitude and longitude or two stashed away in a numeric column somewhere. But, there is so much more to it than just a point. Once relegated to government and academia, geographic information systems are becoming increasingly visible. With the PostGIS extension, PostgreSQL is a first-class geodatabase and an incredible platform for working with spatial data, but what is PostGIS and why would one use it? And beyond PostGIS there are a dizzying array of tools to load, visualize and interact with the wonderful geospatial information in your database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries.

Bio:

Edwin Knuth spent quite some time as a sysadmin and web developer before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geographic Information Systems and realized that GIS was just a really neat database application. In Alaska, Edwin worked on several unique projects, including building bat detectors and using PostGIS to manage a wireless sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much.

Postgres and Node.js, a powerful event-driven programming environment paired with our favourite open-source database, now together in the same great package! Aurynn will be going over the node.js environment, how it differs from other programming environments, and how to use postgres with node.

Aurynn Shaw is Lead Userspace Developer at Command Prompt, Inc. She has come all the way from another country to present this talk, so don't miss it!