PostgreSQL

Advanced PostgreSQL Schema Design (For Scalable Application Development)

Go beyond CREATE TABLE and CREATE VIEW with functional indexes, exclusion constraints, array types, transactional DDL, and more for simple, scalable application development. This presentation goes into PostgreSQL-specific features that can be leveraged for advanced schema design. The focus will be solving real-world problems faced by application developers to create long-lasting database schemas. Conference organizer: …

Advanced PostgreSQL Schema Design (For Scalable Application Development) Read More »

Learn PostgreSQL Tutorial

Learn how to use PostgreSQL in this full course. PostgreSQL is an open source general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems.

Wrangle Your SQL With Arel

You wanted to use those fancy Postgres features so you wrote raw SQL. Some time and a few more features go by and now your app is littered with SQL strings. Keep the power and lose the mess by building composable query objects that leverage Arel, the query builder under the hood of ActiveRecord.

Postgres at Any Scale

This presentation starts with the basics you need to know as an app developer about interacting with your PostgreSQL database. Then, it digs into how you can start to analyze performance. You will learn what you need to know for a small application, then the things you should be cautious of as you start to …

Postgres at Any Scale Read More »

Changing Database & Datacenter at Lanyrd.com

As is the case for many websites and applications, when the size of its users reach a certain point, critical changes to the architecture must be made. This presentation discusses how Lanyrd addressed this problem, when they decided to move from MySQL to PostgreSQL, and from AWS to Softlayer.