Pgcli Rails

screenshot of Pgcli Rails

Replaces Rails PostgreSQL `dbconsole` with the much nicer `pgcli`

Overview

pgcli-rails is a gem that brings the refined command-line interface of pgcli to your Rails applications, enhancing your database management experience. With features like auto-completion and syntax highlighting, it simplifies the interaction with PostgreSQL databases. This gem allows users to replace the standard rails dbconsole command effortlessly, making it a worthy addition for any Rails developer working with PostgreSQL.

By simply adding it to your Gemfile, you can leverage pgcli's powerful capabilities directly within your Rails environment. This seamless integration paves the way for efficient database operations without the cumbersome syntax of traditional terminal commands.

Features

  • Seamless Integration: Easily replace rails dbconsole with pgcli by simply adding the gem to your Gemfile, enhancing your Rails app's database interactions.
  • Auto-Completion: Enjoy the convenience of command auto-completion, allowing for quicker and more efficient input of SQL commands.
  • Syntax Highlighting: Benefit from visually distinct SQL syntax, making it easier to read and understand complex queries.
  • No Configuration Needed: Works out of the box using your existing ActiveRecord database connection from database.yml, simplifying setup and usage.
  • Rails Compatibility: Supports Rails 4.2+ and requires Ruby 3.2+, ensuring compatibility with modern Rails applications.
  • Open Source: Available under the MIT License, encouraging community contributions and collaboration.
  • Planned Enhancements: Future updates may include tests and compatibility checks with multiple Rails versions, enhancing reliability and functionality further.