alex_hk90
状元
Hi all,
I'm not sure if this is the right place for this as it should apply to all versions, but I use the Android version so I put it here rather than 'Future Products'.
This is mainly for the developers, but perhaps users who have used the user dictionary feature will also know.
So my questions are based on the specification for user dictionaries in Pleco:
1. Since the import speed is painfully slow, does anyone know what the specification is for the SQLite file ([userdict].pqb) itself?
Most of the database tables and columns are pretty obvious, but "sortkey" in the "entries" table and the related "posdex_hz" (Hanzi) and "posdex_py" (Pinyin) sorting / lookup tables weren't immediately obvious to me. I could probably work it out but thought I'd ask first if anyone already has the specification. With this it would be easy to import large databases directly into the SQLite (pqb) file, instead of going through the slow import method on the phone itself.
2. What are the codes for formatting the definitions?
I found this post: http://www.plecoforums.com/viewtopic.php?f=13&t=1406&p=10399#p10399, is the list there complete?
3. Full text search - could this be supported in the Android version?
I found this post: http://www.plecoforums.com/viewtopic.php?f=17&t=2686, but it relates to iOS, so I don't know if it also applies to the Android version (I have no idea what version of SQLite it uses or what features it may have).
Alternatively, would it be possible to create 'proper' Pleco dictionaries which due allow full text search?
I'm guessing due to licensing there's some kind of encryption on the paid ones, but is there no way we can make our own ones? If the process and/or specification is relatively simple I could probably code a quick program to do it (for instance, convert from flashcard-style text file to Pleco dictionary database format).
Thanks in advance.
I'm not sure if this is the right place for this as it should apply to all versions, but I use the Android version so I put it here rather than 'Future Products'.
This is mainly for the developers, but perhaps users who have used the user dictionary feature will also know.
So my questions are based on the specification for user dictionaries in Pleco:
1. Since the import speed is painfully slow, does anyone know what the specification is for the SQLite file ([userdict].pqb) itself?
Most of the database tables and columns are pretty obvious, but "sortkey" in the "entries" table and the related "posdex_hz" (Hanzi) and "posdex_py" (Pinyin) sorting / lookup tables weren't immediately obvious to me. I could probably work it out but thought I'd ask first if anyone already has the specification. With this it would be easy to import large databases directly into the SQLite (pqb) file, instead of going through the slow import method on the phone itself.
2. What are the codes for formatting the definitions?
I found this post: http://www.plecoforums.com/viewtopic.php?f=13&t=1406&p=10399#p10399, is the list there complete?
3. Full text search - could this be supported in the Android version?
I found this post: http://www.plecoforums.com/viewtopic.php?f=17&t=2686, but it relates to iOS, so I don't know if it also applies to the Android version (I have no idea what version of SQLite it uses or what features it may have).
Alternatively, would it be possible to create 'proper' Pleco dictionaries which due allow full text search?
I'm guessing due to licensing there's some kind of encryption on the paid ones, but is there no way we can make our own ones? If the process and/or specification is relatively simple I could probably code a quick program to do it (for instance, convert from flashcard-style text file to Pleco dictionary database format).
Thanks in advance.