Probably shouldn't have to mention this, but it's probably not a good idea to add this into your project.

You should be able to set up SSL termination at the load balancer on Digital Ocean and forward the requests to the DO Droplets. https://docs.digitalocean.com/products/networking/load-balancers/how-to/ssl-termination/

Inspect your page and make sure that the options value is being set for the Stimulus Controller

You may need a rake task to run on the blobs. In the Rails console, look up a Blob that was uploaded.

ActiveStorage::Blob.first.service_name

It will likely return something like

local

Whatever you have set for the name in the storage.yml will be what you need to set for the service_name. You can bulk update this with something like

ActiveStorage::Blob.update_all(service_name: 'contabo')

Where, in this example, contabo would be the top level key name of the service in the storage.yml.

I think that in your example with p2, if you do 

p2 = Project.where(id: 13).load

Then you will find that 

p2.any?

will not trigger an additional query. I think that the way Rails is behaving, it's because the query isn't loading in IRB. If you type p2 in the terminal again, I think it will trigger another query.