In October 2019 I made a bit that emails me every day and stores the replies in an SQLite database.

I narrate each day the following morning, and aslo store random pieces of information (story of a debugging session, opinions on books I read or movies I watch, etc.)

I have missed almost zero days since the beginning. One of the most useful feature of this system is to store things people that I meet rarely, tell me. When I meet them again, years later, I can pick up the conversation where it was. Other than that, I rarely go back to read old entries.

I sometimes wonder what use AI could make of this.

Wow, very similar to what I have been doing but sounds like you had way more consistency. My bot does not remind me to write, it's a neat idea.

I was wondering about adding a trivial Langchain+LLaMa thing to it to chat to my old memories, would be cool to explore this indeed

Do you happen to have the source code publicly available?

Yes ofc: https://github.com/martinthenext/daytobase

It is extremely old but probably trivial to upgrade to recent Python. There is also a serverless version [1] and a recently attempted Rust version. I will most likely spend a few hours some weekend writing a Node version soon -- please let me know if you beat me to it :)

[1]: https://github.com/2mol/daytobase