The latest outputs from researchers, alumni and friends at the UCL Centre for Advanced Spatial Analysis (CASA).
I recently implemented an authentication system, supported by a table on the database. In this table, I store the usernames and passwords. The PostgreSQL “pgcrypto” module supports encryption of specific columns, but I wanted to avoid “bulking” my system with … Continue reading →
A while ago, I wrote a post about multi-master replication using symmetricDS. My scenario consists of a system with multiple nodes, all of them writing in their copies of the database. Sometimes the nodes may be offline, but I would … Continue reading →