Hotsheet

Manage your Rails database through a spreadsheet-like interface.

• Look at and modify your DB within the app itself (no rails console required!).
• Give controlled DB access to your admin users without having to create CRUD views for each table.
• Lightweight and fast. We keep usage simple and configuration to the minimum.

Installation

1. Add gem "hotsheet" to your Gemfile.
2. Run bundle.
3. Run bin/rails g hotsheet:install.

Usage

After installing, you can directly go to /hotsheet within your app by default.

Configuration

You can configure which models ('sheets') this gem should manage, and specify which database columns should be editable or viewable in the spreadsheet. This can be done by configuring the initializer file created by the install command:

# config/initializers/hotsheet.rb

Hotsheet.configure do
  sheet :User do
    column :name
    column :birthdate, editable: false
  end
end

Contributing

See Contributing Guide and please follow the Code of Conduct.

Roadmap

This is a newly created gem, and we will firstly focus on:

1. Single-user experience (styles and usability)
2. Configuration and access permissions
3. Concurrent users (broadcasting, conflict resolution)

Feel free to look at our planned enhancements or add your own.

License

Hotsheet is available as open source under the terms of the MIT License.
Copyright © 2024-present Renuo AG.