Story (Required)

Design and implement the data base layer in LCORE, both in-memory and persistent db, for storing chat history. So that lightspeed users have the ability to continue their conversations and as follow-up questions

persistent db now considering PostgreSQL

Background (Required)

currently LCore saves chat transcripts in a file on filesystem,  this is a temp solution, and need to be switch to more generic db.

also has an issue to track in lightspeed-core https://issues.redhat.com/browse/LCORE-298

take the simplest approach, which is just migrating the same data structure design and APIs for both in-memory and postgres

should provide the same functionality as in road-core for feature parity

unit tests, integration tests and documentations should also be considered as part of this issue

Out of scope

<Defines what is not included in this story>

Approach (Required)

<Description of the general technical path on how to achieve the goal of the story. Include details like json schema, class definitions>

Dependencies

<Describes what this story depends on. Dependent Stories and EPICs should be linked to the story.>

Acceptance Criteria (Required)

<Describe edge cases to consider when implementing the story and defining tests>

<Provides a required and minimum list of acceptance tests for this story. More is expected as the engineer implements this story>

documentation updates (design docs, release notes etc)
demo needed
SOP required
education module update (Filled by RHDHPAI team only)
R&D label required (Filled by RHDHPAI team only)

Done Checklist

Code is completed, reviewed, documented and checked in
Unit and integration test automation have been delivered and running cleanly in continuous integration/staging/canary environment
Continuous Delivery pipeline(s) is able to proceed with new code included
Customer facing documentation, API docs, design docs etc. are produced/updated, reviewed and published
Acceptance criteria are met
If the Grafana dashboard is updated, ensure the corresponding SOP is updated as well