Implementing Store in MySQL

[tjni]

Hi team, I have been working on https://github.com/tjni/langgraph-checkpoint-mysql/ for my team since we use MySQL. My intent was to stay as close as possible to the Postgres code.

I noticed today that langgraph-checkpoint-postgres recently added implementations for Store using the ltree extension. This is not available in MySQL, so I wanted to get your thoughts on what would be a good way to emulate it. My main constraint is that I would like to keep it easy to keep functionally in-sync with the reference implementations.

1. Is there a SQLite reference implementation I can base this on in the worst case.
2. Are there additional query types being planned that will leverage more functionality of the ltree?

Thank you for all of your work!

[hinthornw]

Hi @tjni - excited to hear you're implementing! We actually yanked that initial version and are using regular text fields (with b-tree for prefix matching), primarily for the reasons you're pointing out: ltree isn't broadly available and the types of queries we are supporting for namespace listing aren't the primary usage path

[hinthornw]

In terms of roadmap: the important one is expanding the search API (right now it's just a list with filters)

[tjni]

Thank you! I'll keep an eye on it. Excited for everything upcoming!

[hinthornw]

Thanks for the questions & feedback - all is helpful; we want to avoid making this onerous to implement or too high-level