Anki 2 DB schema

414 views
Skip to first unread message

enrico200165

unread,
Sep 4, 2014, 8:06:51 AM9/4/14
to anki-a...@googlegroups.com
Is there a description of the DB of Anki 2 somewhere?
How does it store data in the DB fields? Sometimes it seems to store serialized data, which format is it? (know conceptually what a serialization is but never really worked with any, including json)

I am no longer a programmer and do not have time/skill for anything serious, but would like  to update some utilities I built to modify facts in Anki1.
I can only work in java.
I know that in python things would be simpler, know that python is great, simple fun and high-productivity but just do not have time to learn it.

Thanks for any info.

Nicolas Raoul

unread,
Sep 4, 2014, 8:18:42 AM9/4/14
to anki-android
Hi Enrico,

I started this documentation a few months ago:
http://decks.wikia.com/wiki/Anki_APKG_format_documentation

Right now it is APKG-oriented, but it also contains some collection info.
Feel free to add the missing information, it is a wiki! :-)

Thanks for getting involved!
Nicolas Raoul


--
You received this message because you are subscribed to the Google Groups "AnkiDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to anki-android...@googlegroups.com.
To post to this group, send email to anki-a...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/anki-android/44566792-58c0-4133-bcfe-3bf65ba606ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Tim

unread,
Sep 1, 2015, 5:08:54 AM9/1/15
to AnkiDroid
FYI, I added a new wiki page with more details on the meaning of the fields in the database:

around half of it is copied from existing material some people added to a gist, the rest it I have filled in from my own knowledge, looking at the source code, and discussions with Damien


On Thursday, September 4, 2014 at 9:18:42 PM UTC+9, Nicolas Raoul wrote:
Hi Enrico,

I started this documentation a few months ago:
http://decks.wikia.com/wiki/Anki_APKG_format_documentation

Right now it is APKG-oriented, but it also contains some collection info.
Feel free to add the missing information, it is a wiki! :-)

Thanks for getting involved!
Nicolas Raoul
On Thu, Sep 4, 2014 at 9:06 PM, enrico200165 <enrico...@gmail.com> wrote:
Is there a description of the DB of Anki 2 somewhere?
How does it store data in the DB fields? Sometimes it seems to store serialized data, which format is it? (know conceptually what a serialization is but never really worked with any, including json)

I am no longer a programmer and do not have time/skill for anything serious, but would like  to update some utilities I built to modify facts in Anki1.
I can only work in java.
I know that in python things would be simpler, know that python is great, simple fun and high-productivity but just do not have time to learn it.

Thanks for any info.

--
You received this message because you are subscribed to the Google Groups "AnkiDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to anki-android+unsubscribe@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages