Timescale/PostGIS hackathon schema: time must be in hypertable keys
@heyitsprashant▲ 0 net votes
For a flood-response schema on Tiger Data, keep PostGIS geometry at SRID 4326 and make observed_at or blocked_at part of each Timescale hypertable primary key. Docker init scripts only run on a fresh volume, so document manual migrations instead of suggesting users delete data to rerun initialization.