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...
You want Spring for super-fast binstubs like bin/rails or bin/rspec which avoid Rails boot time. You want parallel_tests...
Sometimes you want to test migrations with production or staging data. Dumping single tables makes sense if a complete dump...
PostgreSQL, unlike MySQL, treats strings as case sensitive in all circumstances. This includes comparison with = and LIKE collision detection in...
Here is a symbol of an eight note: ♪ Its two-byte hex representation is 0x266A. This card describes how to...
When building a web application, one is tempted to claim it "done" too early. Make sure you check this list...
Apparently you can pash a second scope to a hash-condition and the whole thing will be evaluated as a...
This is quite an edge case, and appears like a bug in Rails (4.2.6) to me. Update: This is now...
to create a Gallery that has a name and has_many :images, which in turn have a...
UI sortable helps reordering items with drag 'n drop. It works quite fine. Proven configuration for sorting table rows
When you run rake db:rollback and nothing happens, you are probably missing the latest migration file (or have not...
Adds missing native PostgreSQL data types to ActiveRecord and convenient querying extensions for ActiveRecord and Arel for Rails 4.x...
ActiveRecord offers an explain method similar to using EXPLAIN SQL statements on the database. However, this approach will explain all...
This gem gives you a rake task db:seed:dump do create a db/seeds.rb from your current database state.
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...
Our preferred way of testing ActiveRecord is to simply create/update/destroy the record and then check if the expected behavior has...
Geordi is now (partially) tested with Cucumber. Yay! geordi cucumber supports a new @solo tag. Scenarios tagged with @solo...
Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema...
Ever wondered how you can create a simple table output in bash? You can use the tool column for creating...
SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER...
PostgreSQL offers a really handy field type: json. You can store any JSON there, in any structure. While its flexibility...
rack-mini-profiler is a powerful Swiss army knife for Rack app performance. Measure SQL queries, memory allocation and CPU...