Re: [sqlite] Amount of data stored in the B-tree for Sqlite 3

2006-10-17 Thread drh
"Robert Wojciechowski" <[EMAIL PROTECTED]> wrote: > Hello, > > I'm trying to figure out the exact algorithm to determine how much data > can be stored within Sqlite 3's B-tree without using overflow pages. > > I've searched quite a bit and all the documents I've seen explain how > Sqlite 2 works

[sqlite] Amount of data stored in the B-tree for Sqlite 3

2006-10-17 Thread Robert Wojciechowski
Hello, I'm trying to figure out the exact algorithm to determine how much data can be stored within Sqlite 3's B-tree without using overflow pages. I've searched quite a bit and all the documents I've seen explain how Sqlite 2 works with a page size of 1024 which results in 238 bytes available

[sqlite] SQLite GUI app that offers layouts

2006-10-17 Thread T
Hi all, There seem to be several SQLite GUI apps around. But I haven't seen any that offer building of layouts, ie positioning test frames for fields on a page for form data entry or printing. This feature is typical of proprietary apps such as FileMaker, AppleWorks, 4D etc. Anyone know

[sqlite] bail out patch

2006-10-17 Thread Jim Ursetto
Hi, I created a patch which adds "-bail" and ".bail" commands to the sqlite3 shell. When bail is enabled, the shell will exit with a non-zero return code immediately upon encountering the first SQL error. This is useful when you pass a number of commands to the shell non-interactively and wish

Re: [sqlite] Error in SQLite's CSV output

2006-10-17 Thread Dennis Cote
T wrote: 1. Is this a known bug in SQLite's csv output? Will it be fixed? Tom, Yes this is a know issue. I wouldn't hold my breath waiting for it to be fixed 2. Is there another way to reliably get the contents of a database via the command line? It must handle values containing pipes,

Re: [sqlite] bind with select?

2006-10-17 Thread Dennis Cote
Dave Dyer wrote: I can't find an example, but it seems like there ought to be syntax to use bind to inline selection variables, instead of having to have a callback function. Something like: char *forval,*barval; sqlite_prepare(db,"select ?foo,?bar from table"); sqlite_bind("?foo",);

Re: [sqlite] Error in SQLite's CSV output

2006-10-17 Thread Martin Jenkins
T wrote: 1. Is this a known bug in SQLite's csv output? Will it be fixed? SQLite is a database library and the shell is just a handy tool that happens to come with it. ISTM that the developers (should) give bugs like this a pretty low priority. 2. Is there another way to reliably get the