A while ago I tweeted a thread about how a small JavaScript snippet, one that can fit in a single...
This collection contains some useful design resources for developers. Many of them were mentioned in the Refactoring UI tutorials.
As an application exists, data accumulates. While you'll be loosely monitoring the main models' record count, some supportive database...
MariaDB (and MySQL) is released in different versions with different behaviors. For backwards compatibility this can be managed with the...
Inspecting the source of an email does not always reveal the plain HTML source, but some encoded byte mess. In...
Travis changed their default distribution from Ubuntu 14.04 (trusty) to 16.04 (precise). This might break your test setup for new...
Tod is a gem for working with daytimes. That's a tuple of (hour, minute second) without a day, month...
When doing some meta-programming magic and you want to do something for all attributes of a class, you may...
Suggested Workflow Set the ruby version in .ruby-version to 2.3.5, then perform these steps one by one, fixing errors...
As a web developer, you know Google Analytics (GA). Probably you've dropped the GA snippet into more than one...
Create a user without password (recommended) Replace newuser with your desired username: mysql -uroot -p CREATE USER 'newuser'@'localhost' IDENTIFIED...
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...
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...
This is an extension to PostgreSQL vs MySQL: How to UPDATE using a JOIN. UPDATE employees SET department_name = departments.name...
When using GROUP BY, MySQL now complains if the SELECT includes columns which are not part of the GROUP BY...
Middleman is a static page generator that brings many of the goodies that Rails developers are used to.
This card compares patterns to store trees in a relation database like MySQL or PostgreSQL. Implementation examples are for the...
Barby is a great Ruby gem to generate barcodes of all different sorts. It includes support for QR codes via...
If you have a replication error with MySQL and you know the "error" is okay (e.g. you've executed the...