tatiyants.com

How To Navigate JSON Trees in Postgres using Recursive CTEs

| | |

Tutorial on using Postgres recursive Common Table Expressions (CTEs) to navigate a JSON tree structure.

Postgres Query Plan Visualization

| |

Postgres Explain Visualizer (Pev) is a tool I wrote to make EXPLAIN output easier to grok. It creates a graphical representation of the query plan.

How to Automatically Back up Photos from Android to Mac for Free

| | | | |

If you’d like to automatically download pics and videos from your Android phone to your Mac, this post is for you. All you need is a free Dropbox account and some elbow grease.

How to Customize JFree Charts

| |

In this tutorial, I’ll explain how to customize JFree charts to look clean and modern.

A Second Look at Facebook’s React

|

React is a very impressive library for developing fast, component-based UIs. That said, it’s not a full framework and will likely require additional libraries in order to build large apps.

Groking Angular: Dependency Injection and Testing

| | |

Although Angular’s syntax for Dependency Injection is sometimes difficult to understand, it’s actually quite straight forward to use for testing.

How and When to Use Various GORM Querying Options

| | |

Grails GORM supports five increasingly powerful querying mechanisms: 1) dynamic finders, 2) where clauses, 3) criteria, 4) HQL, and 5) SQL.

How to Configure IntelliJ IDEA For Angular JS Testing

| |

Here’s a simple guide on how to configure IntelliJ IDEA to use Karma/Jasmine to run Angular tests

A Rating System For Free Apps

|

Every time I install a new free app, I wonder about exactly how its creators intend to make money. Am I going to see a bunch of ads? Are they going to sell me something? Are they going to sell me to someone?

How to Write a Children’s Book

| |

As a parent, I read a lot of children’s books. Each time I pick up one of these literary masterpieces, I can’t help but stare at amazement at the words in front of me. It’s hard to believe that such a delightful work of art was conceived of, written, edited, printed, distributed, and sold by and to adults.

Online Commenter Types

|

There are many, many people online who like to comment on things. A few are lucid, most are harmless, but some are… Well, let’s just say “not very nice”.