AEA wrote:Perhaps I should rephrase this, If you were me would Python be your choice of platform for such a project?
Yes. (but then, I answer questions on a Python forum, so what do you expect?
) Python has long been the language of choice for scientific and analytical computing and has a lot of support in this area (there is even an annual confrence that focuses on applications of Python in data modeling and analysis).
AEA wrote: Its all one step at a time kind of thing.
Yup, absolutely. There is a lot
that Python can offer you in this area; way too much to take in at once (there are libraries, tools, frameworks, environments, etc). But you can achieve a lot even with a basic understanding of the laguage, and then continuosly refine your process as you learn new stuff.
AEA wrote:Is there a recommended database which can perform queries more effectively and efficiently? Again to rephrase, If you were me which type of database would you select for said project?
Databases are a rather complicated subject in their own right. Which to use would depend partly on your requirements and partly on subjective opinion. For now, I suggest you look at sqlite to begin with. Python's standard library has a module
for working with it. However, depending on what you are doing, you may not even want a database, and use a flat file (e.g. in JSON format) instead.