title: Parsing XML file on SD card with Android
body: <p>I'm running myself around in circles here and the answer should be so simple. I have an XML file downloaded to my phone and saved to SD card. The format is simply...</p>
  
  <pre><code>&lt;programmes&gt;
      &lt;programme&gt;
          &lt;title&gt;Tom and Jerry&lt;/title&gt;
          &lt;description&gt;Cat and mouse capers&lt;/description&gt;
          &lt;start_time&gt;...&lt;/start_time&gt;
      &lt;/programme&gt;
      &lt;programme&gt;
          ...
      &lt;/programme&gt;
  &lt;/programmes&gt;
  </code></pre>
  
  <p>Essentially all I want to do is retrieve all <code>&lt;programme&gt;</code> elements and parse the internal data which will be used to create a SQL INSERT command to populate a SQLite db.</p>
  
  <p>I've tried with DOM but using Document.parse() took me out of memory (the xml file is 3.5MB in size). I've never worked with SAX and can't find an example that makes sense for my idea of how I want to do things and although I've used XPATH, again I can't find any example using the available android apis.</p>
  
  <p>As I said, I'm sure this is easy and it's just my approach is wrong so I'd appreciate any pointers to doing this.</p>