Hi,
Currently Esri officially only supports/certifies PostgreSQL + PostGIS as an enterprise geodatabase. Would it be possible to also do this for PostgreSQL + PostGIS + TimescaleDB?
In theory this combination should work already with ArcGIS Enterprise because TimescaleDB hypertables look and act like any other table in PostgreSQL. But the company I work for will not allow me to do this without some form of official support from Esri.
Being able to use the TimescaleDB extension for PostgreSQL with ArcGIS Enterprise will bring the following benefits:
- Write time series data straight to PostgreSQL from external systems. In our case we would like to do this with Spark from our Hadoop cluster and bypass GeoEvent Server.
- More control over your data than the spatiotemporal big data store gives you. Things like schema changes, bulk updating, etc are a pain when using the big data store.
- All data together in 1 database means you can combine batch and streaming data with joins and/or views.
- In theory spatiotemporal big data store is no longer needed so less components for Ops to worry about.
Regards,
Bert
