Yes, found it: no support for that in 3.3.8. :( Must compile newer version.
--
pozdrawiam / regards
Zbigniew Baniewski
-
To unsubscribe, sen
On Mon, Sep 17, 2007 at 02:29:58PM +, [EMAIL PROTECTED] wrote:
> > BTW: I'm wondering, if there's a possibility to set in similar manner
> > exclusive rights to access the database file for the duration of the entire
> > "database session", not just transaction. I mean: when I'm using a progra
On Mon, Sep 17, 2007 at 02:29:58PM +, [EMAIL PROTECTED] wrote:
> http://www.sqlite.org/pragma.html#pragma_locking_mode
Oh, boy... missed entire set of "pragma" commands. Thanks.
--
pozdrawiam / regards
Zbigniew
Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote:
>
> > Host a shared database file on computer A, say shared.db.
> > >From computer B, open shared.db remotely and execute "BEGIN EXCLUSIVE;".
> > >From computer C, open shared.db remotely an
On Sun, Sep 16, 2007 at 08:42:44PM -0700, Joe Wilson wrote:
> Host a shared database file on computer A, say shared.db.
> >From computer B, open shared.db remotely and execute "BEGIN EXCLUSIVE;".
> >From computer C, open shared.db remotely and execute "BEGIN EXCLUSIVE;".
> If computer C has the er
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Sun, Sep 16, 2007 at 05:47:07PM -0700, Trevor Talbot wrote:
>
> > The default locking mechanism relies on the underlying filesystem to
> > provide the needed locking guarantees. In this case, the OP is
> > needing to access a database on a ne
On Sun, Sep 16, 2007 at 05:47:07PM -0700, Trevor Talbot wrote:
> The default locking mechanism relies on the underlying filesystem to
> provide the needed locking guarantees. In this case, the OP is
> needing to access a database on a networked filesystem, and many
> networked filesystems are una
On 9/16/07, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> I've found a remark regarding write concurrency in SQLite:
>
> "All SQLite write operations obtain an exclusive lock on the whole database"
> ( http://www.mail-archive.com/sqlite-users@sqlite.org/msg18342.html )
>
> Doesn't it mean, that
On Thu, Sep 06, 2007 at 10:33:56AM -0700, Joe Wilson wrote:
> Without some code modification, I doubt it.
> I don't see any mention of "dot" in os_win.c.
>
> However, in SQLite 3.5 you can define your own OS Interface File
> Virtual Methods Object and create your own file lock/unlock routines
>
--- Jeff Godfrey <[EMAIL PROTECTED]> wrote:
> Thanks for the pointer. I should have mentioned, my application is
> running under Windows (Win2000 and WinXP). A quick look at the
> mentioned code makes me believe that it targets Unix-only systems
> (though there are a few brief mentions of Wind
Joe Wilson wrote:
--- Jeff Godfrey <[EMAIL PROTECTED]> wrote:
Can you (or
anyone else) point me to some web-based information?
http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/os_unix.c&v=1.165
Joe,
Thanks for the pointer. I should have mentioned, my application is
running
--- Jeff Godfrey <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > If your database storage device cannot guarantee an exclusive file
> > lock, then any database write can potentially result in corruption.
> >
> > If you control all SQLite clients' code, you could recompile sqlite
> > to use the
[EMAIL PROTECTED] wrote:
You may have a look at the dhRCPServer at:
http://www.thecommon.net/2.html
I am not using it, but it sounds it may do the job.
RBS
Bart,
Thanks for the pointer. It does sound quite interesting, though I don't
know if it can (easily?) be used from within a Tcl-base
Joe Wilson wrote:
If your database storage device cannot guarantee an exclusive file
lock, then any database write can potentially result in corruption.
If you control all SQLite clients' code, you could recompile sqlite
to use the file-based dotlockLockingStyle convention via
-DSQLITE_ENA
You may have a look at the dhRCPServer at:
http://www.thecommon.net/2.html
I am not using it, but it sounds it may do the job.
RBS
> Hi All,
>
> I currently have a single-user SQLite-based application that, due to
> customer need, is being pushed toward multi-user access. I've done some
> resea
If your database storage device cannot guarantee an exclusive file
lock, then any database write can potentially result in corruption.
If you control all SQLite clients' code, you could recompile sqlite
to use the file-based dotlockLockingStyle convention via
-DSQLITE_ENABLE_LOCKING_STYLE=1
Hi All,
I currently have a single-user SQLite-based application that, due to
customer need, is being pushed toward multi-user access. I've done some
research on the multi-user capabilities of SQLite. It seems the general
consensus is that when the database file is stored on a network drive
17 matches
Mail list logo