PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Rob Sullivan
Day Talks - 2 - Friday - 2012-05-18
Room MRT 205
Start time 10:00
Duration 01:00
ID 462
Event type Lecture
Track Case Studies
Language used for presentation English

Dear SQL Server, I'm filing for divorce.

Falling in love with the free spirit of Postgres

Using the StackOverFlow datasets, we'll ditch all the drama of a Microsoft stack and convert from SQL Server to Postgres on Windows. Once we do that, we'll migrate our entire DB and Web App from Microsoft to Linux using Postgres and Mono with as few code changes as possible.

Having the StackOverFlow dataset loaded into SQL Server and a mock StackOverFlow app in ASP.NET MVC3, we are going to show various ways to ETL into Postgres from SQL Server on Windows. Once that is done, we'll go over some basics of going from Postgres on Windows to Postgres on Linux as we attempt to migrate our app. Once we get our back-end moved, we'll show just how easily you can wire up ASP.NET MVC3 to Postgres and then move our entire stack to Linux using Nginx and Mono. Since I am a SQL Server DBA, I will also be adding lots of opinion on where Postgres really shines compared to SQL Server and where it doesn't. This session will be informative, entertaining and incredibly nerdy.