{"_id":"@4nd3rs0n/pgsql-migrate","_rev":"14-47ea3f14eb65e522d16e342948be7abd","name":"@4nd3rs0n/pgsql-migrate","dist-tags":{"latest":"0.0.24"},"versions":{"0.0.1":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.1","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3","pg-tx":"^1.0.1"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.1","gitHead":"a235c27d0c1feacde7da85e5414a3512acdd30c3","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.5.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-Xe+b1E2uYljk3m0w1LpgG84Y1SlrG/EhoHzwz3YiEZK1MXanGoNp5z1ZxzA0ZSDP/JHvbOFpMYmqSkh5xL4HCg==","shasum":"26c52e24e7df0fa7a95abb640474f302ad647c20","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.1.tgz","fileCount":13,"unpackedSize":24695,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCSlLqS9YqVdQp03A3yLbUINVQx8H/Or/Aa0/ECUVkj/gIge5MjiwCcN14D4LbTBeTA4URPzloMsHFSoSmWndMMBCE="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.1_1705574980899_0.8994875375821065"},"_hasShrinkwrap":false},"0.0.11":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.11","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3","pg-tx":"^1.0.1"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.11","gitHead":"5e05af736df0f9dfbdddee9cb4aa607660bdabdc","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.5.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-BiYaXQBsImN396yRTbjrVCK3/wWHjIWMystQqRysg+ALiCejXSZNX+5LWs/8pWuStGUTHCmVgcuC2wtmjcGk+w==","shasum":"caa3d3eaba1eb849b23cdc997e1843a72b981b4e","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.11.tgz","fileCount":11,"unpackedSize":19638,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD74Y9TyRZLjo0E7Fk4TReq5ZZnB9wX/DgPbZwThv3N4QIhAPapdfG1VUDN6OfjAw9C/3xSPnz3l2VGOAHFn9ya04dJ"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.11_1705600252717_0.6464333614372086"},"_hasShrinkwrap":false},"0.0.12":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.12","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3","pg-tx":"^1.0.1"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.12","gitHead":"22a89849190c300f8499a530eaa6b094ab730399","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.5.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-qJgOzxcpPgAbo19iciDLW0QN47uA2giQS7w8UccFVePx+nNS85iL6VSzWjxsOj4142DxWOq/7TQ6q+BzPG+J0A==","shasum":"7448133e24a35e82d8f74357396e539ff6205461","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.12.tgz","fileCount":11,"unpackedSize":19638,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDCDLGPOuDha/2DKMtk8qearAbHq5N099LsvVHR/OxAgAIhALv6PSCfdbgPxXc1jLgi4buajttmj8gf/MfITYm76U7O"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.12_1705600706383_0.040602923433496585"},"_hasShrinkwrap":false},"0.0.13":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.13","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3","pg-tx":"^1.0.1"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.13","gitHead":"ee9aa7d070073725b1e164461374af6ffb137958","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.5.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-2ETHu9N9JM1X+w116uvxKJDZwfiYN9hedpWGWAhNM2qBadf1ajknTfS5Gy5pdFtcaR7zoQEUVB/pdO7UNbwDZQ==","shasum":"22b59b74cc86d98196c9972587276d1b535ffd39","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.13.tgz","fileCount":11,"unpackedSize":19638,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC0BGdo0V25oFspW8baNy4CKkZqNwKytvi8xdd2L8NbKwIhAOPWul5RmDI7A1XMkeXfdmmvxm7pOx/4X860CAbUIhJz"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.13_1705603916858_0.806185716819986"},"_hasShrinkwrap":false},"0.0.14":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.14","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3","pg-tx":"^1.0.1"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.14","gitHead":"ee9aa7d070073725b1e164461374af6ffb137958","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.5.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-Q0CcmDod5N5paatIe1oMzrNxBaAxt/fTgR/UnDTDLXJ2B9S9bGylU3zrnJM3GzafVgdKJsbHO+sFX7iZi5L9ZQ==","shasum":"7b7232c774e38a855b174142bf825899b9cf6929","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.14.tgz","fileCount":11,"unpackedSize":20248,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICoWA2dz6LwqmeOrBCIjI3iQpsP0FARjq5rRk0v5GfeqAiAGsHhKmjcPlxl2pTtzllZ+cPu6QPO2fO70LJTQOne5fw=="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.14_1705604076688_0.23068929449129794"},"_hasShrinkwrap":false},"0.0.15":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.15","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.15","gitHead":"ab17f41b31c5cc8ed101005ccfa4e205771e8252","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-ZZiclzIJhCLFiBA7IbrpU3UFjWGv6zNczMpNT4y9QmsiG6O4Wj/2jyk6tm1c2phggY9jZemGTOicv2yxXFqauA==","shasum":"f66b6f64dde1cd7ab9b1800e7fe47e2d54970775","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.15.tgz","fileCount":11,"unpackedSize":20225,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIDNM6pcxr5ABuhteqDKA2IvyLtxajpYPssxHJyea7z+dAiEAqklOntQYIvsLa847zCkRZh5YTCaSi7i/bUvlLptuQxI="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.15_1705618488928_0.314565722277131"},"_hasShrinkwrap":false},"0.0.16":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.16","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.16","gitHead":"ab17f41b31c5cc8ed101005ccfa4e205771e8252","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-6iaN7hdpbs3J+KygBzrLG1qcTHAiqEYl9JwrgpoHhjjc9wqFyE0Ocb2MKHbUHTZSr3wXMGPtMgBzVjC4UyEALw==","shasum":"4344d543d684c81a5a8a77e6f6bd9e424a969b0f","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.16.tgz","fileCount":11,"unpackedSize":21904,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDdJFGtdH6QkvaFBjDuaH4g1v2QblYlIjSsvaPpxGuTVgIhALyB7S9EDRKfYf/Sxqo2lnVf6J/CqR2M9B4dB1vkgJ/E"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.16_1705618653212_0.7308374072087884"},"_hasShrinkwrap":false},"0.0.17":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.17","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.4","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.17","gitHead":"ab17f41b31c5cc8ed101005ccfa4e205771e8252","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-L7xofCoge6dwNxdCiWAwSY3IF+Chpn0uITYOZVv2o9s6K47B0FKet2yLoTObSLGnrn6weRtR8kbYT6JOKEv9Rg==","shasum":"55080ec68c3b3fd9fa06a3742de2776fcf25a075","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.17.tgz","fileCount":11,"unpackedSize":21902,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDjYcXFcgXQ7DbQU28E72JJY+hU0Uw8PNxGpQnesIuITQIgVbMkNS9nfBV7R2AN7m+d8zSsU0MIFkXHn1CSlgFKCFo="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.17_1705662205970_0.7906403334492809"},"_hasShrinkwrap":false},"0.0.18":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.18","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.18","gitHead":"7412a7085f8c3d465492a91b30f1e4abf2a9a1eb","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-wrdb9oJ4QX9dbzlypYLitPLbzwYoDj7a+ml+PizUoY909a8anr8QVcgFUlAVKyBAvPl//GuHYxv8NYE9P1O9zQ==","shasum":"593be9a5f2c291a2772be0f720dd069b5df279ab","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.18.tgz","fileCount":11,"unpackedSize":22043,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCYx2QsnK3EkpM9G4jj+QtAUOp6wTJeBykGmHMOyVIErQIhAPWvGDQ8378ez+9dth3UlGYTSQRS2GXgCfzzeRY29y2P"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.18_1705665343453_0.15006874455213182"},"_hasShrinkwrap":false},"0.0.19":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.19","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.19","gitHead":"ca910d2d022d991b527dd534838d954f6d8105ed","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-6PuIcA1J6Xiz+3HfmSYRCg7kiBr96iqQtj84dtQhy2gaJjOToyJVrVZlMGM5SanXvQ/+hZQZAlIX9HRa/fhKtA==","shasum":"c7d890c39429efb10e6428fda0e9fbb2b16324f2","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.19.tgz","fileCount":11,"unpackedSize":22041,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGytAFssC5I53MW+rrFEbl9jfOCGR5y9d77kjQmW3z1tAiBFfPFKROQLucdmxrdWb1KWEU/yXB1YDyXDy+6lTvVDng=="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.19_1705668214861_0.4241970922089173"},"_hasShrinkwrap":false},"0.0.20":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.20","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.20","gitHead":"ca910d2d022d991b527dd534838d954f6d8105ed","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-kEqy++hFgjWQfxMKU3oz49yOWG3O03CleU9VkWCMp52S18AnzVdbrQEApLz05BFqcIi8yDuqgx6H9lgZShMKWg==","shasum":"9ced197ca9aea2ea4fb67f3aa0251ccd2952437b","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.20.tgz","fileCount":11,"unpackedSize":22165,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEcGcEqSWV78MpMvylxtoSPxinQj07Fed1Do0KjBTy6xAiEA1TWLDcwoDsfLdS6Dup0WTrPn/Ql21q8w4P9c0tfXKFU="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.20_1705669126954_0.751993454685522"},"_hasShrinkwrap":false},"0.0.21":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.21","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/psql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.21","gitHead":"ca910d2d022d991b527dd534838d954f6d8105ed","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/psql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/psql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-JUdS9r617UogfWpzzvHwHMULRNOwUUrN6ZOJQLrcv4ByJblg1ufs1ww9G9HpCUvBHWa9UM/edHdXhbCOjll4KA==","shasum":"ebad7fd58af2c07f0a70f7775b87023dc778a5ed","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.21.tgz","fileCount":11,"unpackedSize":22254,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCACg8n8QeW4DNi5r42ieUnl8bPylHRlnn5NA9A2h4xCgIhAIBcNkjA0/CHbrKq+ed7rII/yAT/B6AylNsL0hy5oqaw"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.21_1705669533159_0.588005225050142"},"_hasShrinkwrap":false},"0.0.22":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.22","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/pgsql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.22","gitHead":"973e6229cb52587ec8b0ade2ab57382652a3fe32","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/pgsql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/pgsql-migrate#readme","_nodeVersion":"21.6.0","_npmVersion":"10.3.0","dist":{"integrity":"sha512-XCPbTsrGS+/vSfv3luDxPbZ9aMtmB9NVSuKBefSr5nAo44HpKkkREDW0yUkrGs0WLAuAOchAN4MNbVghsZp6ZQ==","shasum":"2ae327442ada49abdc66b186f44c5778dae2a360","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.22.tgz","fileCount":11,"unpackedSize":22270,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQClb+fou+u8UyKc2nSw7+cDqBXzspMqYAxV7a5M8QsexgIgHsk5ca6um4P8mA+5+L8xiG3THZ24VAW2fohpBY7znYk="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.22_1705671009967_0.8315684832952892"},"_hasShrinkwrap":false},"0.0.23":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.23","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/pgsql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.23","gitHead":"a35a0712e6e5a73c2c34ad5553cadc8f96966b2b","bugs":{"url":"https://github.com/4nd3r5on/pgsql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/pgsql-migrate#readme","_nodeVersion":"21.6.2","_npmVersion":"10.4.0","dist":{"integrity":"sha512-XnnJiVCC62kyPFIzqOilroHgewpja2d6keafJD64q+WYk+6wDNv8m7EUNkfVvx8sG55o25gsGqs2yCKAT5wI2A==","shasum":"8a68792ef4eff32330f9a3b4797941bcdb850efa","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.23.tgz","fileCount":3,"unpackedSize":4430,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCrdXV3QRlOxnvkLXpI+zrmgFtjBPVXhUtvJFArn6mPPAIhAObUjXuSURzQCRDN63T3HYhQfOXEwWJewGUgeus3YBvb"}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.23_1708938023929_0.6850077758221345"},"_hasShrinkwrap":false},"0.0.24":{"name":"@4nd3rs0n/pgsql-migrate","version":"0.0.24","description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","main":"./dist/index.js","scripts":{"test":"test"},"keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/pgsql-migrate.git"},"license":"MIT","devDependencies":{"@types/node":"^20.11.5","@types/pg":"^8.10.9","typescript":"^5.3.3"},"dependencies":{"pg":"^8.11.3"},"_id":"@4nd3rs0n/pgsql-migrate@0.0.24","gitHead":"a35a0712e6e5a73c2c34ad5553cadc8f96966b2b","types":"./dist/index.d.ts","bugs":{"url":"https://github.com/4nd3r5on/pgsql-migrate/issues"},"homepage":"https://github.com/4nd3r5on/pgsql-migrate#readme","_nodeVersion":"21.6.2","_npmVersion":"10.4.0","dist":{"integrity":"sha512-6rk9HW5k1siHfokHrvy9/ZeooauQ+sQSzsEqYaRGELN8x9RYWES2CDcQB0/1PqBjwoczS1o3YWsQcfU/N6SwlQ==","shasum":"1d07fa902c3e36a12af6ecae8b758b6f9b997caa","tarball":"https://registry.npmjs.org/@4nd3rs0n/pgsql-migrate/-/pgsql-migrate-0.0.24.tgz","fileCount":9,"unpackedSize":17289,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGN0HthXJuOzeQcih+3GPGdPUyh83yjXUlTGR6oFG88BAiEA0n1+bUs2g2xwhGQuSarB5//dMFqxGwB4N81gx2BSOGY="}]},"_npmUser":{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"},"directories":{},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pgsql-migrate_0.0.24_1708938123759_0.26643642758380914"},"_hasShrinkwrap":false}},"time":{"created":"2024-01-18T10:49:40.806Z","0.0.1":"2024-01-18T10:49:41.051Z","modified":"2024-02-26T09:02:04.304Z","0.0.11":"2024-01-18T17:50:52.860Z","0.0.12":"2024-01-18T17:58:26.555Z","0.0.13":"2024-01-18T18:51:57.063Z","0.0.14":"2024-01-18T18:54:36.829Z","0.0.15":"2024-01-18T22:54:49.086Z","0.0.16":"2024-01-18T22:57:33.350Z","0.0.17":"2024-01-19T11:03:26.151Z","0.0.18":"2024-01-19T11:55:43.600Z","0.0.19":"2024-01-19T12:43:35.028Z","0.0.20":"2024-01-19T12:58:47.163Z","0.0.21":"2024-01-19T13:05:33.315Z","0.0.22":"2024-01-19T13:30:10.151Z","0.0.23":"2024-02-26T09:00:24.056Z","0.0.24":"2024-02-26T09:02:03.902Z"},"maintainers":[{"name":"4nd3rs0n","email":"mr.anderson20050@gmail.com"}],"description":"A simple JavaScript/TypeScript PostgreSQL migration library to apply migrations from SQL files","homepage":"https://github.com/4nd3r5on/pgsql-migrate#readme","keywords":["sql","postgres","postgresql","pgsql","migrations","minimalistic","typescript"],"repository":{"type":"git","url":"git+https://github.com/4nd3r5on/pgsql-migrate.git"},"author":{"name":"Dmitry Anderson","url":"4nd3rs0n/4nd3r5on"},"bugs":{"url":"https://github.com/4nd3r5on/pgsql-migrate/issues"},"license":"MIT","readme":"# PGSQL-Migrate\n\nMinimalistic JS/TS migrations library for PostgreSQL that just works.\n\nIt doesn't use any query builder, you don't need ORM to use migrations, it has minimum dependencies, you can write your migrations in a raw SQL, it tries to be performant for it's features and usabillity.\n\n## How to use\nInstall it from NPM\n```sh\nnpm i @4nd3rs0n/pgsql-migrate\n```\n\n### Migrations dir\nDirectroy that contains your `.sql` files with migrations.\n\nIt can contain sql files like `migrationID_labet.up|down.sql`\n```\n0_core.up.sql\n0_core.down.sql\n1_user.up.sql\n1_user.down.sql\n```\nYou may not want to use labels like `migrationID.up|down.sql`\n```\n0.up.sql\n0.down.sql\n1.up.sql\n1.down.sql\n```\nYou can skip some version IDs if you want\n```\n1.up.sql\n1.down.sql\n3.up.sql\n3.down.sql\n```\n\nAlso you can use timestamps instead of IDs like `timestamp_labet.up|down.sql`\n```\n1705406292767_core.up.sql\n1705406292767_core.down.sql\n1705406292839_user.up.sql\n1705406292839_user.down.sql\n```\n\n### Some code examples\n```ts\nimport pg from \"pg\"\nimport migrate from \"@4nd3rs0n/pgsql-migrate\"\nimport type { MigrationsConfig } from \"@4nd3rs0n/pgsql-migrate\"\n\ntype DoMigrateConfig = {\n  pool: pg.Pool\n  migrationsDir: string\n  versionLimit: BigInt | null\n}\n\nconst doMigrate = async (cfg: DoMigrateConfig) => {\n  let mLocal = await migrate.loadMigrationDir(cfg.migrationsDir)\n  let mCfg: MigrationsConfig = {\n    pool:   cfg.pool,\n    mLocal: mLocal\n  }\n\n  if (mLocal.versionsUP.length < 1) {\n    throw `No migrations were found in ${cfg.migrationsDir}`\n  }\n  let maxVersion = mLocal.versionsUP[mLocal.versionsUP.length - 1]\n\n  let migrateTo = cfg.versionLimit || maxVersion\n  // If you're not sure if migration table exists\n  // just call that function\n  await migrate.createMigrationTable(cfg.pool)\n  await migrate.rollbackToCleanVer(mCfg)\n  await migrate.migrateTo(mCfg, migrateTo)\n\n  await new Promise(r => setTimeout(r, 300));\n  let mApplied = await migrate.getAppliedMigrations(mCfg)\n  let currentVer: BigInt | null = null\n  if (mApplied.length > 0) {\n    currentVer = mApplied[mApplied.length - 1].version\n  }\n  let mLastClean = migrate.findLastCleanVer(mLocal.versionsUP, mApplied)\n\n  console.log(\n    `DB Info:\\n`+\n    `\\tDB Version Limit: ${cfg.versionLimit}\\n`+\n    `\\tCurrent DB Version: ${currentVer}/${maxVersion}\\n`+\n    `\\tDirty: ${mLastClean !== null ? true : false}\\n`\n  )\n}\n\nconst main = async () => {\n  /*\n    ... Your code\n  */\n  let pool: pg.Pool = new pg.Pool(cfg)\n  pg.types.setTypeParser(20, BigInt);\n  await doMigrate({\n  pool,\n    migrationsDir,\n    versionLimit: null,\n  })\n}\n\nmain()\n```\n\n### Tests\nNot ready yet, sorry\n","readmeFilename":"README.md"}