[ilteris]

Where does your SQLite db sit? I have been thinking about creating a local database to save and feed into LLM but i have no experience with it

[yorwba]

The SQLite database file is called "collection.anki2". Its path varies depending on the operating system: https://docs.ankiweb.net/files.html?highlight=collection.ank...

[runarberg]

I’m not using LLMs but I scrape open dictionary data to generate (massive) cards for learning kanji. I publish these in a specialized kanji learning app (rather than anki proper). My db just lives temporarily on my local machine, before I publish. Maybe sometime I will streamline the publishing process and create a github action for it.

btw. I didn’t use LLMs to write the app, it was still pretty straight forward.

https://github.com/runarberg/shodoku/tree/main/scripts

[rahimnathwani]

If you export a deck as an .apkg file, you can unzip it to get the SQLite files:

https://www.encona.com/posts/custom-statistics-for-anki-flas...