[sqlite] How to get the DBName.

Thank you so much Richard...Its working :) On Thu, Apr 7, 2016 at 7:22 PM, Richard Hipp wrote: > On 4/7/16, Mahi Gurram wrote: > > > > How can i get the DB Name to which i'm writing the data into? > > https://www.sqlite.org/c3ref/db_filename.html > > -- > D. Richard Hipp > drh at sqlite.org >

[sqlite] Why SQLite lock 510 bytes for shared lock?

I found the code and the comment at [unixLock] of os_unix.h is different. The comment say that a shared lock will lock a random byte from ?shared byte range?(which is 510 bytes length). But the code show that it locks the whole ?shared byte range?. It makes me confused. Which one does the right

[sqlite] FOREIGN KEY constraint failed

On Tue, 5 Apr 2016 23:56:53 +0200 R Smith wrote: > On 2016/04/05 11:15 PM, Keith Medcalf wrote: > > Are we confusing immediate constraints (checked per statement) with > > DEFERRED constraints (checked at COMMIT time) again? In SQLite some constraints are checked per row, not per statement.

[sqlite] How to get the DBName.

On 4/7/16, Mahi Gurram wrote: > > How can i get the DB Name to which i'm writing the data into? https://www.sqlite.org/c3ref/db_filename.html -- D. Richard Hipp drh at sqlite.org

[sqlite] Why SQLite lock 510 bytes for shared lock?

On 4/7/16, sanhua.zh wrote: > I found the code and the comment at [unixLock] of os_unix.h is different. > The comment say that a shared lock will lock a random byte from ?shared byte > range?(which is 510 bytes length). But the code show that it locks the whole > ?shared byte range?. The comment