title: Pulling data to the template from an external database with django
body: <p>I'm going to attempting to build a web app where users can visit a url, login and view reports and other information. However the data for the reports are stored in an external database. It's a MySQL database which I'm going to have access to.</p>
  
  <p>I've done a little research on google and not have much luck finding any examples. I've done a little reading into connecting to multiple databases - <a href="https://docs.djangoproject.com/en/dev/topics/db/multi-db/" rel="noreferrer">https://docs.djangoproject.com/en/dev/topics/db/multi-db/</a> So it looks i can connect to the database ok.</p>
  
  <p>The next part is where I'm stuck. The data in the database is going to be updated all the time. I don't want to be able to edit the information neither do i want to be able to overwrite anything. I just want to be able to connect to the DB pull the information required and then view it through the template for user to be able to see. First of all because the data is being updated all the time, is this going to be a problem? (I hope not!)</p>
  
  <p>Once I've connected to the database, what is the best to be able to pull out the data and then put it into a format that i can output to the template? Would i need to import the data in to models, then control with the view. Or would i need to convert the data with JSON or XML?</p>
  
  <p>I'm fairly new to python / django, so any help would be much appreciated. If you need anymore info please ask and thanks in advance. :)</p>