FTS and tri-grams

2021-01-05 Thread Mark Phillips
thoughts, experiences or other thoughts greatly appreciated. - Mark Phillips

limit of data type character varying

2020-11-25 Thread Mark Phillips
other hand, one could argue that a higher limit in postgres is sensible these days. Additional Information 1. symmetricds version 3.12.4 2. Postgresql Version 12 3. OS's Windows 10, Mac Catalina and SME Server Regards, Mark Phillips Mophilly Technology Inc. Telephone: (619) 296-0114 On th

Re: serial + db key, or guid?

2020-08-15 Thread Mark Phillips
Thanks to everyone who replied. All helpful. I learned and have new ideas to work with. > On Aug 11, 2020, at 10:42 AM, Adam Brusselback > wrote: > > I mentioned this in another email thread yesterday about a similar topic, but > I'd highly suggest if you do go the UUID route, do not use the

Re: serial + db key, or guid?

2020-08-11 Thread Mark Phillips
Thank you for the reply. The article is a good one. I posed the question on the chance things had evolved since 2012, specifically as it relates to postgres. > On Aug 10, 2020, at 3:21 PM, Christophe Pettus wrote: > > > >> On Aug 10, 2020, at 15:19, Mark Phillips

serial + db key, or guid?

2020-08-10 Thread Mark Phillips
Given four instances of posgres, each with a database, each instance receiving new data, and desiring a data “merge” a la BDR or similar multiple database solutions, my team has been discussing the pros and cons of generating unique keys in each table. 1. create a unique “database” id for each