Richard

Thanks Pavel. I've already upgraded :) On Mon, Feb 17, 2025 at 2:44 PM Pavel pavel-jm@users.sourceforge.net wrote: Thank you for your contribution, r035198x! https://symmetricds.org/news/symmetricds-3-15-13-released/ Derby boolean types https://sourceforge.net/p/symmetricds/discussion/739236/thread/f6b954c4/?limit=25#ea8f Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/symmetricds/discussion/739236/ To unsubscribe from further messages, please visit https://...

Hi Pavel Thank you. I registered under my business email richard@de**ed.co.za recently, so I will engage on that platform going forward. On Sat, Feb 8, 2025 at 3:43 AM Pavel pavel-jm@users.sourceforge.net wrote: Hi Richard, I can see you have good ideas on making SymmetricDS better and skills to follow-through! To establish closer collaboration, could you create a free account on the issue tracker web site? https://issues.symmetricds.org/signup_page.php We typically create an issue card for each...

I notice that they values for use_old_data_to_route, use_row_data_to_route, and use_pk_data_to_route are all TRUE on the default reload channel. I'm wondering if this is necessary?

In a simple 'home' and 'away' configuration, I noticed that after the initial load, there were approximately 28 million data events that needed to be routed on the 'away' node before the initial sync could be considered complete and before changes would start pushing to the 'home' node. If the 'away' node is using Derby, this process becomes so slow that it is not feasible. To test this, I created two 'away' nodes using the same 'home': one using Derby and one using PostgreSQL. The PostgreSQL instance...

I notice that they values for use_old_data_to_route, use_row_data_to_route, and use_pk_data_to_route are all TRUE on the default reload. I'm wondering if this is necessary?

Hi Would be great if you guys could add this to the base code. DerbyTriggerTemplate { this.booleanColumnTemplate = "case when $(tableAlias).\"$(columnName)\" is null then null when $(tableAlias).\"$(columnName)\" =true then true else false end"; }

I resolved this by extending the Derby Dialect as per the code below. It would be great if this could be added to the base code. private static final class DerbySymmetricDialectEx extends DerbySymmetricDialect { public DerbySymmetricDialectEx(IParameterService parameterService, IDatabasePlatform platform) { super(parameterService, platform); this.triggerTemplate = new DerbyTriggerTemplateEx(this); } } private static final class DerbyTriggerTemplateEx extends DerbyTriggerTemplate { public DerbyTriggerTemplateEx(ISymmetricDialect...

I am currently using 3.13.4. But my database goes back to 3.8 when it started. On Wed, 08 Mar 2023, 20:10 Jake Van Meter, jvanmeter@users.sourceforge.net wrote: It is fine to clean these up manually. Out of curiosity, what version of SymmetricDS are you running? Orphaned SYM_DATA and SYM_DATA_EVENT https://sourceforge.net/p/symmetricds/discussion/739236/thread/3024bb4612/?limit=25#e1ac Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/symmetricds/discussion/739236/...