During debugging you might pepper your code with lines like these: console.log('foo = ' + foo + ', bar = ' + bar) I recommend to use...

SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER...

If you have many connections to your MySQL or MariaDB (as we have) you might want to filter the list...

I recommend to go straight to 2.1.5+ without intermediate steps. Otherwhise you burden yourself with unnecessary work of encoding problems...

I had a very frequent cronjob that in rare cases could be relatively slow. To avoid multiple instances of this...

postgresql.org

PostgreSQL's array data type is pretty useful, but manipulating values of arrays can be awkward because of its syntax...

Our applications not only need to be functional, they need to be fast. But, to quote Donald Knuth, premature optimization...

Method lookup Understand all the terms in How Ruby method lookup works, in particular: include extend singleton class

The migration DSL now supports adding and removing foreign keys. They are dumped to schema.rb as well. At this time...

leomayleomay.github.io

Your after_commit callbacks will not know about changes, as Rails discards them when committing. The linked article shows a...

makandra Curriculum

Learn Enough Command Line to be Dangerous (it's in our library => Google Drive) CLI tricks every developer should...

In this card we will learn to write code that scales with a large number of database records. We will...

makandra dev
eager.io

SmartUnderline is an open-source JavaScript library which uses clever tricks to draw underlines in a more beautiful and readable...

css-tricks.com

Insanely detailled guide about controlling copy & paste behavior using web technology in 2015. Note that you can now trigger a...

When you want to UPDATE a table with information from an associated table, you can JOIN the associated table into...

edgeapi.rubyonrails.org

Starting from Rails 4.0, you can use a special form options helper called #collection_check_boxes. It behaves similar to...

Web applications can be used by multiple users at the same time. A typical application server like Passenger has multiple...

github.com

You can hook into Slack when using Capistrano for deployment. The slackistrano gem does most of the heavy lifting for...

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database' order by table_rows;

xaprb.com

The linked article explains how to get a database-wide lock without creating table rows: This article explains how I...

If you want to load an SQL dump from an ActiveRecord migration, you might find this to be harder than...

In the tradition of our PostgreSQL cheat sheet for MySQL lamers, here is a cheat sheet for Jasmine when you...

edgeguides.rubyonrails.org

Rails guide that covers PostgreSQL-specific column types and usages for Active Record. You should especially keep in mind the...

The Angular ngSrc directive serves to properly set an image src via Angular. As anything in Angular, it updates the...