Re: [sqlite] row size limit

On Mon, 2004-04-19 at 20:36, D. Richard Hipp wrote: > Mrs. Brisby wrote: > >> > >>The linked-list structure of overflow storage is part of the problem. > >>But the fact that SQLite uses synchronous I/O is also a factor. In > >>order to make BLOBs fast in SQLite, I would have to change to a differe

Re: [sqlite] row size limit

Mrs. Brisby wrote: The linked-list structure of overflow storage is part of the problem. But the fact that SQLite uses synchronous I/O is also a factor. In order to make BLOBs fast in SQLite, I would have to change to a different indexing technique for overflow storage *and* come up with some kind

Re: [sqlite] row size limit

On Mon, 2004-04-19 at 07:04, D. Richard Hipp wrote: > Darren Duncan wrote: > > > > I think the simple answer is that SQLite uses a linked list which can't > > know where a page is until reading the next one, but other databases use > > something other than a linked list; they would trade a bit o

Re: [sqlite] XML translation inquiry

I've been away and busy and never had a chance to respond to this. I decided to continue the response as a sqlite-users thread (as opposed to just responding directly to andrew) in case others wish to listen-in or respond. i am developing a brand new application (manager) that is 'constrained' only

Re: [sqlite] Re: I tried sending email to sqlite@egroups.com but it failed to post

>> I was wondering if it were possible to straightforwardly >> programmatically control (hopefully without hacking the engine) which >> tables will be kept cached in memory by default. For example, if I know >> that a particular table, or a particular index, will be accessed very >> frequently, is

[sqlite] about sqlite_freemem()

hi, in DLL case of sqlite, do i need to call sqlite_freemem() after sqlite_exec()/sqlite_get_table(), or only after sqlite_open() , after error? Ivan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [E

Re: [sqlite] Encodings question

Bertrand Mansion wrote: I am not sure what this means ? It is not recommended that you use PHP in a web-server configuration with a version of the SQLite library compiled with UTF-8 support, since libsqlite will abort the process if it detects a problem with the UTF-8 encoding. There is no code

Re: [sqlite] Encodings question

<[EMAIL PROTECTED]> wrote : > Bertrand Mansion wrote: > >> As far as I understand, UTF-8 will read 8859-1 without problem but >> ISO-8859-1 will not be able to read UTF-8, unless everything in the UTF8 >> string uses only 8859-1 codes. > > You're wrong, I think. > > UTF-8 is a variable length e

Re: [sqlite] Encodings question

Bertrand Mansion wrote: As far as I understand, UTF-8 will read 8859-1 without problem but ISO-8859-1 will not be able to read UTF-8, unless everything in the UTF8 string uses only 8859-1 codes. You're wrong, I think. UTF-8 is a variable length encoding of character codes of the unicode code pag

[sqlite] Re: I tried sending email to sqlite@egroups.com but it failed to post

Michael Lyubomirskiy wrote: Hi, I got message from the server saying that this group is announcement only. But I thought I got an email from the moderator saying I can post by sending to [EMAIL PROTECTED] Could you please tell me how to post messages properly? Thank you for your consideration.

Re: [sqlite] row size limit

Darren Duncan wrote: I think the simple answer is that SQLite uses a linked list which can't know where a page is until reading the next one, but other databases use something other than a linked list; they would trade a bit of complexity for speed. -- Darren Duncan The linked-list structure of