{"_id":"sharedb-postgres","_rev":"13-20f5844e8fc2d6a7011c8afbcc6d824d","name":"sharedb-postgres","dist-tags":{"latest":"6.0.0"},"versions":{"1.0.0":{"name":"sharedb-postgres","version":"1.0.0","author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@1.0.0","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"}],"dist":{"shasum":"3a45412dba85003bf234e477f01d81d56f278e2c","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-1.0.0.tgz","integrity":"sha512-BBuFf7B/WMhxAjenSyg5Ed98vQmPcx2dudi3N0zsGBLSFIRVzbzT6ljyIfyZ+ZVfKVFcs+oTfZdMgvVOimJGyQ==","signatures":[{"sig":"MEUCIDs9UpvlnFoZNY4ZqH+sABoMIddX/eULN9g7bssI1y7jAiEAiJ/tBXzMkLlvMQMnEK0C+uQ07XatcfZVFQlKUV3hNg0=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"3a45412dba85003bf234e477f01d81d56f278e2c","gitHead":"346fe8c47a71957a7865180bc635f0fab603f794","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"nornagon","email":"nornagon@nornagon.net"},"_npmVersion":"3.5.3","description":"PostgreSQL adapter for ShareDB","directories":{},"_nodeVersion":"5.4.1","dependencies":{"pg":"^4.5.1","sharedb":"^0.11.34"},"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres-1.0.0.tgz_1458866340134_0.49439686513505876","host":"packages-13-west.internal.npmjs.com"}},"1.0.1":{"name":"sharedb-postgres","version":"1.0.1","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@1.0.1","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"}],"homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"f919c8785ce37e4c7cd896ea7f8a1be761084fd6","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-1.0.1.tgz","integrity":"sha512-9H6BavmodFzqpHLUtCdoHV3dCsqtODtT/VH2PTY6HlNTBqprkBVUAjVIJpVqrBCY4LYw7e3N1jorJJL5xj3iyQ==","signatures":[{"sig":"MEUCIQDb8nDjzjI/R27a17etu6DcRCqiG/YlKnsEhTYjP/6vpwIgLaPokiOPXdFltEupvqKwmqSZLwS6Bpafu/GUHDpaoI4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"f919c8785ce37e4c7cd896ea7f8a1be761084fd6","gitHead":"60120a74628d9ba5d317183fdd83a1bb088cd608","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"nornagon","email":"nornagon@nornagon.net"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"3.5.3","description":"PostgreSQL adapter for ShareDB","directories":{},"_nodeVersion":"5.4.1","dependencies":{"pg":"^4.5.1","sharedb":"^0.11.34"},"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres-1.0.1.tgz_1458866967542_0.807243624003604","host":"packages-13-west.internal.npmjs.com"}},"2.0.0":{"name":"sharedb-postgres","version":"2.0.0","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@2.0.0","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"}],"homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"4e641a9a64f73b95be6ca08a812b914bd657313c","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-2.0.0.tgz","integrity":"sha512-j6FxruNdMOSt6kBR4K44a/qsnSyKmvrhAsexzWFLImmv7fv5df/WYToDxQJRJ0SuHsTHzGh8nk9MhbH+H/XBeQ==","signatures":[{"sig":"MEUCICy9jR4Ctbt1ABoZI+wDXkiBBSXPI9yHmaNX8dFF62qbAiEAla7mYOIFzp7/6Q8nGm46ysZSsR2R+iiO9EYoivZtu2A=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","gitHead":"f61be5609c5200d2491a753258f0a73151849d57","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"nornagon","email":"nornagon@nornagon.net"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"5.4.2","description":"PostgreSQL adapter for ShareDB","directories":{},"_nodeVersion":"8.7.0","dependencies":{"pg":"^4.5.1","sharedb":"^1.0.0-beta.7"},"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres-2.0.0.tgz_1511832471704_0.010464861989021301","host":"s3://npm-registry-packages"}},"3.0.0":{"name":"sharedb-postgres","version":"3.0.0","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@3.0.0","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"}],"homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"dbd3da1fc94d1e0ef1d2967b44d13dcaa72ce619","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-3.0.0.tgz","fileCount":6,"integrity":"sha512-PtfSepvt7maFNrWSe3e8rS5UL1ZtfGtN+DdSHSRXfHRk4mS2eWJAmbqdWGr2CamimqDyRb9ScCFi9Dh24YTUxw==","signatures":[{"sig":"MEQCIA/zmH85aSkqdya/YpyHzZVcSXWlYEWAeY3uMWo76quuAiAVKatYn1bP5qa1NW6m8W85Vbg9GE/gEzaT5str9THSlg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":10010,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeVZSECRA9TVsSAnZWagAAvXcP/Aszk02LuQSbTNwjwp1k\nlNzL+iYCd/RGhHJxQHUnVIiyAYQ79Feq3MahCakRXLMih1+Evn02z9iJ/8FI\nVBYuHQSFXKXLHQPMvzxXBUnJgb4Si4krF/D9Zt6vXeNfd06LUYoyAGOUuzZ0\nHjP8HR0m75KK/oF9Dacpjgn1cX+ZvW5nkHRndo2kiaRq4WpFlbUwLnTt5mgX\nTYBEIzP64jo3P56T9twSF12OoSch8FKyUkludLCh9Dbi/CllOJXCrjnLUVFz\nbAwtQY9Lv3qD20jgLPBNQSgzAQo4yzlTM4AnN59d/RrNtz9JSUINBvWGWfrH\n/BFFPOi4q5zpJ8bG4PTCIfn4+ylfR9p+52DX4P/2JHWlQwIn9h24CsoyUg7r\nEPwNHzo1VmPLirfbcLnzesSgMvD8qa5N7ajIRxQOUCjtr+Ke/+4JXdI+9WTg\niEcemXM3VOOcYupZbM3RlTAE6eLatpfDo2S0M4JuWu7yma/HOGOLmzMQARch\nWAdy+L/gQE3ANDp1UpZMNlHeHUaBVy/VTS1wbv/Pb4J9q1SA12uuLo/52kSc\nzLdZRyFZmjtKrwR/TY/lxqi50OcrVVxramwa7rF5z1LvF8eTud85ttzKCneV\nMy8d3YMqsvqMFCAwelsmVIn+w7J9EHGkuerkadeEl35i/aLE+e3KQURgCSm6\n41Sg\r\n=0qyJ\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"65faa530d462c5ba06779abad1ed7459c0f9764d","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"nornagon","email":"nornagon@nornagon.net"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"6.11.3","description":"PostgreSQL adapter for ShareDB","directories":{},"_nodeVersion":"12.12.0","dependencies":{"pg":"^7.4.1","sharedb":"^1.0.0-beta.7"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres_3.0.0_1582666884275_0.6830348555944543","host":"s3://npm-registry-packages"}},"4.1.0":{"name":"sharedb-postgres","version":"4.1.0","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@4.1.0","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"},{"name":"alecgibson","email":"aleckgibson@googlemail.com"}],"homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"a58b2ff9662097bfde4506b3ee97fa00d530e33e","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-4.1.0.tgz","fileCount":7,"integrity":"sha512-rGXITaS2HJ7DVXyS68UsKhAb48vkvPnAgcOVyf1qgFDXXp0bgedPxzTVeqAajlbS6FeAIjHI71tq7a9A0JF35A==","signatures":[{"sig":"MEYCIQD03Xrc63CIN+l559ZQYcXKjkpkxIQ0x0SsDYJn5yd76wIhANe8Dkq/2BG21LjMsWv+dPv/ragie4kANJWzjDB8/3kT","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":11664},"main":"index.js","gitHead":"23a9d62a982cc4a02f46227ccfa236526374b895","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"_npmUser":{"name":"alecgibson","email":"aleckgibson@googlemail.com"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"10.1.0","description":"PostgreSQL adapter for ShareDB. forked from share/sharedb-postgres","directories":{},"_nodeVersion":"20.9.0","dependencies":{"pg":"^8.5.1","pg-pool":"^3.2.1","sharedb":"^1.6.0 || ^2.0.0 || ^3.0.0 || ^4.0.0 || ^5.0.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres_4.1.0_1718183985825_0.08180963908869998","host":"s3://npm-registry-packages"}},"5.0.0":{"name":"sharedb-postgres","version":"5.0.0","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@5.0.0","homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"debd36604c177fece0d6650a659c40d2a8abd6cc","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-5.0.0.tgz","fileCount":11,"integrity":"sha512-WwVeitwk0dnHU4ueDkVnbpn5Glgb5YLGcaOg/+Ym/xPVPoGwTXzBkWZ7lcFpKTuNsrMbBh8xt0tqvOIXv78f/A==","signatures":[{"sig":"MEQCIHTJL9mfFcYAmS21FUkbmly+YXzguHEjDj5tGg0UDVrhAiBEn6opaj7cWATYXXopHfGpA01nwThwjGLjkOelpVkBnA==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14210},"main":"index.js","gitHead":"58ee94586a4bc9d4ea628cf18db4e5e36fa018ea","scripts":{"test":"mocha"},"_npmUser":{"name":"alecgibson","email":"aleckgibson@googlemail.com"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"10.1.0","description":"PostgreSQL adapter for ShareDB. forked from share/sharedb-postgres","directories":{},"_nodeVersion":"20.9.0","dependencies":{"pg":"^8.12.0","sharedb":"^1.6.0 || ^2.0.0 || ^3.0.0 || ^4.0.0 || ^5.0.0"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.4.1","mocha":"^10.4.0","sinon":"^18.0.0","ot-json1":"^1.0.2","rich-text":"^4.1.0"},"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres_5.0.0_1719332243800_0.8279661269174716","host":"s3://npm-registry-packages"}},"5.0.1":{"name":"sharedb-postgres","version":"5.0.1","keywords":["sharedb","sharejs","share","postgres"],"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","_id":"sharedb-postgres@5.0.1","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"},{"name":"alecgibson","email":"aleckgibson@googlemail.com"}],"homepage":"https://github.com/share/sharedb-postgres#readme","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"dist":{"shasum":"96d6419c4becbd45bad5aba27da57eb51cdff94b","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-5.0.1.tgz","fileCount":11,"integrity":"sha512-q5dTl+VbzsBDsvAtSa/XcLFls4j6o8sm5ritHLvlhPwvZZvVDhOD0RIgF8vc+f7JPR1h3JcUG/OTe0PpQmAB7g==","signatures":[{"sig":"MEUCIHGXOELS3tvv/i74I0Jr0iTTNIqNm6V1XgkByxgUfRdtAiEAkJnjb0ON6l97BdSUba80Ji2iDHmMvFMbdUpWWh6vEjk=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":14210},"main":"index.js","gitHead":"f98498aec295ca2cc847d0752541311f0a4dcc2f","scripts":{"test":"mocha"},"_npmUser":{"name":"alecgibson","email":"aleckgibson@googlemail.com"},"repository":{"url":"git+https://github.com/share/sharedb-postgres.git","type":"git"},"_npmVersion":"10.1.0","description":"PostgreSQL adapter for ShareDB. forked from share/sharedb-postgres","directories":{},"_nodeVersion":"20.9.0","dependencies":{"pg":"^8.12.0","sharedb":"^1.6.0 || ^2.0.0 || ^3.0.0 || ^4.0.0 || ^5.0.0"},"_hasShrinkwrap":false,"devDependencies":{"chai":"^4.4.1","mocha":"^10.4.0","sinon":"^18.0.0","ot-json1":"^1.0.2","rich-text":"^4.1.0"},"_npmOperationalInternal":{"tmp":"tmp/sharedb-postgres_5.0.1_1729244395756_0.4548044403770437","host":"s3://npm-registry-packages"}},"6.0.0":{"name":"sharedb-postgres","version":"6.0.0","description":"PostgreSQL adapter for ShareDB. forked from share/sharedb-postgres","main":"index.js","scripts":{"test":"mocha"},"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","keywords":["sharedb","sharejs","share","postgres"],"repository":{"type":"git","url":"git+https://github.com/share/sharedb-postgres.git"},"dependencies":{"pg":"^8.12.0","sharedb":"^1.6.0 || ^2.0.0 || ^3.0.0 || ^4.0.0 || ^5.0.0 || ^6.0.0"},"devDependencies":{"chai":"^4.4.1","mocha":"^10.4.0","ot-json1":"^1.0.2","rich-text":"^4.1.0","sinon":"^18.0.0"},"gitHead":"507782aa6faa0308ded03bc03b35ff19b47ea734","_id":"sharedb-postgres@6.0.0","bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"homepage":"https://github.com/share/sharedb-postgres#readme","_nodeVersion":"24.14.1","_npmVersion":"11.17.0","dist":{"integrity":"sha512-au4a9vyY+VPcJZrSErduv2/gN9UBbQk1SkM5JnJUPwLzpjR6UKu6IgWPiswB4oG2+PpP4MjeKlheX2Ns8vKkRA==","shasum":"a2c3ad98871ceb7a40c85f532a48c1a4965244e0","tarball":"https://registry.npmjs.org/sharedb-postgres/-/sharedb-postgres-6.0.0.tgz","fileCount":11,"unpackedSize":14233,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDfjHzCHd72NFYfTqhNT/k35VvcKj3SZmVLKPa8cMlE5gIgGIsZbOu0La/GfaoeC/+HGA4POBAoI5kt8b79I/hgaRA="}]},"_npmUser":{"name":"alecgibson","email":"aleckgibson@googlemail.com"},"directories":{},"maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"},{"name":"alecgibson","email":"aleckgibson@googlemail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sharedb-postgres_6.0.0_1782205562971_0.9804837902831027"},"_hasShrinkwrap":false}},"time":{"created":"2016-03-25T00:39:00.543Z","modified":"2026-06-23T09:06:03.238Z","1.0.0":"2016-03-25T00:39:00.543Z","1.0.1":"2016-03-25T00:49:27.966Z","2.0.0":"2017-11-28T01:27:51.836Z","3.0.0":"2020-02-25T21:41:24.410Z","4.1.0":"2024-06-12T09:19:45.964Z","5.0.0":"2024-06-25T16:17:23.992Z","5.0.1":"2024-10-18T09:39:55.953Z","6.0.0":"2026-06-23T09:06:03.095Z"},"bugs":{"url":"https://github.com/share/sharedb-postgres/issues"},"author":{"name":"Jeremy Apthorp","email":"nornagon@nornagon.net"},"license":"MIT","homepage":"https://github.com/share/sharedb-postgres#readme","keywords":["sharedb","sharejs","share","postgres"],"repository":{"type":"git","url":"git+https://github.com/share/sharedb-postgres.git"},"description":"PostgreSQL adapter for ShareDB. forked from share/sharedb-postgres","maintainers":[{"name":"nornagon","email":"nornagon@nornagon.net"},{"name":"alecgibson","email":"aleckgibson@googlemail.com"}],"readme":"# sharedb-postgres\n\nPostgreSQL database adapter for [sharedb](https://github.com/share/sharedb). This driver can be used both as a snapshot store and oplog.\n\nDoesn't support queries (yet?).\n\nModerately experimental. (This drives [Synaptograph](https://www.synaptograph.com)'s backend, and [@nornagon](https://github.com/nornagon) hasn't noticed any issues so far.)\n\n\n\n## Installation\n\n```cmd\nnpm i sharedb-postgres\n```\n\n\n## Requirements\n\nDue to the fix to resolve [high concurency issues](https://github.com/share/sharedb-postgres/issues/1) Postgres 9.5+ is now required.\n\n## Migrating older versions\n\nOlder versions of this adaptor used the data type json. You will need to alter the data type prior to using if you are upgrading.\n\n```PLpgSQL\nALTER TABLE ops\n  ALTER COLUMN operation\n  SET DATA TYPE jsonb\n  USING operation::jsonb;\n\nALTER TABLE snapshots\n  ALTER COLUMN data\n  SET DATA TYPE jsonb\n  USING data::jsonb;\n```\n\n## Usage\n\n`sharedb-postgres-jsonb` wraps native [node-postgres](https://github.com/brianc/node-postgres), and it supports the same configuration options.\n\nTo instantiate a sharedb-postgres wrapper, invoke the module and pass in your\nPostgreSQL configuration as an argument or use environmental arguments.\n\nFor example using environmental arugments:\n\n```js\nvar db = require('sharedb-postgres')();\nvar backend = require('sharedb')({db: db})\n```\n\nThen executing via the command line\n\n```\nPGUSER=dbuser  PGPASSWORD=secretpassword PGHOST=database.server.com PGDATABASE=mydb PGPORT=5433 npm start\n```\n\nExample using an object\n\n```js\nvar db = require('sharedb-postgres')({host: 'localhost', database: 'mydb'});\nvar backend = require('sharedb')({db: db})\n```\n\n## Error codes\n\nPostgreSQL errors are passed back directly.\n\n## Changelog\n\nNote that version 3.0.0 introduces breaking changes in how you specify\nconnection parameters. See the [changelog](CHANGELOG.md) for more info.\n","readmeFilename":"README.md"}