Use geocoder gem with database

create_geocoder_data.rb

# db/migrate/xxxxxxxxx_create_geocoder_data.rb
class CreateGeocoderData < ActiveRecord::Migration[6.0]
  def change
    create_table :geocoder_data, id: false do |t|
      t.string :url, null: false, primary_key: true
      t.jsonb :data

      t.timestamps
    end
  end
end

geocoder.rb

# config/initializers/geocoder.rb
Geocoder.configure(
  lookup: :google,
  api_key: ENV['PLAECS_KEY'].try(:freeze),
  cache: GeocoderDatum,
  cache_prefix: false,
  use_https: true
)

geocoder_datum.rb

# app/models/geocoder_datum.rb
class GeocoderDatum < ApplicationRecord
  serialize :data, Serializers::IndifferentHash
  
  class << self
    def [](url)
      find_by_url(url)&.data_before_type_cast
    end

    def []=(url, value)
      where(url: url).first_or_create(data: value).update(data: value)
    end

    def keys
      pluck(:url)
    end
  end
end

my_indifferent_hash.rb

class MyIndifferentHash < HashWithIndifferentAccess

  def self.load(value)
    HashWithIndifferentAccess.new(value)
  end

  def self.dump(obj)
    obj = JSON.parse(obj) if obj.is_a?(String) rescue nil
    obj.to_hash.with_indifferent_access rescue {}
  end
end

This is an example of how to use geocoder with activerecord model instead of caching on redis