odrevet/fujiten

Fujiten is a Japanese dictionary application made with the flutter framework

fujiten's Issues

Formatting of description in Fastlane

If you saw how your full_description.txt renders at F-Droid, maybe you're interested in some improved formatting? You can find some formatting hints here. Most importantly, you should avoid using "headings" (<h3> & co) – and be aware that F-Droid converts each line break into <br>\n.

Giving you an idea of how to achive better rendering:

Fujiten is a Japanese dictionary application made with the flutter framework.

Definition and kanji comes from the EDICT dictionary, compiled as a database from the edict_database project.

<br><big>Setup</big>

In order to fujiten to work, the Expression Database and the Kanji Database are needed. The databases can be downloaded and installed from fujiten via the &quot;settings/databases menu or by downloading the database manually from <a href="https://github.com/odrevet/edict_database">https://github.com/odrevet/edict_database</a>.

<br><big>Top menu</big>

<b>Bars</b>

Access the settings menu.

…

This should work well with F-Droid – and also with Play and with my repo (where your app was listed until now; I usually remove apps from my repo after a decent "overlap", i.e. 10..14 days after they reached F-Droid. Should you want me to keep your app, please let me know).

Building for iOS, Issue with 言葉 search

漢字 search is fine.

Issue: 言葉 search returns no result.

Log:
Search keyword is “言葉”, tried other words but same log.

[logging] no such function: REGEXP in "SELECT entry.id as entry_id,
                  sense.id as sense_id, 
                  (
                    SELECT
                      GROUP_CONCAT(IFNULL(keb || ':', '') || reb)
                    FROM
                      r_ele r_ele_sub
                      LEFT JOIN r_ele_k_ele ON r_ele_k_ele.id_r_ele = r_ele_sub.id
                      LEFT JOIN k_ele k_ele_sub ON r_ele_k_ele.id_k_ele = k_ele_sub.id
                    WHERE
                      r_ele_sub.id_entry = entry.id
                  ) keb_reb_group,
                  GROUP_CONCAT(DISTINCT gloss.content) gloss_group,
                  GROUP_CONCAT(DISTINCT pos.description) pos_group,
                  GROUP_CONCAT(DISTINCT dial.name) dial_group,
                  GROUP_CONCAT(DISTINCT field.name) field_group,
                  GROUP_CONCAT(DISTINCT misc.name) misc_group
                  FROM entry
                  JOIN sense ON sense.id_entry = entry.id
                  JOIN gloss ON gloss.id_sense = sense.id
                  LEFT JOIN sense_pos on sense.id = sense_pos.id_sense 
                  LEFT JOIN pos on sense_pos.id_pos = pos.id
                  LEFT JOIN sense_dial on sense.id = sense_dial.id_sense 
                  LEFT JOIN dial on sense_dial.id_dial = dial.id
                  LEFT JOIN sense_field on sense.id = sense_field.id_sense 
                  LEFT JOIN field on sense_field.id_field = field.id
                  LEFT JOIN sense_misc on sense.id = sense_misc.id_sense
DB Error: 1 "no such function: REGEXP"
DB Query: SELECT entry.id as entry_id,
                  sense.id as sense_id, 
                  (
                    SELECT
                      GROUP_CONCAT(IFNULL(keb || ':', '') || reb)
                    FROM
                      r_ele r_ele_sub
                      LEFT JOIN r_ele_k_ele ON r_ele_k_ele.id_r_ele = r_ele_sub.id
                      LEFT JOIN k_ele k_ele_sub ON r_ele_k_ele.id_k_ele = k_ele_sub.id
                    WHERE
                      r_ele_sub.id_entry = entry.id
                  ) keb_reb_group,
                  GROUP_CONCAT(DISTINCT gloss.content) gloss_group,
                  GROUP_CONCAT(DISTINCT pos.description) pos_group,
                  GROUP_CONCAT(DISTINCT dial.name) dial_group,
                  GROUP_CONCAT(DISTINCT field.name) field_group,
                  GROUP_CONCAT(DISTINCT misc.name) misc_group
                  FROM entry
                  JOIN sense ON sense.id_entry = entry.id
                  JOIN gloss ON gloss.id_sense = sense.id
                  LEFT JOIN sense_pos on sense.id = sense_pos.id_sense 
                  LEFT JOIN pos on sense_pos.id_pos = pos.id
                  LEFT JOIN sense_dial on sense.id = sense_dial.id_sense 
                  LEFT JOIN dial on sense_dial.id_dial = dial.id
                  LEFT JOIN sense_field on sense.id = sense_field.id_sense 
                  LEFT JOIN field on sense_field.id_field = field.id
                  LEFT JOIN sense_misc on sense.id = sense_misc.id_sense 
                  LEFT JOIN misc on sense_misc.id_misc = misc.id
                  WHERE entry.id IN (SELECT DISTINCT  entry_sub.id FROM entry entry_sub JOIN sense sense_sub ON entry_sub.id = sense_sub.id_entry JOIN r_ele on entry_sub.id = r_ele.id_entry
         LEFT JOIN k_ele ON entry_sub.id = k_ele.id_entry WHERE (keb REGEXP '言葉' ) LIMIT 10 OFFSET 0)
                  GROUP BY sense.id
DB Path: /var/mobile/Containers/Data/Application/CF4DD936-8829-48ED-A6F1-3A825C4A2FB6/Documents/expression.db