Safe, Secure, and Scalable

The open source database PostgreSQL is at the heart of the OpenNRM software stack.  PostgreSQL is a powerful, object oriented relational database that ensures data is safe and secure while maintaining high level performance and scalability.  PostgreSQL has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity and correctness.  It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).  It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL and TIMESTAMP.

As part of the OpenNRM stack we also encourage the use of PostGIS a spatial database extender for PostgreSQL.  PostGIS adds support for geographic objects allowing location to be run in SQL.  In addition to basic location awareness, PostGIS offers many features rarely found in other competing spatial databases such as Oracle Locator/Spatial and SQL Sever.

But don’t worry!  If you need a custom database solution like Oracle, Microsoft SQL or ESRI ArcServer, we do that too!  Just inquire with our professional services division.