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...
To check the currently running PG version from your Rails application (e.g. Rails console on your production server), simply do...
PostgreSQL, unlike MySQL, treats strings as case sensitive in all circumstances. This includes comparison with = and LIKE collision detection in...
PostgreSQL uses the C library's locale facilities for sorting strings: First, all the letters are compared, ignoring spaces and...
Adds missing native PostgreSQL data types to ActiveRecord and convenient querying extensions for ActiveRecord and Arel for Rails 4.x...
When creating an index using CREATE INDEX, Postgres will create a B-Tree type index by default. The B-Tree...
When full text search is overkill and like queries do not deliver this might be an approach you could try...
Using Scenic, you can bring the power of SQL views to your Rails application without having to switch your schema...
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...
One useful postgres command I stumbled upon recently was \x. It gives you an expanded display which allows you to...
PostgreSQL's array data type is pretty useful, but manipulating values of arrays can be awkward because of its syntax...
When working with PostgreSQL, you can use pgAdmin as a GUI. While you can do most things just like on...
If you need a postgresql extension for your database it isn't a good idea to give your applications database...
In tests, it is sometimes useful to create records with specific ids. On PostgreSQL this can cause problems: Usually, PostgreSQL...
The migration DSL now supports adding and removing foreign keys. They are dumped to schema.rb as well. At this time...
When using ORDER BY "column" in PostgreSQL, NULL values will come last. When using ORDER BY "column" DESC, NULLs will...
There is no such thing as a "default order" of rows in database tables. For instance, when you paginate a...
When you want to UPDATE a table with information from an associated table, you can JOIN the associated table into...
Several Rails migration methods accept index: true as an option to create an index. In some cases (like #add_column...
It's generally not trivial to change a datetime's seconds, minutes, etc in SQL. Here is how it works...