I have to combine data from two legacy databases tables for a new symfony based site. I am considering:
A real-time view composed of select from the two datbase tables
A a trigger that syncs the updates of two database into a single table.
Are there any known issues using one or the other in Symfony. The database is postgres.