Apkg (file format)
| Filename extension | .Apkg |
|---|---|
| Developed by | Anki_(software) |
| Container for | Flashcard information |
Apkg is Anki (software) single deck of flashcard package. Apkg is used to back up and restore and distribute flashcards decks.[1] [2]
Apkg files are used in different learning studies. [3] [4] [5] [6] [7]
Data file structure
Apkg is a zipped set of Sqlite databases and media files and consists of the following files:
- collection.sqlite - contains flashcards for Anki prior version 2.0
- collection.anki2 - contains flashcards for version 2.0
- collection.anki21 - contains flashcards for version 2.1
Depending on the version of Anki, only one database is primary and contains data; all other databases will have this text: "This file requires a newer version of Anki"
Main tables of the primary database are:
- Collections - Apkg file could have multiple decks in it; this table describes flashcard corrections in the file.
- Cards - contains models stores statistical information during the learning process
- Notes contains front and back sides of the cards
- revLog - contains information about cards revisions
There is no models table in the database, but every model is described by a JSON structure. Both sides of Flashcards are stored in the Notes table. Here is the logical structure of how data is stored inside an apkg file. Fields of the notes table:
| Field name | Field type | Description |
|---|---|---|
| id | Number | Contains unique numeric identifier of the note |
| guid | String | Contains unique alphanumeric identifier of the note for synchronization |
| mid | Numeric | Contains model id |
| mod | Numeric | Contains timestamp for tracking modifications |
| usn | Numeric | Contains sequence number for synchronization |
| tags | String | Contains tags associated to the card |
| flds | String | Contains fields needed to generate the card |
| sfld | Numeric | Contains sorting field |
| csum | Numeric | Contains checksum |
| flags | Numeric | Not used |
| data | String | Not used |
See also
References
- ↑ "How to save and back up your Anki decks!". Fluent Forever.
- ↑ "How to Open APKG Files on Mobile or Desktop". wikiHow.
- ↑ Al‐Rawi, Wisam; Easterling, Lauren; Edwards, Paul C. (April 24, 2015). "Development of a Mobile Device Optimized Cross Platform-Compatible Oral Pathology and Radiology Spaced Repetition System for Dental Education". Journal of Dental Education. 79 (4): 439–447. doi:10.1002/j.0022-0337.2015.79.4.tb05902.x. PMID 25838016 – via Wiley Online Library.
- ↑ "Veremis, B., V. Ramaswamy, and T. Danciu. "The Use of Anki Software to Facilitate Oral and Maxillofacial Pathology Learning."" (PDF).
- ↑ "Lemyre, André. "Guide de création de cartes électroniques d'étude de langues signées avec Anki et SignWriter Studio TM en 30 minutes." (2015)" (PDF).
- ↑ Marín-Paz, Antonio-Jesús. "Mazos de tarjetas de memoria realizadas en Anki para la asignatura" Farmacología"(Grado en Enfermería)." (2020).
- ↑ "Marín-Paz, Antonio-Jesús. "Mazos de tarjetas de memoria realizadas en Anki para la asignatura" Farmacología"(Grado en Enfermería)." (2020)".
External links
changed to contain only independent references
I politely disagree, new information had been added.
== I do not think merging the article into Anki software is a good idea. Apkg is just one format supported by Anki and there is a huge amount of information on how it was built. Including storing NoSQL/JSON data into a relational database, which makes it "hybrid" and unique, I haven't seen it in other apps. I hope to describe JSON structures next. ==
This article "Apkg (file format)" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Apkg (file format). Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
