postgres_ext: additional Rails bindings for PostgreSQL

Adds missing native PostgreSQL data types to ActiveRecord and convenient querying extensions for ActiveRecord and Arel for Rails 4.x

Common table expressions

Relation#with
Model.from_cte

Arrays

Face.where.contains tags: %w[happy smiling] # Matching faces have both 'happy' and 'smiling' tags
Face.where.overlap tags: %w[happy smiling] # Matching faces have at least one of these tags
Face.where.any tags: 'happy' # Matching faces include the 'happy' tag
Face.where.all tags: 'dunno' # Not documented, try for yourself

INET/CDIR data types

<< Contained by
<<= Contained within or equals
>> Contains
>>= Contains or equals

github.com

Dominik Schöler

makandra.de

Say thanks

Last edit

2016-05-24

Dominik Schöler

License

Source code in this card is licensed under the MIT License.

Posted by Dominik Schöler to makandra dev (2016-05-19 13:58)