How do you design memory systems for long-running AI agents?

In my gradio space I have two systems: the standard dataset (with basic data to be used on interactions) and a parquet file where reflections on basic datas and user chats (and reflections on them) are stored. This improves continuously during idle time.