First version of vocabulary program

[arwer13]

With respect to the vocabulary program. Here is the starting specification as I see it.

Develop a schema of relational SQL database to store

• words (all unique)

• examples of word usage (whole sentences)

• frequencies of words

  Result: file with sql code to create the schema.
  Notes:

  • At this stage it would be impossible to differentiate word forms, but it's ok.
  • Consider to use SQLite3 as database, because it's the simplest one, but very popular
  • pure xml or json or something like this are not good choices at all for storing and further processing of our kind of data (for many reasons). Some document-oriented (for example json documents) might be considered, but it 's to be a good choice in our case.

Develop a Python program for parsing provided text and adding / updating database.

It should have a simple command line interface: one argument -- path to .txt file

Develop a Python program for querying information about word:

• all known examples of usage
• it's frequency
• it's percentage (among all known unique words)

This program should have a simple command line interface: one argument -- word to look up.

[RyanMcCarl]

Hi Artyom,

Sorry, I missed this email; this looks good to me. I will get started on it this week.

Ryan

On Feb 26, 2016, at 6:01 AM, Veremeenko Artyom [email protected] wrote:

With respect to the vocabulary program. Here is the starting specification as I see it.

Develop a schema of relational SQL database to store

words (all unique)
examples of word usage (whole sentences)
frequencies of words

Result: file with sql code to create the schema.
Notes:

At this stage it would be impossible to differentiate word forms, but it's ok.
Consider to use SQLite3 as database, because it's the simplest one, but very popular
pure xml or json or something like this are not good choices at all for storing and further processing of our kind of data (for many reasons). Some document-oriented (for example json documents) might be considered, but it 's to be a good choice in our case.
Develop a Python program for parsing provided text and adding / updating database.

It should have a simple command line interface: one argument -- path to .txt file

Develop a Python program for querying information about word:

• all known examples of usage
• it's frequency
• it's percentage (among all known unique words)

This program should have a simple command line interface: one argument -- word to look up.
—
Reply to this email directly or view it on GitHub.

[arwer13]

Hi Ryan! Sorry for rather long period of silence, I got a little entangled and not sure what I should do at the moment. We have discussed a lot of topics to work on and I'm not sure what to choose. I was going to make 10-minute texts/assignments, but then you had written you were getting started on the vocabulary program and I stopped) Would you please clarify what is the most priority? We should focus and start writing code! I would also appreciate if we would organize various learning tasks/goals into issues. It's difficult to search through all emails to recall discussions on various threads. PS: If there are some problems with understanding my English, please say me. I'd try to fix it and pay more attention to putting my thoughts in words.

[RyanMcCarl]

Hi Artyom,

Sorry for creating confusion; I think I don't have the time to work on a full program right now because of my full-time job and WordBrewery. So instead, let's continue with the plan I proposed before of short 5-15 minute coding lessons + Q & As and code review. Does that sound good?

Thanks,
Ryan