Logidze

screenshot of Logidze
rails

Database changes log for Rails

Overview

Logidze is an innovative tool that offers a streamlined solution for tracking database record changes in PostgreSQL, allowing developers to efficiently manage versioning without the overhead of additional tables. By leveraging triggers, it produces a seamless log of changes stored directly within a JSONB column of the record itself. This functionality not only accelerates logging operations compared to similar tools but also simplifies the integration process for those using Ruby on Rails.

It's particularly beneficial for applications where maintaining a history of changes is crucial. With Logidze, developers can quickly set up logging, backfill existing data, and access historical states with ease, making it an essential tool for any contemporary Ruby on Rails project that relies on PostgreSQL.

Features

  • Integrated Change Tracking: Logidze automatically tracks changes to Active Record models by creating a log_data JSONB column, eliminating the need for manual logging setups.

  • Backfill Support: Easily populate historical data through backfill options, allowing for the initial snapshot creation of existing records.

  • Size Limit Option: Control the size of logs by setting limits, ensuring that database performance remains optimal over time.

  • Simple Configuration: Integrates smoothly with existing Rails applications and can be configured to work with various versions of Rails and PostgreSQL.

  • Trigger-Based Logging: Utilizes database triggers for efficient logging without the necessity of additional tables, promoting a cleaner database design.

  • Snapshot Creation: Users can create full snapshots of data states, allowing for easier version management and rollback capabilities.

  • Meta Tracking: Keep track of responsibility and meta information for each log entry to enhance accountability and auditing.

  • Compatibility with fx gem: Works seamlessly with the fx gem for those who prefer maintaining a schema.rb format while enjoying the benefits of Logidze.

rails
Ruby on Rails

Ruby on Rails, often referred to as Rails, is an open-source web application framework written in Ruby. Known for its convention over configuration and don't repeat yourself (DRY) principles, Rails simplifies and accelerates the development of database-backed web applications.