This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
View analytic

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Tuesday, September 27


Introduction to Ruby and Rails with PostgreSQL

This hands-on workshop will present the Ruby programming language, the Rails web application framework, and usage with PostgreSQL. We will spend the morning digging into the Ruby language in order to form a solid foundation for the afternoon session, in which we start building a Rails application backed by PostgreSQL. We will also learn how to manage your database schema, and make use of Postgres specific features from a Rails app.

Knowledge of Object Oriented programming is assumed.



Tuesday September 27, 2011 9:00am - 5:00pm
D San Jose Convention Center
Wednesday, September 28


Using Open Source Tools - Project Mogwai ERDesigner

Project Mogwai can be found at mogwai.sourceforge.net. [I am not affiliated with Project Mogwai.] There are several data related components, but the focus of the mini-tutorial is ERDesigner.

A real-world use case will be presented, involving:

1. Reverse engineering of an existing database.
2. ERD creation and modification.
3. Testing with automatically generated DDL.
4. Provisioning for production needs.

Media will be available with the Java runtime and ERDesigner, so bring your laptop!



Wednesday September 28, 2011 9:00am - 10:30am
B4 San Jose Convention Center


Using vFabric Postgres - A DB User Perspective

vFabric Postgres is a new offering from VMware. vFabric Postgres is available either as deployed by VMware vFabric Data Director or as a service on CloudFoundry.com.

This talk is bout using vFabric Postgres from a user's perspective.



Wednesday September 28, 2011 2:00pm - 2:45pm
B4 San Jose Convention Center


Sequel: The Database Toolkit for Ruby

This talk is an introduction to Sequel, the ruby database library. Sequel provides a simple, powerful, and flexible API for interacting with SQL databases. Sequel allows you to write all your SQL code by hand if you want, but it also allows you to use ruby objects to represent SQL concepts, so that you rarely need to. Sequel includes a comprehensive and extendible ORM with extensive support for manipulating associated objects. Sequel supports advanced database features such as prepared statements, bound variables, savepoints, two-phase commit, transaction isolation, common table expressions, window functions, master/slave configurations, and database sharding.


Wednesday September 28, 2011 4:00pm - 4:45pm
B4 San Jose Convention Center
Thursday, September 29


PostgreSQL and J2ME (Java Micro Edition) - A How-To Guide

Database access from small-footprint hardware is becoming a mainstream problem for application developers. Given the wide disparity in platform capabilities, how can you make the best use of Postgresql from a mobile platform?

1. Overview of J2ME/CDC/MIDP architectures
2. The 'normal' answer to database connectivity
3. Security
4. More than web services
5. Wrap - up / Q&A



Thursday September 29, 2011 11:00am - 11:45am
B4 San Jose Convention Center


PostgreSQL and Ruby: Libraries and their Gaps

The PostgreSQL database ships out of the box with a wide variety of unique features, including powerful type system, a built-in key-value store, full text search, cryptography libraries, and a huge tool chest of available contrib modules for all kinds of different tasks.

Unfortunately, many Ruby developers have been locked in a box by less powerful data stores and while they have been leaning on PostgreSQL's rock-solid storage engine, they have constrained themselves to the lowest-common-denominator features.

In this talk, I want to encourage Ruby developers to reach beyond their usual set of tools, and I will talk about some of the long-standing features you can take advantage of today. We'll also talk about some of the features which aren't as well supported yet, and look at how we as a community can work together to close that gap and bring the full power of PostgreSQL to bear on our problems.


Thursday September 29, 2011 1:30pm - 2:15pm
B4 San Jose Convention Center


On-Demand Replication: Turbocharging Productivity

This talk will discuss the impacts and implementation of fast, automated provisioning of replicants -- both as writable 'forked' copies and read-only streaming replica 'followers' of PostgreSQL databases, as implemented at Heroku on a large scale as a service.

Included will be a brief summary of use cases, anecdotes, and challenges, as well as new trade-offs in the design of applications and partitioning of data. In addition, the technical architecture behind such a service and how it unifies rock-solid, low-impact disaster recovery, replication, and database-forking will be covered.



Thursday September 29, 2011 3:30pm - 4:15pm
B3 San Jose Convention Center
Friday, September 30


The Cure for SQL Race Conditions: True Serializability in 9.1

If you don't know what a race condition is, or you thought that SQL was immune from race conditions, this talk is for you. These are bugs that slip through testing, are hard to track down, and might cause invalid data in your database.

The good news is that 9.1 offers a cure: true serializability through Serialized Snapshot Isolation (SSI). It's easy to use and magically detects a live SQL race condition and turns it into an error.

Oh, did I say "magic"? It's actually technology developed by Kevin Grittner and Dan R.K. Ports, based on some fresh research by Michael J. Cahill, et al.

Of course, there is a catch: because race conditions may turn into errors, application developers need to be prepared to retry transactions when that happens. This is usually a minor burden, however, because all you need to do is send the same transaction again.



Friday September 30, 2011 9:00am - 9:45am
B4 San Jose Convention Center


Exposing the power of PostgreSQL to Ruby

Powerful datatypes such as hstore and json give PostgreSQL the most compelling feature of many NoSQL databases, which is management of semi structured data. Unfortunately the popular Ruby ORMs try very hard to equalize all databases, so these and other features often go unnoticed or underappreciated.

While there are some Ruby libraries providing application-level bindings for these features, they are generally new or otherwise not well-known. Developers are also often further discouraged by having to sacrifice the benefits of their ORM to use these libraries. Fortunately, the situation is starting to improve.

We will go into detail about what was needed to bring hstore support to Ruby, survey the current PostgreSQL and Ruby landscape, and discuss what needs to happen in the near future to improve their relationship.



Friday September 30, 2011 10:00am - 10:45am
B4 San Jose Convention Center


Advanced Query Construction & Reporting using HTSQL

Having difficulty translating complex business inquiries into SQL? Want an instant web interface for your relational database? Up for some tasty dashboards? Come hear about HTSQL.

HTSQL is a URI-based high-level query language / web service for PostgreSQL designed especially for creating interactive dashboards and answering complex business inquiries. We use HTSQL as a REST query interface for data integration and ad-hoc reporting by technical users or ``accidental programmers``.



Friday September 30, 2011 11:00am - 11:45am
B4 San Jose Convention Center