• 

  Optimizing a Database Query with Functional Indexes in Postgres

  PostgreSQL by Andrew Vogel

• 

  Manipulating Data in Production

  PostgreSQL by Vinicius Negrisolo

• 

  Ecto UPSERT for different Primary Keys in Elixir

  Elixir PostgreSQL by Vinicius Negrisolo

• 

  Comparing PostGIS and PostgreSQL's earthdistance

  PostgreSQL by Mary Lee

• 

  A PostgreSQL User's Introduction to Neo4j

  PostgreSQL by Mary Lee

• 

  A Handful of Useful Features in PostgreSQL & SQL

  PostgreSQL by Andrew Vogel

• 

  SQL: Inner Join vs. Outer Join

  PostgreSQL by Josh Branchaud

• 

  Exploring the Default Postgres Template Databases

  PostgreSQL by Mary Lee

• 

  Query for NULL 'or' empty string in ActiveRecord

  PostgreSQL Ruby by Matt Polito

• 

  Fun with Views and CTEs

  PostgreSQL by Ifu Aniemeka

• 

  Create Quick JSON Data Dumps From PostgreSQL

  PostgreSQL by Josh Branchaud

• 

  Generate Dates in PostgreSQL

  PostgreSQL by Josh Branchaud

• 

  Swap Two Column Values in SQL: Part 2

  PostgreSQL by Josh Branchaud

• 

  Swap Two Column Values in SQL: Part 1

  PostgreSQL by Josh Branchaud

• 

  Simple PostgreSQL Upgrades in Development

  PostgreSQL by Jack Christensen

• 

  Embrace the Database with Ecto

  Elixir PostgreSQL by Josh Branchaud

• 

  Running Out Of IDs

  PostgreSQL by Josh Branchaud

• 

  Ecto Migrations: Simple to Complex

  PostgreSQL Elixir by Josh Branchaud

• 

  Modeling Polymorphic Associations in a Relational Database

  PostgreSQL by Jack Christensen

• 

  Working with Email Addresses in PostgreSQL

  PostgreSQL by Josh Branchaud

• 

  Custom Aggregates in PostgreSQL

  PostgreSQL by Jack Christensen

• 

  Upsert Records with PostgreSQL 9.5

  PostgreSQL by Josh Branchaud

• 

  Understanding Common Table Expressions with FizzBuzz

  PostgreSQL by Josh Branchaud

• 

  Materialized View Strategies Using PostgreSQL

  PostgreSQL by Jack Christensen

• 

  16 Tips from the 2014 Winter Miniconf

  PostgreSQL Ruby by Jack Christensen

• 

  Exploring the Postgres Gin index

  Ruby PostgreSQL by Derek Parker

• 

  Go Performance Observations

  PostgreSQL by Jack Christensen

• 

  Advisory Locks in PostgreSQL

  PostgreSQL by Derek Parker

• 

  Deferring constraints in PostgreSQL

  Ruby PostgreSQL by Joshua Davey

• 

  Writable Common Table Expressions

  Ruby PostgreSQL by Jack Christensen

• 

  has_one view

  Ruby PostgreSQL by Joshua Davey

• 

  Faster JSON Generation with PostgreSQL

  PostgreSQL by Jack Christensen

• 

  Using Recursive SQL with ActiveRecord trees

  Ruby PostgreSQL by Joshua Davey

• 

  SQL Window Functions and You

  Ruby PostgreSQL by Joshua Davey