Re: [sqlite] creating a sqlite db on raw disk ?

On Fri, Nov 19, 2010 at 10:09 AM, Jay A. Kreibich wrote: > On Thu, Nov 18, 2010 at 11:04:02PM -0800, Yang scratched on the wall: > > > innodb allows creating a db on a raw disk partition, can we do the > > same on sqlite? > > Not out of the box, but it could be done by writing a VFS driver. >

Re: [sqlite] creating a sqlite db on raw disk ?

On Thu, Nov 18, 2010 at 11:04:02PM -0800, Yang scratched on the wall: > innodb allows creating a db on a raw disk partition, can we do the > same on sqlite? Not out of the box, but it could be done by writing a VFS driver. It is an idea I've toyed with, but I don't really have the low-level

Re: [sqlite] creating a sqlite db on raw disk ?

Thanks for your detailed explanation. for your first question: I mean creating a new database file. since you asserted " >> innodb allows creating a db on a raw disk partition, can we do the >> same on sqlite? > > No. You need a file system of some kind. Or, at least, your operating > system

Re: [sqlite] creating a sqlite db on raw disk ?

On 19 Nov 2010, at 7:04am, Yang wrote: > when I create a db on a file system, I guess a query process Wait ... are you talking here about creating a new database file or querying one what already exists ? > has to go > through 2 levels of seeks ? > first sqlite finds the B-tree node that store

[sqlite] creating a sqlite db on raw disk ?

when I create a db on a file system, I guess a query process has to go through 2 levels of seeks ? first sqlite finds the B-tree node that stores the index to the file offset of my desired record, then sqlite uses that offset to make syscall seek(offset), then Kernel consults the FS implementation