tomasc/torque-postgresql

Add support to complex resources of PostgreSQL, like data types, array associations, and auxiliary statements (CTE)

Torque PostgreSQL

• Wiki
• Bugs
• TODO

Description

torque-postgresql is a plugin that enhances Ruby on Rails enabling easy access to existing PostgreSQL advanced resources, such as data types and query statements. Its features are designed to be similar to Rails architecture and work as smoothly as possible.

Fully compatible with schema.rb and 100% plug-and-play, with optional configurations, so that it can be adapted to your project's design pattern.

Installation

To install torque-postgresql you need to add the following to your Gemfile:

gem 'torque-postgresql', '~> 2.0'   # For Rails >= 6.0 < 6.1
gem 'torque-postgresql', '~> 2.0.4' # For Rails >= 6.1
gem 'torque-postgresql', '~> 3.0'   # For Rails >= 7.0

Also, run:

$ bundle

Or, for non-Gemfile related usage, simply:

gem install torque-postgresql

Usage

These are the currently available features:

• Configuring

Data types

• Box
• Circle
• Date/Time Range
• Enum
• EnumSet
• Interval
• Line
• Segment

Querying

• Arel
• Auxiliary Statements
• Belongs to Many
• Distinct On
• Dynamic Attributes
• Has Many
• Inherited Tables
• Insert All
• Multiple Schemas

How to Contribute

To start, simply fork the project, create a .env file following this example:

DATABASE_URL="postgres://USER:PASSWORD@localhost/DATABASE"

Run local tests using:

$ bundle install
$ bundle exec rake spec

Finally, fix and send a pull request.

License

Copyright © 2017- Carlos Silva. See The MIT License for further details.