Here is how to model basic logic in media queries. AND With keyword and. # Target viewport widths between 500 and...
Since late 2015, all major browsers (still excluding Firefox) support pointing device media queries. These can be used to distinguish...
When you need to store structured data (like Ruby hashes) in a single database column with ActiveRecord, a simple way...
Create a user without password (recommended) Replace newuser with your desired username: mysql -uroot -p CREATE USER 'newuser'@'localhost' IDENTIFIED...
Using the JS fullscreen API is painful because all browers use different methods and events and you need to use...
When your application is running on a multi-server setup, application logs are stored per server (unless you choose a...
You know that you can use jQuery's text() to get an element's contents without any tags.
When you have a large PG database, you may want to find out which tables are consuming the most disk...
The attached article explains options you have to store the order of items in a database table. The simplest solution...
Don't sum up columns with + in a sql-query if NULL-Values can be present. MySQL and PostgreSQL cannot...
geordi delete_dumps [directory] Recursively search for files ending in *.dump and offer to delete those. When no...
You might have some trouble running a Rails LTS 2 app with MySQL 5.7. If you don't want to...
MySQL and MariaDB have an SQL mode setting which changes how MySQL behaves. The SQL mode value is comprised of...
On your local system that only hosts non-critical development data and only you have access to, you can store...
When you have string contents (e.g. a generated binary stream, or data from a remote source) that you want to...
In Spreewald 1.10.4+, nested patiently blocks are now patient. Here is an example: patiently do outer_code patiently do
Your default postgres user is named like your linux user. That default user has limited access privileges, which can cause...
Bundler::GemRequireError: There was an error while trying to load the gem 'mysql2'. Gem Load Error is: Incorrect MySQL client...
mysql> SELECT @@global.version; +------------------+ | @@global.version | +------------------+ | 5.6.30 | +------------------+ 1 row in set (0,00 sec) MySQL 5.6 Reference Manual says "BLOB and TEXT...
Generating a project README Finally: Support for modelling associations between models in your application model! Example: # lib/katapult/application_model.rb
Understanding your type of cronjob Some cronjobs must only run on a single server. E.g. when you run nightly batch...
Enumerable#all? returns true for an empty collection. This totally makes sense but you have to think about it when...
This is an extension to PostgreSQL vs MySQL: How to UPDATE using a JOIN. UPDATE employees SET department_name = departments.name...
Font Awesome version 5 changed some icon names, and introduces new prefixes fab, far, and fas. There is a JavaScript...