Our great sponsors
-
symmetric-ds
SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.
There are several CDC (change data capture) solutions on the market. I've used https://www.symmetricds.org quite successfully in the past.
-
then there is https://github.com/pramsey/pgsql-ogr-fdw ( found with google) that allows you to read shapefiles as they were tables in postgesql. So that could remove data import phase and allows you to have only one SQL which figures out what it should merge into central.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Related posts
- How do I add database replication across different servers to my Docker Compose deployment without using different Docker files on each server?
- Dockerfile for jumpmind image
- How do you "ship out" web-based systems na isang establishment lang gagamit?
- migrate giant 17TB DB from mariadb10.4 to MySQL 8
- [AMA] We are the developers of SymmetricDS, a FOSS database synchronization project. Ask us anything