Anki with Alopex DB

What the service does

Anki is a flashcard app. Cards are grouped into decks, and after each review the user rates their recall so the next review comes when the card is about to be forgotten. The data is cards, decks and review history.

Where the data lives

• SQL tables: cards, decks and review history live in tables. Today’s cards come from a condition on the next review date.
• Columnar tables: review history goes in a columnar table to aggregate recall over time per deck.
• Vectors: embeddings of the front and back of each card find duplicate cards that ask the same thing.

Computing the next review date is app code.

Deployment

Alopex DB is embedded in the desktop and device apps. A deck lives in one file, so sharing a deck means sharing the file.

Why Alopex DB fits

A flashcard app gathers more cards and review history every year. Alopex DB handles the review schedule, history aggregation and duplicate detection inside one file.

Alopex DB runs the review schedule, history aggregation and duplicate detection in one file. Try it on a flashcard app; the quickstart shows how.

Links

• Alopex DB features: SQL, Vector search, Embedded and server
• Anki
• Build with Alopex DB