Integrating Kyoto Tycoon With PostgreSQL

CloudFlare, a web performance and security company, uses two technologies - PostgreSQL and Kyoto Tycoon (KT) - to manage its global network of datacenters. PostgreSQL is a classic SQL database engine that powers the CloudFlare website, while KT is a distributed key-value store used for replicating configuration changes across all datacenters. The company previously relied on scripts to reconcile data between these two systems, but with the introduction of writable foreign data wrappers (FDW) in PostgreSQL 9.3, they can now use database triggers to synchronize data more efficiently and simplify the process. CloudFlare has open-sourced their KT FDW code for others to benefit from this integration.