0.4.0 • Published 11 months ago
@socket.io/postgres-adapter v0.4.0
Socket.IO Postgres adapter
The @socket.io/postgres-adapter package allows broadcasting packets between multiple Socket.IO servers.
Table of contents
Supported features
| Feature | socket.io version | Support |
|---|---|---|
| Socket management | 4.0.0 | :white_check_mark: YES (since version 0.1.0) |
| Inter-server communication | 4.1.0 | :white_check_mark: YES (since version 0.1.0) |
| Broadcast with acknowledgements | 4.5.0 | :white_check_mark: YES (since version 0.3.0) |
| Connection state recovery | 4.6.0 | :x: NO |
Installation
npm install @socket.io/postgres-adapterUsage
import { Server } from "socket.io";
import { createAdapter } from "@socket.io/postgres-adapter";
import pg from "pg";
const io = new Server();
const pool = new pg.Pool({
user: "postgres",
host: "localhost",
database: "postgres",
password: "changeit",
port: 5432,
});
pool.query(`
CREATE TABLE IF NOT EXISTS socket_io_attachments (
id bigserial UNIQUE,
created_at timestamptz DEFAULT NOW(),
payload bytea
);
`);
pool.on("error", (err) => {
console.error("Postgres error", err);
});
io.adapter(createAdapter(pool));
io.listen(3000);