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...
This is an extension to PostgreSQL vs MySQL: How to UPDATE using a JOIN. UPDATE employees SET department_name = departments.name...
Slides for Henning's talk on Sep 21st 2017. Understanding sync vs. async control flow Talking to synchronous (or "blocking...
When using GROUP BY, MySQL now complains if the SELECT includes columns which are not part of the GROUP BY...
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...
When working with custom transactions and use ActiveRecord::Rollback you may encounter unexpected behaviour if you try to roll back...
SVG is an acronym for "scalable vector graphics". SVGs should be used whenever an image can be described with vector...
We have released a new library Gemika to help test a gem against multiple versions of Ruby, gem dependencies and...
We have a new gem Minidusen which extracts Dusen's query parsing and LIKE query functionality. Minidusen can no longer...
If you were using Dusen for its query parsing and LIKE queries, we recommend to migrate to Minidusen, which extracts...