Thinh

9:00am

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.

11:00am

2:00pm

pg_reorg is a simple but very handy tool that allows to reorganize tables without downtime.It helps to eliminate bloat, reduce IO, improve performance, delete large portion of a big table.It may be especially handy in large sharded and replicated database environments.Unfortunately, not too many people are familiar with the tool. This talk demonstrates how this tool may be used for making database administration a little easier.

3:00pm

The key asset to many businesses is the data they store. So why do most programmers opt to implement their data integrity outside of the schema? Using concepts and methodologies from The Schemaverse, this session will show how you can benefit from creating self-validating databases, and discuss what limitations exist (real or preceived). Audience participation will be encouraged during the session.

10:00am

There are cases where a single DBMS vendor is not enough. In this talk we'll analyze how to painlessly solve the following real-world needs with an open source Tungsten Replicator: real-time integration, seamless migration, data warehousing and leveraging the power of a specific DBMS SQL dialect. Not only we will learn how to move data from MySQL to PostgreSQL in real time (yes, let's free those MySQL petabytes to PG users!), but we'll also discuss a fresh and important way of extracting data from PostgreSQL and making it available to other DBMSes. We’ll conclude with a demo of database updates moving in real time between different databases.

11:00am

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?

9:00am

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.

10:00am

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.

11:00am

The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. If you've ever wanted to use SQL to conquer the world, now you can do one better and conquer a universe. This talk will introduce you to the game mechanics and discuss the project's goals, growth and development.

1:30pm

A great overview of what quite possibly is the most important utility in the PostgreSQL arsenal, pg_dump and it's sister pg_restore. We will discuss overall usage, best practices as well as features not normally used (but should be) such as the toc file.