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...
Apparently you can pash a second scope to a hash-condition and the whole thing will be evaluated as a...
If you have made any changes to a libvirt xml config file you have to reload is. One way is...
Spreewald gives you the within meta step that will constrain page inspection to a given scope. Unfortunately, this does not...
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...
SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER...
If you have many connections to your MySQL or MariaDB (as we have) you might want to filter the list...
I recommend to go straight to 2.1.5+ without intermediate steps. Otherwhise you burden yourself with unnecessary work of encoding problems...
The migration DSL now supports adding and removing foreign keys. They are dumped to schema.rb as well. At this time...
When using Savon to connect a SOAP API, you may want to use Savon::SpecHelper to mock requests in your...
When you want to UPDATE a table with information from an associated table, you can JOIN the associated table into...
Web applications can be used by multiple users at the same time. A typical application server like Passenger has multiple...
See this Railscast. Basically you can simply write views like index.xlsx.erb: ID Name Release Date Price <% @products.each do |product| %> <%= product.id...
SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'your_database' order by table_rows;
The linked article explains how to get a database-wide lock without creating table rows: This article explains how I...
If you want to load an SQL dump from an ActiveRecord migration, you might find this to be harder than...
In the tradition of our PostgreSQL cheat sheet for MySQL lamers, here is a cheat sheet for Jasmine when you...
Rails guide that covers PostgreSQL-specific column types and usages for Active Record. You should especially keep in mind the...
We upgraded a Rails 2 application to Rails 3.2 and Ruby 2.1, changed the mysql adapter from mysql to mysql2...
Microsoft Exchange service administrators can enable Exchange Web Services (EWS) which is a rather accessible XML API for interacting with...
Directly from the MySql docs: There are three likely causes for this error message. Usually it indicates network connectivity trouble...