The Dirt-Simple PostGIS HTTP API is an easy way to expose geospatial functionality to your applications. It takes simple requests over HTTP and returns JSON or JSONP to the requester. Although the focus of the project has generally been on exposing PostGIS functionality to web apps, you can use the framework to make an API to any database.
This release uses Node. The previous release, based on PHP, is available in the v1 branch.
You'll need PostgreSQL and PostGIS set up with some data in it.
Install Node. Then install the project dependencies:
npm installRename config/index.js.txt to config/index.js and modify the connection and other information to reflect your environment. Then start the server.
node .Set your browser to http://localhost:8123/documentation to get started. The documentation will allow you to interactively try the services, see the URL that gets built, as well as the results.
The project uses the HAPI framework and supports CORS as well as JSONP for elderly IE. JSONP will automatically be returned if a callback query string is sent. All of the services are picked up from the files in the routes folder.
The documentation is built using Swagger based on descriptions in the code. Check out one of the files in routes and you'll see where it comes from.
Input validation and default values are handled via joi, which allows for deep checking. The SQL queries are built using Squel. While SQL isn't hard to write, complex string manipulation is ugly and error/injection prone, and Squel helps greatly with both of those things.
You should be able to do almost anything you need from config/index.js. It contains database connection, data fetching, and special operations for custom schemas, like the search. The individual routes contain documentation/validation for the route and a function to build the SQL call.
Babel is included in the project, so you can use ES6 features, although the only ES6 feature I'm using right now is template strings.
If you are proxying behind Apache, you'll need two proxies to deal with swagger. If you wanted to share your project at /api, you would need:
ProxyPass /api http://localhost:8123
ProxyPass /docs http://localhost:8123/docsYou will also need to modify basePath in config/index.js to http://localhost/api.