PostgreSQL is our database of choice, and PostGIS turns it into a full geographic information system. Questions like which census tracts a project touches, or which locations fall within a drive-time area, are answered in the database itself.
Why we use it
- Proven reliability for financial records.
- Spatial indexes and queries on census tracts, ZIP Codes, counties and custom boundaries.
- Managed schema changes and tested backup and restore procedures.
- Open source, with no per-core licensing.
Where you will see it
- Summit, which keeps project, institution and geographic data in PostgreSQL and PostGIS.
Planning a system that needs this stack?Talk to HFS