Saving chat history in PostgreSQL

[rajdeep-ghosh]

Saving chat history in Redis is very simple, but for my use case, I want to save all the chat history in Postgres. How do I do this?

Like in Vercel AI SDK we can call the onStart and onCompletion callbacks on the stream to save data into db

const response = openai.createChatCompletion({
  model: 'gpt-3.5-turbo',
  messages,
  stream: true
});

const stream = OpenAIStream(response, {
  onStart: () => {
    // save user message into db
  },
  onCompletion: () => {
    // save ai message into db
  }
});

As ragChat.chat() or aiUseChatAdapter does not provide any such methods, how can I achieve a similar experience?

Stack: - upstash/rag-chat & vercel ai sdk

[ronal2do]

There are many ways to save your data,

I've changed onChunk to create a temp and save those values there than send to a job, but I've moved away of it

The simplest one will be on the client side with onFinish method

  const { messages, append, setMessages } = useChat({
    api: `${baseUrl}api/chat`,
    onFinish: (message: Message) => {
      saveMessageInBackground(message.content);
    },
  });

[ronal2do]

@rajdeep-ghosh this PR aims to implement onFinish callback
#98
putting @CahidArda on loop