node-pgtiles

PostgreSQL schema for vector tiles. Modeled from Mapbox mbtiles and CartoDB postgresql extensions

Dependencies

• PostgreSQL
• Node.js
• NPM

Install

$ npm install pgtiles

Use

var pgtiles = require('pgtiles');
var connectionString = 'postgres://username:password@host:dbname/5432';

var tileSchema = pgtiles(connectionString);

// Add the table schema and functions to the designated PostgreSQL database
tileSchema.create(function(err, result) {
  if (err) {
   // handle error
  }

  console.log(result);
  // Result show the tables and functions created
});

// Remove the tables and functions to rollback the database
tileSchema.rollback(function(err, result) {
  if (err) {
    // handle error
  }

  console.log(result);
  // Result show the tables and functions dropped
});

Andy B