Redesign lexicon DB table to minimize space and query time

blinskey / greek-reference

An ancient Greek lexicon and grammar for Android.

https://play.google.com/store/apps/details?id=com.benlinskey.greekreference

Apache License 2.0

29 stars 5 forks source link

Redesign lexicon DB table to minimize space and query time #136

Closed blinskey closed 6 months ago

blinskey commented 9 years ago

Right now, we have a number of columns in the lexicon table that store each word in both beta code and Greek characters, with and without diacritics. It would make more sense to store a single canonical form of each word and convert search queries that form at runtime.

github-actions[bot] commented 6 months ago

This project is now in limited maintenance mode. All issues created before 2024 are being marked as stale.

github-actions[bot] commented 6 months ago

This issue was closed because it was marked as stale.