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...
on the bash (issued as postgres user) Start/Stop/Restart PostgreSQL pg_ctl -D $configdir start|stop|restart Start/Stop/Restart the corresponding PostgreSQL...
Web technology is a broad field and you cannot be an expert in all aspects. However, it is useful to...
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...
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...
Sometimes you want to test migrations with production or staging data. Dumping single tables makes sense if a complete dump...
The linked article shows what current browsers do when you click a link like this: 1-562-867-5309
PostgreSQL, unlike MySQL, treats strings as case sensitive in all circumstances. This includes comparison with = and LIKE collision detection in...
Apparently you can pash a second scope to a hash-condition and the whole thing will be evaluated as a...
Many of our developers love to use the "awesome" window manager on Linux. However, RubyMine dialogs occasionally defocus while typing...
ActiveRecord offers an explain method similar to using EXPLAIN SQL statements on the database. However, this approach will explain all...
Instead of using this hack you might want to use MariaDB 10.x which can work with both old and...
You can find out about disk space usage of all tables within your database by running this: SELECT table_name...
If you want to perform a failover on another haproxy backend server this is the way you should do it...
Our preferred way of testing ActiveRecord is to simply create/update/destroy the record and then check if the expected behavior has...