Support for the solid gems?

[leoncruz]

Hey Mike! Thanks for the incredible work!

I would like to know if there are plans to support the solid gems too. All three have support to use multiple database, but the tenant creation is not supported yet.

I'm thinking something like:

# database.yml
production:
  primary:
    <<: *default
    database: storage/production/%{tenant}/main.sqlite3
    tenanted: true
  cache:
    <<: *default
    database: storage/production/%{tenant}/cache.sqlite3
    migrations_paths: db/cache_migrate
    tenanted: true
  queue:
    <<: *default
    database: storage/production/%{tenant}/queue.sqlite3
    migrations_paths: db/queue_migrate
    tenanted: true
  cable:
    <<: *default
    database: storage/production/%{tenant}/cable.sqlite3
    migrations_paths: db/cable_migrate
    tenanted: true

And then ApplicationRecord.create_tenant("mike") create the databases and migrate all then.