• 

  Optimizing a Database Query with Functional Indexes in Postgres

  PostgreSQL by Andrew Vogel

• 

  Manipulating Data in Production

  PostgreSQL by Vinicius Negrisolo

• 

  A Handful of Useful Features in PostgreSQL & SQL

  PostgreSQL by Andrew Vogel

• 

  SQL: Inner Join vs. Outer Join

  PostgreSQL by Josh Branchaud

• 

  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

• 

  Advanced Queries with ActiveRecord's From Method

  Ruby by Josh Branchaud

• 

  Running Out Of IDs

  PostgreSQL by Josh Branchaud