On Thu, Jun 28, 2007, Mark Hatle wrote:

> Is "TEMPORARY TABLE" something special?  I knew about the :memory:
> before, but not the other.

Excerpt from http://www.sqlite.org/lang_createtable.html:

   If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE"
   and "TABLE" then the table that is created is only visible within
   that same database connection and is automatically deleted when the
   database connection is closed. Any indices created on a temporary
   table are also temporary. Temporary tables and indices are stored in
   a separate file distinct from the main database file.

> Otherwise this looks good to me.  It may even speed things up slightly.

But before I can commit I at least wish to find a better approach for
the DB_PRIVATE value. The current hack is not the best since sliced
bread:

> > +#if defined(WITH_SQLITE) && !defined(DB_PRIVATE)
> > +#define DB_PRIVATE 0x0200000 /* shameless hack for shared option */
> > +#endif

                                       Ralf S. Engelschall
                                       rse@engelschall.com
                                       www.engelschall.com