PostgreSQL supports the SQL OVERLAPS operator. You can use it to test if two date ranges overlap: => SELECT ('2001-02...
An end-to-end test (E2E test) is a script that remote-controls a web browser with tools like Selenium...
If another session is accessing your database you are trying to reset or drop you might have seen the following...
This card compares patterns to store trees in a relation database like MySQL or PostgreSQL. Implementation examples are for 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...
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...