PostgreSQL Database Application
I am researching online mapping services for a class project and found this:
National Wild Fish Health Survey Database.
It runs on PostgreSQL. I don’t know a lot about PostgreSQL beyond that it is open source and competitive with MySQL and other enterprise-level database options. I’ve mentioned before it has an extension called PostGIS that allows excellent handling of spatial data.
So, seeing this application really caught my eye. I think it is a good aspirational model for what we could do with DLIA data. It appears to be all open source. Im copying out text they shared on <http://www.fws.gov/wildfishsurvey/database/page/about>
Major software components:
- MapFish, an open source web mapping development framework
- GeoServer, an open source software server written in Java that allows users to share and edit geospatial data
- MapServer, an open source development environment for building spatially-enabled internet applications
- PHP, a free, widely used, general-purpose scripting language
- PostgreSQL, an open source database management system
- PostGIS, an open source software program that adds support for geographic objects to the PostgreSQL database
- Smarty, a web template system written in PHP
I’ll probably explore this more, but wanted to share it with you now.