feat(Postgres Chat Memory Node): Implement Postgres Chat Memory node

[OlegIvaniv]

Summary

• Add Postgres Chat Memory
• Improve wrapping of BaseChatMessageHistory & BaseChatMemory in logWrapper to make sure sub-node input/ouput is correctly populated

Docs: n8n-io/n8n-docs#2241

How to test

1. Spin-up a Postgres instance, for example with docker-compose:

version: '3.9'

services:
  postgres:
    image: postgres:14-alpine
    ports:
      - 5432:5432
    volumes:
      - ./db:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=password
      - POSTGRES_USER=chat
      - POSTGRES_DB=chat

Related Linear tickets, Github issues, and Community forum posts

Review / Merge checklist

• PR title and summary are descriptive. (conventions)
• Docs updated or follow-up ticket created.
• Tests included.
• PR Labeled with release/backport (if the PR is an urgent fix that needs to be backported)

[burivuhster]

Looks good! Minor comments, non-blocking.

[cypress]

4 flaky tests on run #5951 ↗︎

0

400

0

0

4

Details:

🌳 🖥️ browsers:node18.12.0-chrome107 🤖 OlegIvaniv 🗃️ e2e/*
Project: n8n	Commit: 1e61222ece
Status: Passed	Duration: 05:22 💡
Started: Jul 16, 2024 3:40 PM	Ended: Jul 16, 2024 3:46 PM

  5-ndv.cy.ts • 2 flaky tests

View Output Video

Test		Artifacts
NDV > should not retrieve remote options when required params throw errors		Screenshots Video
NDV > Stop listening for trigger event from NDV		Screenshots Video

  10-undo-redo.cy.ts • 1 flaky test

View Output Video

Test		Artifacts
Undo/Redo > should undo/redo adding connected nodes		Test Replay Screenshots Video

  24-ndv-paired-item.cy.ts • 1 flaky test

View Output Video

Test		Artifacts
NDV > resolves expression with default item when input node is not parent, while still pairing items		Test Replay Screenshots Video

Review all test suite changes for PR #10071 ↗︎

[github-actions]

✅ All Cypress E2E specs passed

[github-actions]

✅ All Cypress E2E specs passed

[janober]

Got released with n8n@1.51.0

[mprytoluk]

Got released with n8n@1.51.0

I'm afraid I can't find the Postgres Chat Memory node in n8n@1.51.0.

[Joffcom]

@mprytoluk I have just taken a look and it is there for me, How are you trying to find it?

[mprytoluk]

@mprytoluk I have just taken a look and it is there for me, How are you trying to find it?

@Joffcom I believe there was a mistake on my side, because the node is indeed there in n8n@1.51.0. Sorry for the confusion.

[jeanpaul]

@mprytoluk This type of node will only appear in search results if there's a node that can use it, such as the AI Agent node. You can find it manually by going to "Advanced AI > Other AI Nodes > Memory".