title: Choice of embedded database?
body: <p>We are building an application on an embedded platform that needs a reasonably high performance database (very low select speeds on tables with > 500,000 entries).<br>
  <br>
  The database needs to be able to :
  <li> Store atomic commit information in NVRAM so that such information is preserved if power fails before the commit finishes.
  <li> Be written to NAND Flash in such a way as to level wearing across the memory (could be done using, e.g. jffs2 or yaffs2).<br>
  <br>
  Currently our options appear to be a "roll-your own" approach, or possibly SQLite.<br> 
  <br>Any other options, or pointers about the details of "rolling your own" or working with SQLite appreciated!
  <br>
  <br>
  <b> Edit:</b> The target has 32MB of RAM, 1MB of NVRAM and 64MB of NAND Flash.  The rest of the code is C, so that is the preferred language.  The target processor is an ARM. In general, the queries that need to have the most performance are pretty simple.  Complex queries don't need to have the same level of performance.</p>