what is the difference between pulumi.dynamic.ResourceProvider and pulumi.ProviderResource? I'm trying to create my own set of custom resources on a provider (i.e. a database connection) but the provider needs to be from another Resource that gets created earlier in the run... so i'm trying to figure out how to structure this

As I understand it: ResourceProvider is the interface that marks dynamic providers, as per the docs. ProviderResource is an internal interface that is used when serializing providers (of any type, including but not limited to pulumi.dynamic.ResourceProvider) to and from state. Generally, don't use ProviderResource. Other, higher-level interfaces extend it.