postgres-baileys

A robust and reliable Node.js package designed to seamlessly persist your @whiskeysockets/baileys WhatsApp session data within a PostgreSQL database.

Key Benefits

• Persistent Sessions: Maintain uninterrupted WhatsApp bot connectivity, even across server restarts or crashes
• Scalability: PostgreSQL's robust architecture supports handling large volumes of session data as your bot usage grows.
• TypeScript Support: Leverages TypeScript for enhanced type safety and improved code maintainability.

Installation

Install the package using npm or yarn:

npm install postgres-baileys

Getting Started

import { makeWASocket } from "@whiskeysockets/baileys";
import { usePostgreSQLAuthState } from "postgres-baileys"; 

const postgreSQLConfig = {
  host: 'your-postgresql-host',
  port: 5432, 
  user: 'your-postgresql-user',
  password: 'your-postgresql-password',
  database: 'your-postgresql-database',
};

async function main() {
  try {
    const { state, saveCreds } = await usePostgreSQLAuthState(postgreSQLConfig, "your-unique-session-id");

    const sock = makeWASocket({
      printQRInTerminal: true,
      auth: state
    });

    sock.ev.on("creds.update", saveCreds); 

    console.log("WebSocket connected");
  } catch (error) {
    console.error("Error:", error);
  }
}

main();

OR

import { Pool } from 'pg';
import { usePostgreSQLAuthState } from './path-to-your-module'; // Adjust the path accordingly

// Assuming you have an already connected Pool instance
const pool = new Pool({
    host: 'your-host',
    port: 5432, // or your specific port
    user: 'your-username',
    password: 'your-password',
    database: 'your-database',
    ssl: true, // or your specific SSL configuration
});

// Define a session ID for this connection
const sessionId = 'unique-session-id';

async function main() {
    // Use the PostgreSQL authentication state
    const { state, saveCreds, deleteSession } = await usePostgreSQLAuthState(pool, sessionId);

    // Now, you can interact with the state, save credentials, or delete the session
    console.log('Initial Authentication State:', state);

    // Example: Save the current credentials
    await saveCreds();

    // Example: Delete the session when needed
    // await deleteSession();
}

main().catch(console.error);

Core Concepts

1. PostgreSQL Configuration: Provide accurate connection details for your PostgreSQL database.
2. Session ID: A unique identifier for your WhatsApp session. Use a consistent ID to resume the same session across restarts.
3. usePostgreSQLAuthState: Fetches or initializes session data from the database, returning the current state and a saveCreds function.
4. makeWASocket: Create your Baileys connection, passing in the retrieved state.
5. creds.update Event: Listen for this event to automatically persist updated credentials to the database using the saveCreds function.

Advanced Usage

import { initAuthCreds } from "postgres-baileys";

// ...

// Manual credential initialization (optional)
const authCreds = initAuthCreds(); 

// ... (Use authCreds in your Baileys configuration if needed)

API Reference

• usePostgreSQLAuthState(config, sessionId)

  • config: PostgreSQL connection configuration object
  • sessionId: Unique string identifier for your session
  • Returns:
    • state: The current authentication state or a newly initialized one.
    • saveCreds: A function to save updated credentials to the database

• initAuthCreds()

  • Returns: A freshly generated set of Baileys authentication credentials.

Important Considerations

• Database Setup: Ensure your PostgreSQL database is set up and accessible.
• Error Handling: Implement robust error handling, especially for database connection issues.