Christian Genco

sqlite cheat sheet

Open an sqlite database named "All Decks.apkg":

$ sqlite3 "All Decks.apkg"

List tables:

sqlite> .tables
cards   col     graves  notes   revlog