Re: [sqlite] [OT] Program to document database l ayout

Rich Shepard <[EMAIL PROTECTED]> writes: > On Wed, 16 Apr 2008, Hartwig Wiesmann wrote: > >> this is a bit off topic: I am looking for a program that is suitable for >> documenting the structure of a SQLite database. I am looking for a program >> that can visualize the relations between different

Re: [sqlite] Suggests for improving the SQLite website

Hi, > Just visited the new front page. I like it a lot. > > But one of the crown jewel features (at least to me) is buried in the > fine print: Virtual Tables. Is this an oversight? I would at least I would second this. Without vtables our product - and use of SQLite - would be very differ

Re: [sqlite] How should virtual table module return its own error messages?

Hi, > Greetings, > > I followed one of the wiki notes on how a virtual table module method > such as xUpdate should set error message for consumption upstream. A > code snippet is: > ... > sqlite3_free(aVTab->zErrMsg); > aVTab->zErrMsg = sqlite3_mprintf( "No such FOO: %s", foo );

Re: [sqlite] How many virtual table implemenations are there out there?

Hello, > The current virtual-table implementation does not work when you have > shared cache mode enabled. We would like to fix this so that that > you can (for example) use FTS and shared cache at the same time. > But to do so seems likely to require an incompatible change to the > virtual-tabl

Re: [sqlite] returning multiple rows from custom functions

Nathan Kurz <[EMAIL PROTECTED]> writes: > On Thu, Dec 15, 2005 at 09:17:48PM +0000, Andrew McDermott wrote: >> For example, I'm currently computing a histogram in application code for >> a moderately sized table (7+ million rows), but I'm wondering whether it

[sqlite] returning multiple rows from custom functions

Hi, Is it possible to get an aggregate function to return more than one row? For example, I'm currently computing a histogram in application code for a moderately sized table (7+ million rows), but I'm wondering whether it would be quicker to get the results computed via a custom SQLite function