How to store RASA chatbot conversation history in Postgresql

[ChrisRahme (Chris Rahmé)]

Welcome to the forum

@yliu371

Assuming the solution is InMemoryTrackerStore, how to retrieve/find it from the “memory”?

The InMemoryTrackerStore is actually SQLite, so you can use it like any other SQLite database.

@yliu371

Does RASA store everything in a log?

Please see this post which shows what is saved in the tracker store: How can i SQLTrackerStore like that step by step . can someone help me? - #2 by ChrisRahme

@yliu371

Assuming I have a postgresql as a backend (with only one column created for storing everything)

What do you mean by storing everything in one column? The schema is already defined as shown in the link above.

@yliu371

Should I write any custom action that can store user inputs and bot responses?

Unless you want to store your data in a different way, which cannot be fixed by SQL Views, you don’t have to write custom actions. You only have to change the tracker store settings as also shown in the link above.