Documentation Source Text

  F1227-       sqlite3_interrupt
  F1228-       trace and profile callbacks
  F1234-       busy handler
  F1237-       sqlite3_get_table
  F125--       authorizer
  F126--       load extension
  F127--       sqlite3_open
  F1276-       sqlite3_limit
  F128--       Error handling
  F129--       callback interfaces
  F13---     Prepared statements
  F135--       binding values to prepared statements
  F137--       sqlite3_column_xxx()
  F14---
  F15---     sqlite3_value

      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2008 Apr 16 (3.5.8)} {
<li>Expose SQLite's internal pseudo-random number generator (PRNG)
    via the [sqlite3_randomness()] interface</li>
<li>New interface [sqlite3_context_db_handle()] that returns the
    [database connection] handle that has invoked an application-defined
    SQL function.</li>
<li>New interface [sqlite3_limit()] allows size and length limits to be
    set on a per-connection basis and at run-time.</li>
<li>Improved crash-robustness: write the database page size into the rollback
    journal header.</li>
<li>Allow the [VACUUM] command to change the page size of a database file.</li>
<li>The xAccess() method of the VFS is allowed to return -1 to signal
    a memory allocation error.</li>
<li>Performance improvement: The OP_IdxDelete opcode uses unpacked records,
    obviating the need for one OP_MakeRecord opcode call for each index
    record deleted.</li>
<li>Performance improvement: Constant subexpressions are factored out of
    loops.</li>
<li>Performance improvement: Results of OP_Column are reused rather than
    issuing multiple OP_Column opcodes.</li>
<li>Fix a bug in the RTRIM collating sequence.</li>
<li>Fix a bug in the SQLITE_SECURE_DELETE option that was causing
    Firefox crashes.  Make arrangements to always test SQLITE_SECURE_DELETE
    prior to each release.</li>
<li>Other miscellaneous performance enhancements.</li>
<li>Other miscellaneous minor bug fixes.</li>
}

chng {2008 Mar 17 (3.5.7)} {
<li>Fix a bug ([ticket #2927]) in the register allocation for
compound selects - introduced by the new VM code in version 3.5.5.</li>
<li>ALTER TABLE uses double-quotes instead of single-quotes for quoting
filenames.</li>
<li>Use the WHERE clause to reduce the size of a materialized VIEW in

</td>
<td width="20"></td><td bgcolor="#80a796" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_5_8.html">Version 3.5.8</a>
of SQLite is stable and is recommended for all users.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>

  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<p>$txt</p>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2008-Apr-16} {Version 3.5.8} {
  Version 3.5.8 includes some important new performance optimizations
  in the virtual machine code generator, including constant subexpression
  factoring and common subexpression elimination.  This release also
  creates new public interfaces:
  [sqlite3_randomness()] provides access to SQLite's internal
  pseudo-random number generator, [sqlite3_limit()] allows size
  limits to be set at run-time on a per-connection basis, and
  [sqlite3_context_db_handle()] is a convenience routine that allows
  an application-defined SQL function implementation to retrieve
  its [database connection] handle.

  This release of SQLite is considered stable and ready for production use.
}

newsitem {2008-Mar-17} {Version 3.5.7} {
  Version 3.5.7 fixes several minor and obscure bugs, especially 
  in the autoconf-generated makefile.  Upgrading is optional.
  This release of SQLite is considered stable and ready for production use.
}