Software Quality Attributes, Non-Functional Requirements and Better Software Architecture

January 02, 2019

Learn how software quality attributes and non-functional requirements analysis can help you design better software.

Continuous Integration, Continuous Delivery and Continuous Deployment: what’s the difference?

December 23, 2018

Explore the difference between the DevOps maturity stages: Continuous Integration, Delivery and Deployment.

How I Mentored Junior Developers at Envato

April 11, 2017

A summary of a year and a half of mentoring a group of (now former) junior developers.

Scrum vs Kanban at early and late stages of product development

October 23, 2016

Looks like Scrum works best at early stages of product development, while Kanban works better at later ones.

empty?, blank?, any?, exists? methods of Ruby on Rails ActiveRecord

April 17, 2016

Lets have a closer look at ActiveRecord empty?, blank?, any?, exists? methods to better understand what they do, their performance, and when they should be used.

Tuning `work_mem Setting in PostgreSQL to Speed Up Slow SQL Queries

April 16, 2016

A little trick to speed up queries in PostgreSQL that aggregate, sort or join large datasets.

Maintaining a PostgreSQL database health with ANALYZE, REINDEX, and VACUUM commands

April 01, 2016

Learn how to improve query speed in PostgreSQL and protect from table and indexes bloat by periodically running these three database maintenance commands.

Indexes on Expressions in PostgreSQL

April 01, 2016

A way to speed up SELECT queries and enforce data constraints in PostgreSQL with expressions and deterministic functions.

OVERLAPS Operator in PostgreSQL

March 30, 2016

Learn how to check if two datetime ranges overlap in PostgreSQL.

Partial indexes in PostgreSQL. Part 2: Query performance

March 29, 2016

Learn how to make queries in PostgreSQL faster by using partial indexes.

Partial indexes in PostgreSQL. Part 1: Data Integrity

March 27, 2016

Learn to enforce data integrity constraints on a subset of rows in PostgreSQL.

BETWEEN SYMMETRIC operator in PostgreSQL

March 20, 2016

X BETWEEN SYMMETRIC Y AND Z is PostgreSQL operator that swaps Y and Z automatically if Y > Z to always use a nonempty range.

How to export data from a Redshift table into a CSV file (with headers)

September 29, 2014

A simple way to extract data into CSV files in an S3 bucket and then download them with s3cmd.

Book Review: “Growing Rails Applications in Practice”

August 15, 2014

A nice little book for Ruby On Rails devs of any experience helping to unlearn bad and adopt better practices.

Tools and Resources for PostgreSQL and Ruby On Rails.

August 10, 2014

Learn what gems are available to make it easier to work with hstore columns and how to use Postgress arrays and indexes more efficiently.

Copyright © 2014-2019 Andrei Gridnev