title: In IndexedDB, is there a way to make a sorted compound query?
body: <p>Say a table has, name, ID, age, sex, education, etc. ID is the key and the table is also indexed for name, age and sex. I need all male students, older than 25, sorted by their names.</p>
  
  <p>This is easy in mySQL:</p>
  
  <pre><code>    SELECT * FROM table WHERE age &gt; 25 AND sex = "M" ORDER BY name
  </code></pre>
  
  <p>IndexDB allows creation of an index and orders the query based on that index. But it doesn't allow multiple queries like age and sex. I found a small library called queryIndexedDB (https://github.com/philikon/queryIndexedDB) which allows compound queries but doesn't provide sorted results.</p>
  
  <p>So is there a way to make a sorted compound query, while using IndexedDB?</p>