jesslark / dictionary

Dictionary of words that are assumed knowedge in the dev community but may be unfamiliar to new, or even seasoned, developers.
https://jessmear.github.io/dictionary
19 stars 54 forks source link

Come up with solutions for managing the list of words #10

Open jesslark opened 6 years ago

jesslark commented 6 years ago
FluidMind commented 6 years ago

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.

jesslark commented 6 years ago

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?

FluidMind commented 6 years ago

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.