dictionary icon indicating copy to clipboard operation
dictionary copied to clipboard

Come up with solutions for managing the list of words

Open jesslark opened this issue 7 years ago • 3 comments

  • Words need to be alphabetized
  • Store the words in a database
  • Check for duplicates

jesslark avatar Oct 19 '18 22:10 jesslark

Thoughts on this:

Most dbms systems would allow for unique keys to be declared, but there may be overlap.

Scalability, for example, means something different in implemebtation to a SQL Developer than a C# Developer.

Therefore, moderation and categorization are likely going to be necessary evils.

Having said that, if it is stored in a database, the select commands are responsible for sorting, so you can take that item off your maintenance list.

I can help with structure if you have an idea of your preferred dbms.

FluidMind avatar Oct 19 '18 23:10 FluidMind

I do not have any real direction on this. I used Heroku once, with a Rails app, but otherwise have not done much work with databases. Do you have any suggestions?

jesslark avatar Oct 20 '18 02:10 jesslark

MySQL is free and open source. There's a free version of MS SQL Server, but not if the database grows past 10GB. Course, we could setup the project with replicated formats.

FluidMind avatar Oct 20 '18 03:10 FluidMind