guiWords is a Windows desktop application based on the popular Latin dictionary application, Whitaker's Words. I recently corrected many data problems I previously missed. There is a lot of data here and there is a chance I still managed to miss some issues. These will be made manifest only through use.
I've ported the application to be a web application using AngularJS. You can find it here.
- Over 30,000 Latin words and their English meanings are included in this dictionary.
- Dictionary form, definition, and parsing information displayed in sets which can be expanded or closed as needed.
- Search for multiple forms at a time.
- Complete search history can be displayed at any time.
- A link to Perseus Latin Word Tool for every form.
- An additional window will be show all forms of the Latin word.
- Easily copy and paste the search results.
- It looks sexy.
- Converted fixed-width flat files into usable tsv in order to import into MSSQL Server.
- Designed and built a database structure making use of existing keys and creating new ones as necessary to keep data normalization and integrity.
- Created 4 stored procedures which use the raw, unformatted data to create indexed tables. Stored procedures can be run multiple times without errors.
- Designed a parsing stored procedure which includes steps to query multiple words.
- Designed a UI using Windows Presentation Foundation.
- Using LINQ, wrote a function to query the database for the forms and return a result set.
- Wrote a function in C# to dynamically display search results in a panel.
- Wrote an enumerable class instantiated as a search history object. The system stores each search within a session history which can be displayed in the result panel.
- Deployed necessary tables to a remote SQL server and relinked the application.
- Added a link to the Perseus Tufts dictionary resource.
- Developed a process to display all of the forms of a word in a single window partitioned out into reasonable groupings.
- Refactored the entire thing to increase efficiency.
- I want to add support for English to Latin searches. This is a really complicated process mostly because the dictionary files themselves really don't lend themselves to this sort of thing. It is in the plan eventually, however.
- After reaching a point where I'm like, "Yeah, I'm done with this." I still have other plans for this...