Successfully Balancing Refactoring with Work on Features and Bugfixing

January 23, 2019

Four strategies to help developers successfully complete their refactoring project while still delivering features and fixing bugs.

How to Avoid Scope Creep During Refactoring

January 20, 2019

Find out how careful planning and time-boxing help successfully complete even large and scary refactoring projects on time.

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

January 02, 2019

How non-functional requirements analysis can help you design and build better software.

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

December 23, 2018

Explore the difference between these three DevOps practices.

How I Mentored Junior Developers at Envato

April 11, 2017

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

Scrum vs Kanban at early and late stages of product development

October 23, 2016

Scrum may work better at early stages of product development, while Kanban seems to a better option at the 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

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

How to check if two datetime ranges overlap in PostgreSQL.

Partial indexes in PostgreSQL. Part 2: Query performance

March 29, 2016

How to make SELECT, INSERT, DELETE and UPDATE queries in PostgreSQL faster by using partial indexes.

Partial indexes in PostgreSQL. Part 1: Data Integrity

March 27, 2016

How 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 practical 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