For many years, serious database aficionados have preferred the Postgres database system. It’s industrial strength – many installations store terabytes of data. It’s fully open source (not controlled by a predatory corporation). It’s fast and easy to use. Full text search is built-in. It’s the default database for all applications deployed to Heroku.
In the 65 minute Meet PostgreSQL tutorial, respected database expert (and world-traveling teacher of “The Database is Your Friend” workshops) Xavier Shay teaches the most useful and powerful features of Postgres. You’ll learn to use the built-in full-text search and optimize it. You’ll work with triggers and indexes. You’ll save yourself hours of frustration with tips for using Postgres smoothly with Rails 3.
If you’re familiar with databases but want to add Postgres to your toolbox, this is the video for you!
You’ll learn to:
Postgres works well as an auxiliary reporting database or as the main database for your application. Get started today!
Includes a typed transcript.
You’ll do well with this screencast if you’ve used any SQL database and if you have at least some experience with Ruby on Rails.
Revision 1 (Notes) · Updated: Feb 16, 2011 · Length: 65 min · 250 MB