so I am making more use of quant rocket to bridge security master from my strategies to IBKR. I have a few different services, I guess you would call them for simulation and trading. sometimes its most convenient to access security master data by hitting the security master sqlite database directly but of course that is not really very convenient from outside the container where the security master lives.
it occurs to me that perhaps it would be cool to have the security master be part of the Postgres database which is already running in the container? you could achieve that with very little code change by using an extension like sqlite_fdw to link the sqlite db from Postgres, which I googled but have not actually used.
or you could have the security master schemas be hosted in Postgres, this would of course make it simple to access this data from anywhere in the system. this might be viewed in some way as breaking encapsulation but I for many years have used SQL for many things and I so I choose not see it that way haha.
maybe this is feedback ?