6 ms·
Calling out limitations like this in the documentation would go a long way in building confidence in the project. Better yet, if there's an example of how to de
by jmg_ 3y ago
Calling out limitations like this in the documentation would go a long way in building confidence in the project. Better yet, if there's an example of how to deal with "day-2" operational concerns like this.
Simply looking at the docs on these two pages, its unclear to me whether there's a way to update the mirror definition when a schema change occurs or if I need to drop & recreate the mirror (and what the effects of this are in the destination):
- https://docs.peerdb.io/sql/commands/create-mirror https://docs.peerdb.io/sql/commands/create-mirror
- https://docs.peerdb.io/usecases/Streaming%20Query%20Replication/sqlserver-to-postgres https://docs.peerdb.io/usecases/Streaming%20Query%20Replicat...
All-in-all, very excited to see this project and will be watching it closely!
- saisrirampur 3y agoThanks for the feedback and I agree on making these missing features more visible in our documentation! We did it here - https://docs.peerdb.io/usecases/Real-time%20CDC/postgres-to-bigquery#coming-soon https://docs.peerdb.io/usecases/Real-time%20CDC/postgres-to-... But will make it more visible soon i.e. in streaming query, cdc, CREATE MIRROR docs etc. We were thinking something on the lines of ALTER MIRROR or provide a new OPTION in CREATE MIRROR that will automatically pick up schema changes etc. Exact spec is not yet finalized.