If you have a very large datadir in MariaDB and you want to transfer the data to another host (e.g...
If you have a :string or :text field, you should pair it with a model validation that restricts its length...
Nokogiri is great. It will even fix invalid HTML for you, like a browser would (e.g. move block elements out...
CSS selectors are a very simple tool to select elements from a Nokogiri document. However, the colon in the XML...
We can use ActiveRecord's where to add conditions to a relation. But sometimes our condition is not on the...
Debugging image color profiles is hard. You can't trust your eyes in this matter, as the image rendering depends...
A primer on vector graphics For rastered image formats like JPG or PNG, each pixel is basically drawn on a...
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...
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...
Ubuntu has decided to disable PDF processing because ImageMagick and the underlying Ghostscript had several security issues. When your Ghostscript...
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...
When you need test images, instead of using services like lorempixel or placehold.it you may generate test images yourself.
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...