store large JSON in PostgreSQL with Rails Attributes API

binary_hash.rb

# app/types/binary_hash.rb

class BinaryHash < ActiveRecord::Type::Binary
  def serialize(value)
    super value_to_binary(value.to_json)
  end

  def deserialize(value)
    super case value
          when NilClass
            {}
          when ActiveModel::Type::Binary::Data
            value_to_hash(value.to_s)
          else
            value_to_hash(PG::Connection.unescape_bytea(value))
          end
  end

  private

  def value_to_hash(value)
    JSON.parse(
      ActiveSupport::Gzip.decompress(value),
      symbolize_names: true
    ) || {}
  end

migration.rb

add_column :reports, :data, :binary

report.rb

# app/models/report.rb

class Report < ApplicationRecord
  attribute :data, :binary_hash
end

types.rb

# config/initializers/types.rb

ActiveRecord::Type.register(:binary_hash, BinaryHash)

reference: https://dev.to/jetrockets/how-to-store-large-json-in-postgresql-with-rails-attributes-api-52co