If you just need to store the reports, then just use XML blobs. If you need to do math on data within the reports (i.e. analytics across projects) then break it into a schema.
On Monday, March 9, 2015 at 9:48:23 AM UTC-4, Najtsirk wrote: > > Dear Web2pyers, > > I have dilemma not connected directly to Web2py. I am running / developing > a web application where different projects seek impact investments and > donations. Each project is obliged to submit a report by the end of the > year. > > For the first two years we accepted written reports in word documents. > From this year on we contemplate of e-reporting. So here we face dilemma. I > have in mind two ways of doing that: > > - define databse schema with all the necessary fields. The problem is > what if we decide to change schema next year. > > - write report as a xml structured document in our database. > > Which way is better in your opinion? > > Best > K > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
