Kaltxì!
As you might have seen, I have been working on a dictionary application. I have realized that I need to do a complete remake of my Editor application, which is far to glitchy at the moment. I was thinking of making this new editing system with MySQL and PHP, for easier editing of the database. That would mean that I would get a Web based editing GUI.
However, with a system like that, it would be possible to write converters, to (almost) any file format (CSV, TSV, BEF, JSON requests, maybe even PDF (never done that before)). I figured that there would probably be more people that would be interested in a solution like this.
A global solution like this would however require that people that know the language better would contribute to editing and maintaining the database, and of course, a solid planning of how to store the data and retrieve it from the database.
What I have done so far is an example database, and an example row in the database.
Table:
Row:
The thought behind the columns is that the navi field should contain the word, with all possible gramatic variants, which is stored withing () and separated with |, which is pure Regex code. That will make it possible to simply match the input string using to the navi field using Regex. I have also planned on implementing "shortcuts" when entering the word, so you wont need to enter the (|ìm|ay|er|ol|ìrm) part for every word. The most of the other fields are pretty self explaining. The fonetic field could contain underlining information.
To do something like this I need to have controls on who is inserting/editing words, to avoid spamming in the database. To solve this issue I have planned to have a few trusted users, which can approve words submitted by other users.
My thought was that this might come in handy while the language is developing, especially for people that's writing applications that depends on a dictionary, so that instead of everyone creating their own dictionaries, they can just update from this one.
