{"_id":"npm-postgres-mashup","_rev":"32-8a75d583151207e51a7d67f57937de15","name":"npm-postgres-mashup","description":"Replicate the npm skimdb into Postgres JSONB","dist-tags":{"latest":"17.0.3"},"versions":{"14.16.13":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"npm-postgres-mashup does a one-time replication of most of npm's data to postgres","version":"14.16.13","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"cradle":"0.6.x","knex":"^0.5.8","pg":"^2.11.1","async":"^0.2.10","postgrator":"^0.2.0"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@14.16.13","dist":{"shasum":"6f1de8395d511104e175660d475db3c1901eca48","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-14.16.13.tgz","integrity":"sha512-9WQFDvO7Aivvp6UP2kHDzkwpy2cv4C8YyOkgeHxju0Q39mywFiycyZrMTzUMTcq7yeJtccavDAaUiBatX/UT4Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDzC4cqSP5uiDgpnPxx4z81x6M6TLzeyqoEfAwafwyVHQIhAL2NY6jdNlT+BVEwl29OUm/Z3bdoAo0I3NvhtJyobG3j"}]},"_from":".","_npmVersion":"1.3.24","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"deprecated":"this package has been deprecated","directories":{}},"15.16.13":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency!","version":"15.16.13","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"knex":"^0.5.8","pg":"^2.11.1","async":"^0.2.10","postgrator":"^0.2.0","follow":"^0.11.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@15.16.13","dist":{"shasum":"95b958af2d0b9717fbaadb49f62cf03c8e6a754d","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-15.16.13.tgz","integrity":"sha512-qozp+ySyRXkDvgx2wcQJyi+Yj7oNvwDqBigG+ksUJJHX1zsveCdg4IrdgwsUhRldneUB33ZXWp9NtgjcCynAUg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIACTqP4Q7enySNKAcMbQWWM75zg6K4DHDSy93PbWAJdYAiADqPRUDKbo96LCNgzFFh+xon+s3Nt9IH65FZ8/MY70ig=="}]},"_from":".","_npmVersion":"1.3.24","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"deprecated":"this package has been deprecated","directories":{}},"15.16.14":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency!","version":"15.16.14","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"knex":"^0.5.8","pg":"^2.11.1","async":"^0.2.10","postgrator":"^0.2.0","follow":"^0.11.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@15.16.14","dist":{"shasum":"a9c280464be641af9c79ed59a362f1e7586f7cd5","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-15.16.14.tgz","integrity":"sha512-t/ZdNRKMOI43kUXFA/3NdVjub0ldvMkRU0lq+fgItkZTWhEby0YHDNCWBR3yRzT15uf/8YarZZxYUY/rvXdS9Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHghXlc6WxJkRzNF/jflUxWYRe6ttiRlvxiL/f+NkX6mAiBSnlSfuwxNhKY9P5nm+FNfR0TOtqCwv4gz2g3w0+thQQ=="}]},"_from":".","_npmVersion":"1.3.24","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"deprecated":"this package has been deprecated","directories":{}},"15.16.15":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency!","version":"15.16.15","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"knex":"^0.5.8","pg":"^2.11.1","async":"^0.2.10","postgrator":"^0.2.0","follow":"^0.11.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@15.16.15","dist":{"shasum":"032543587aedc5bcb1383ba964b657800c13904d","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-15.16.15.tgz","integrity":"sha512-wdl/XyqCkqlxiUIXpF2e+A4/YmBnWO8gxjC/n/JVjRoa6s8R8eiaIQIxxKXzJK6750AkAHmCTnwXFwn3Xkbjng==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIG0F7n3W9YoNkeVc8x6Zb8u5PfhgZcydK9gyR8coaVERAiEAjrBdk3bju++Ca1mgKS5lqp/G0lCiZlWT6W1FYFLjYLs="}]},"_from":".","_npmVersion":"1.3.24","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"deprecated":"this package has been deprecated","directories":{}},"15.17.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency!","version":"15.17.0","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"knex":"0.6.x","pg":"3.x.x","async":"0.9.x","postgrator":"0.2.x","follow":"0.11.x"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"gitHead":"56d77cc3a66fd5aaa870dbd578ad899b5fe32d68","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@15.17.0","_shasum":"225f4083da932bf5a2d1408e2a42479fa5409beb","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"225f4083da932bf5a2d1408e2a42479fa5409beb","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-15.17.0.tgz","integrity":"sha512-+ZXzVOd/uu8x1nahB2/CAC6wO2kda/IjpgPmqFHgvgltx9a50BCrcVlz9I1zUsOEQ7uVZht37RODEXbGsquVfQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC3ReBRTeMHlclcH2tIa6ImPjbO9esR6zw9BTv260HIWQIgJSmyAkQnZQ5/NB/+kTBDgYbVycR46NmOV/coxpJQwuk="}]},"deprecated":"this package has been deprecated","directories":{}},"15.17.1":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency!","version":"15.17.1","main":"npm-postgres-mashup","keywords":["npm","postgres","replication"],"scripts":{"test":"node test.js"},"dependencies":{"knex":"0.6.x","pg":"3.x.x","async":"0.9.x","postgrator":"0.2.x","follow":"0.11.x"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"gitHead":"85b13f59357389f74e86b99fa3b7b7c48e64c86e","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@15.17.1","_shasum":"34022365777b88dbf4178c813e2f1cb15bd96438","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"34022365777b88dbf4178c813e2f1cb15bd96438","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-15.17.1.tgz","integrity":"sha512-tpEFwP89K7YGU+SqPd3d4kHvnGiZDEUzq+pH3s10LnCVJfhRK1/YmAGIpR+BcgYJEPbgZH8gKF7tkM3qW9czIg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAdH92NDsOG5mIKTEXUlbtlZyubOHjZn5BOuP40G1ArpAiBg2EtwuI+Cqb2TMnwxOUUORSrTuz759gx91PkLKWE2pQ=="}]},"deprecated":"this package has been deprecated","directories":{}},"16.0.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.0.0","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"aec8404591e29fff62e1e062307ba6474f5ca5a7","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.0.0","_shasum":"8d6fdcacb86b919d787d1f14db86da73459a0494","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"8d6fdcacb86b919d787d1f14db86da73459a0494","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.0.0.tgz","integrity":"sha512-k9o8uiqUDE2SCCa2LtqJVpxkBzcbc4jIVzp/sp8YHLeU+SldNjdIFRdwQq+W3MioKn2qeg9nC2nAEmdjY3LZJQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDIqmZrF9eycUd5bb8kh1YSLsVjOd5deHclQ+PuAoIEKQIgK2c82paFyzuG1T1Ke8qc2E0LPO6BG+e1wsHS6Luz5NM="}]},"deprecated":"this package has been deprecated","directories":{}},"16.0.1":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.0.1","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"49ab6126e63e57e33fc64360e27e32a641b416d8","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.0.1","_shasum":"7102b667f02ab391f23c45a13ce7278b9fc5a5b2","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"7102b667f02ab391f23c45a13ce7278b9fc5a5b2","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.0.1.tgz","integrity":"sha512-OGB2I6aleGd0/qBtg3utXPyCcMxGZOG02OfMEo4PILQ0bpgNWF4kKxbhYL8xsgz6zd/7lyLnOZUfslWFlH7zDw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBCQK6c0CQHrD/Yb5Ohd9jAMMgym22vfDL0/gGzio0MbAiEAiBG5Z5lkAvYtdGAi6tBC24J109DgN19L9JzrlKUWQhE="}]},"deprecated":"this package has been deprecated","directories":{}},"16.0.2":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.0.2","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"123140a60413f875d6c757f94625187134f311b9","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.0.2","_shasum":"98a483637e83958aad5147b436b519219d8e6f20","_from":".","_npmVersion":"1.4.21","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"98a483637e83958aad5147b436b519219d8e6f20","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.0.2.tgz","integrity":"sha512-ZK5AFH1BkZCfElyfLAobSn0NvIz6AXWgagG6cSlD+2mD7Yu6NjXXv+VyxZzYRAlPynBct71SJaw/hO87RLt5TQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDgVzklY7MbCRLzJcb8FZ3JyF9VJoM0dJeWTFGVT0HgjAiBLT5Uk8OiyT9z5Y5lFuI+5bg3QqUXsQUq3XlniJL2s1A=="}]},"deprecated":"this package has been deprecated","directories":{}},"16.1.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.1.0","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"d9a4aa28cd52681c9a2f4f35ec204aa0439509f4","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.1.0","_shasum":"2020c96ac6e28498c26a2eb9566a82ee37b89a59","_from":".","_npmVersion":"2.1.11","_nodeVersion":"0.10.30","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"2020c96ac6e28498c26a2eb9566a82ee37b89a59","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.1.0.tgz","integrity":"sha512-UCTKXfZ39FthEgVGG5e4oXWcBccebHfpttVNPmhGyBtvXzQ4pN/fKPksVhAOrdwQ2Xkh95Mof9Fw891hL+V6Ow==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFIYT7NwBAh8R6YPAH7iIPCZExifG3r3RYQtO6jV1C4wAiBuiscvFjfkgx/38HL366z+ubUDY6iQa8DruWVcooDgUg=="}]},"deprecated":"this package has been deprecated","directories":{}},"16.2.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.2.0","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"90c343a38c2c2d8cd04449b540ebef06a3abb6a6","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.2.0","_shasum":"a8bafd70ee143b02883e8f481cd1d7a4ae675a61","_from":".","_npmVersion":"2.5.0","_nodeVersion":"0.10.30","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"a8bafd70ee143b02883e8f481cd1d7a4ae675a61","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.2.0.tgz","integrity":"sha512-a8XucxJ+Tge62l/OOQmSv3J8vKU9Q5O7XZFSmq5WGM4Zn95AG3JlqNDgRlYsN7dSgpKAkHFHrfJu/RnUD+DlYQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCPgGUa+w02qFqOxvX4GKiHEkuK3FHXqDvv6viTyNXWlQIgQm4QzIVP+5JzItFq8mC6JC+MmR5uEgs9Fdk0vbxMVZw="}]},"deprecated":"this package has been deprecated","directories":{}},"16.3.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate most of the npm skimdb registry to a relational model inside Postgres. Now with continuous replication and more efficiency and cli!","version":"16.3.0","main":"npm-postgres-mashup","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node test.js"},"dependencies":{"async":"0.9.x","commander":"^2.3.0","follow":"0.11.x","npm-download-counts":"^0.1.1","pg.js":"^3.4.4","postgrator":"0.2.x","sql-bricks":"^1.0.0-beta.2"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"4ed17086ef20cf1af1e5533a900d33012942db77","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup","_id":"npm-postgres-mashup@16.3.0","_shasum":"d5948a55a19f67ebd82406a40962da719fbf54ed","_from":".","_npmVersion":"2.5.0","_nodeVersion":"0.10.30","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"d5948a55a19f67ebd82406a40962da719fbf54ed","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-16.3.0.tgz","integrity":"sha512-Y8+AfKIH5zQdccQchUeX5jAfS6fHZ9GSftmeNiaTm8GiK1qeSX5OUJGUvCQNjwBbrHVK8ApyG0YlUyoA3h09zg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGXByXceY1l1ILLBHyjNYocgrHqEiPfMdgNIUvQL7MxPAiEAzIUwJU2nZbQJjYJ2Y771cb0CjFf84R+SNsODtEHxXkA="}]},"deprecated":"this package has been deprecated","directories":{}},"17.0.0":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate the npm skimdb registry into Postgres JSONB","version":"17.0.0","main":"npm-postgres-mashup","license":"MIT","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node ./bin/npm2pg.js -d npmpg -u npmpg -p npmpg --confirm-version 17"},"dependencies":{"async":"^1.5.2","commander":"^2.3.0","follow":"^0.12.1","lodash":"^4.13.1","massive":"^2.3.0","npm-download-counts":"^0.1.1","pg":"^4.5.5"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm2pg.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"3711c48680b8d0bf5362434a051ccebfc5a63728","bugs":{"url":"https://github.com/rickbergfalk/npm2pg/issues"},"homepage":"https://github.com/rickbergfalk/npm2pg#readme","_id":"npm-postgres-mashup@17.0.0","_shasum":"6fe00e45b075fe9950fb30a76c613b9bf85f385b","_from":".","_npmVersion":"3.8.8","_nodeVersion":"4.4.3","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"6fe00e45b075fe9950fb30a76c613b9bf85f385b","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-17.0.0.tgz","integrity":"sha512-b+UTgFZY/CtQQ+tJS2fdIvXLwcyelvlZGWfiI1zN7CmUQz7BbKuAIrG71qdmQpyOSC9bfYG5Wzqi3USfLTRB0g==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHbgMUf/bLwooK3SLXzeqAoDZrKj7UjMoUxwOHB+ysusAiEA4MjvmLngDA2qi+d45aCls/MuCrd48ub++kUB4pW951I="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/npm-postgres-mashup-17.0.0.tgz_1465356320542_0.9177771501708776"},"deprecated":"this package has been deprecated","directories":{}},"17.0.1":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate the npm skimdb into Postgres JSONB","version":"17.0.1","main":"npm-postgres-mashup","license":"MIT","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node ./bin/npm2pg.js -d npmpg -u npmpg -p npmpg --confirm-version 17"},"dependencies":{"async":"^1.5.2","commander":"^2.3.0","follow":"^0.12.1","lodash":"^4.13.1","massive":"^2.3.0","npm-download-counts":"^0.1.1","pg":"^4.5.5"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"c91b990401d50d28b0a49da982994edb6598e904","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup#readme","_id":"npm-postgres-mashup@17.0.1","_shasum":"8431a5647fe7773a296016aaf8373a836361ab7e","_from":".","_npmVersion":"3.8.8","_nodeVersion":"4.4.3","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"8431a5647fe7773a296016aaf8373a836361ab7e","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-17.0.1.tgz","integrity":"sha512-z93a9+JptWf/NRy7lwyg5GwQtGRordhHaIeSI/E6fO9TmOZIqYaTHySH1TSvZUodW1VoftxEij8xjF9HqqVc4w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIH0JQMm6qpwAJhOOY5yQA06xCPJbS8c/rNlYsamKzBs9AiEAh/FRIobSRHwYMNg2XgJRoYdf9yJcAbthTIWnZU5ecxs="}]},"_npmOperationalInternal":{"host":"packages-16-east.internal.npmjs.com","tmp":"tmp/npm-postgres-mashup-17.0.1.tgz_1465356421181_0.818116890732199"},"deprecated":"this package has been deprecated","directories":{}},"17.0.2":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate the npm skimdb into Postgres JSONB","version":"17.0.2","main":"npm-postgres-mashup","license":"MIT","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node ./bin/npm2pg.js -d npmpg -u npmpg -p npmpg --confirm-version 17"},"dependencies":{"async":"^1.5.2","commander":"^2.3.0","follow":"^0.12.1","lodash":"^4.13.1","massive":"^2.3.0","npm-download-counts":"^0.1.1","pg":"^4.5.5"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"adc379efd60eafc5f8d06f352753f7e45ad15a60","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup#readme","_id":"npm-postgres-mashup@17.0.2","_shasum":"93c5d663038fe3d1638ca1a02ba33c5d78f88e9f","_from":".","_npmVersion":"3.8.8","_nodeVersion":"4.4.3","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"93c5d663038fe3d1638ca1a02ba33c5d78f88e9f","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-17.0.2.tgz","integrity":"sha512-RDz46e4CJvDm26vqECbvcYIhPt8Yyed0XOWo7Opd3/MS0HYJIv9sqGoqTnP6MWf2JsujcsYfbhQp8+0uRNjruA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHKYDdkT5O+40l9QzHP7WTOUSsUrO10Kab7q9Q18OYqoAiEA7YUe0rDxCE1FBUn+dYP3pAy5SLnOKEUsk17GNGkk1X0="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/npm-postgres-mashup-17.0.2.tgz_1465356621718_0.6617283329833299"},"deprecated":"this package has been deprecated","directories":{}},"17.0.3":{"name":"npm-postgres-mashup","author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"description":"Replicate the npm skimdb into Postgres JSONB","version":"17.0.3","main":"npm-postgres-mashup","license":"MIT","keywords":["npm","postgres","replication","cli"],"scripts":{"test":"node ./bin/npm2pg.js -d npmpg -u npmpg -p npmpg --reporting-tables"},"dependencies":{"async":"^1.5.2","commander":"^2.3.0","follow":"^0.12.1","lodash":"^4.13.1","massive":"^2.3.0","npm-download-counts":"^0.1.1","pg":"^4.5.5"},"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"bin":{"npm2pg":"./bin/npm2pg.js"},"gitHead":"f7ef39961ca3dd27200540dcd694c8f82cf31dc5","bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup#readme","_id":"npm-postgres-mashup@17.0.3","_shasum":"ee14ca150e85a3d71ebc3478da3b463c28181862","_from":".","_npmVersion":"3.8.8","_nodeVersion":"4.4.3","_npmUser":{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"},"maintainers":[{"name":"rickbergfalk","email":"rick.bergfalk@gmail.com"}],"dist":{"shasum":"ee14ca150e85a3d71ebc3478da3b463c28181862","tarball":"https://registry.npmjs.org/npm-postgres-mashup/-/npm-postgres-mashup-17.0.3.tgz","integrity":"sha512-DEG9WtbUZAJQ0K8S0RtuR/VS6MdlE/YIeCdB0WMHJjlvtiiU6KQVCfkIHjwJaOlaew+TwuyZDAqsOWZHYwvMOg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIB2I+6UN1WI2bze/A3DTIaOVpfZTMBGW7FU10+JuVztjAiBus4vUKZmQbPgros0jEIW24UbWXmxULDNSQoaaySRYtQ=="}]},"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/npm-postgres-mashup-17.0.3.tgz_1465497752751_0.0491715632379055"},"deprecated":"this package has been deprecated","directories":{}}},"readme":"# npm Postgres Mashup\n\nA cli tool to replecate the npm skimdb into Postgres. \n\n**Now Utilizing JSONB!**\n\n\n## New in Version 17\n\n- All packages are captured (even those with unicode NULLs)\n- All package data is captured in JSONB document just as it is in npm\n- Deleted packages are marked accordingly\n- Reporting tables are built out via postgres sql queries and JSONB functions\n\n\n## Breaking Changes\n\nVersion 17 newness brings a lot of breaking changes.\n\n- Complete schema rethink. **ANY PREVIOUS NPM-POSTGRES-MASHUP TABLE WILL BE DROPPED**. If you like the old schema don't upgrade or use a different database for future versions.\n- A relational model is no longer used. Instead the couchdb documents are stored in JSONB. \n- npm-postgres-mashup is only intended to be used as a cli utility, npm2pg. The previous api was lacking, and really if you want something to interface with at this level you should just utilize the follow library directly.\n- Download counts have been removed. Scraping the download-count api was slow and I felt like things weren't as efficient as they could have been. Download counts might come back but I need to rethink the approach.\n\n\n## Installation & Usage\n\n```\nnpm install npm-postgres-mashup -g\n```\n\nThis installs the cli tool \"npm2pg\". Next create an empty Postgres database.\n\nPrior to replicating the data into the database, you'll need to build the schema. \nRunning this after a major npm-postgres-mashup version change will drop some tables.\nTo build the schema run:\n\n```\nnpm2pg -d database -u username -p password --build-schema\n```\n\nOnce the schema is built, you can start replicating the data. \nDo this by running: \n\n```\nnpm2pg -d database -u username -p password\n```\n\nnpm2pg can also build reporting tables from the package jsonb documents. \nAdd ```--reporting-tables``` parameter to run this after sync is complete.\nOtherwise you can run the SQL yourself (see ./db/createReportingTables.sql)\n\nTo get to the cli help about additional parameters run:\n\n```\nnpm2pg --help\n```\n\nnpm-postgres-mashup will automatically add the necessary tables to the postgres database. \n\n\n\n## License\n\nMIT\n","maintainers":[{"email":"npm@npmjs.com","name":"npm"}],"time":{"modified":"2022-06-22T08:40:36.103Z","created":"2014-03-27T02:43:51.390Z","14.16.13":"2014-03-27T02:43:51.390Z","15.16.13":"2014-06-10T04:41:14.737Z","15.16.14":"2014-06-10T05:14:57.682Z","15.16.15":"2014-06-11T02:22:56.209Z","15.17.0":"2014-08-19T01:36:08.034Z","15.17.1":"2014-09-20T16:28:15.475Z","16.0.0":"2014-09-29T03:43:16.741Z","16.0.1":"2014-09-29T03:55:05.773Z","16.0.2":"2014-09-29T04:27:19.051Z","16.1.0":"2015-01-31T04:21:36.017Z","16.2.0":"2015-09-18T04:00:24.501Z","16.3.0":"2015-09-28T04:30:34.471Z","17.0.0":"2016-06-08T03:25:23.118Z","17.0.1":"2016-06-08T03:27:03.189Z","17.0.2":"2016-06-08T03:30:23.884Z","17.0.3":"2016-06-09T18:42:35.231Z"},"homepage":"https://github.com/rickbergfalk/npm-postgres-mashup#readme","keywords":["npm","postgres","replication","cli"],"repository":{"type":"git","url":"git://github.com/rickbergfalk/npm-postgres-mashup.git"},"author":{"name":"Rick Bergfalk","email":"rick.bergfalk@gmail.com"},"bugs":{"url":"https://github.com/rickbergfalk/npm-postgres-mashup/issues"},"readmeFilename":"readme.md","license":"MIT"}