/
25.12.2024 at 09:54 am
Cuttings

Schema for Language-Learning Drillers

SQL table definition for sentences.
Code
                        CREATE TABLE "Material"
(
  id                     INTEGER,
  expression             TEXT,
  expression_meaning     TEXT,
  expression_reading     TEXT,
  expression_source      TEXT
  focus_phrase           TEXT,
  focus_phrase_meaning   TEXT,
  notes                  TEXT
)
                    

I love spaced-repetition systems. I've been an extremely early Anki user, all the way back to 2006.

Yet nothing beats rote language drills to build automaticity.

So I've previously written language drilling apps to help me learn languages.

I've experimented with many possible schemas; yet I've come to prefer storing simple sentence-level units in SQL databases.

This to me is the simplest single-table definition schema to hold learning materials across different languages. (It's great because it also works as a reference for Anki deck fields.)

Explaining the Schema

  1. expression

    • Represents a grammatical phrase, expression or a sentence fragment.

    • Written in Japanese/other languages.

  2. expression_meaning

    Closest translation. Not the 'explanation' (which goes into notes).

  3. expression_reading

    Phonetic reading. (For Japanese, in hiragana/katakana.)

  4. expression_source

    Reference - e.g. specific texts/documents/websites.

  5. focus_phrase

    • A specific word, or target grammar point, within the expression.

    • If present, it is the focal point of the expression.

  6. focus_phrase_meaning

    • Meaning of the highlighted phrase/grammar point.

    • Different from expression_meaning.

  7. notes

    Supplementary details; usage tips, exceptions, or cultural nuances.

Filed under:
#
#
#
Words: 188 words approx.
Time to read: 0.75 mins (at 250 wpm)
Keywords:
, , , , , , , , ,

Other suggested posts

  1. 19.12.2024 at 09:00 pm / You Yearn, Yet Engage Not
  2. 15.12.2024 at 09:46 am / Artful Rule-Bending
  3. 18.10.2022 at 09:36 am / The Airplane Test of Fluency
  4. 27.08.2020 at 09:33 pm / Write Like You Play Tetris
  5. 16.09.2019 at 10:32 am / Legal Practice & Taking From Software Best Practices
  6. 23.08.2018 at 09:53 am / Nostalgic Non-Memories
  7. 19.08.2018 at 02:13 pm / Saunter Not
  8. 21.12.2015 at 12:00 am / Emails and English Weather
  9. 28.06.2015 at 12:00 am / No Social Transformation Without Representation
  10. 02.04.2012 at 12:00 am / Abstract Wall Painting
© Wan Zafran. See disclaimer.