Re: [sqlite] SQLite with single writer on Windows network share

https://sourceforge.net/projects/mingw-w64/files/?source=navbar --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On

Re: [sqlite] SQLite with single writer on Windows network share

On 12 May 2019, at 12:52am, Jose Isaias Cabrera wrote: > the other question is, that I think I only need the gcc@6 package to build > Bedrockdb. Does anybody know what is gcc@6? But I don't know where to find it for your platform.

Re: [sqlite] SQLite with single writer on Windows network share

Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... > >On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: > > It should run under Cygwin and WSL. > > I doubt it’s any more difficult to port to Windows than dozens of other > similar > packages like Apache and MySQL. Someone’s just got to

Re: [sqlite] SQLite with single writer on Windows network share

On 11 May 2019, at 11:20pm, Warren Young wrote: > I doubt it’s any more difficult to port to Windows than dozens of other > similar packages like Apache and MySQL. Mutex/Locking. You're relying on a File System and/or a Network File System that does locking properly. I'm not saying that

Re: [sqlite] SQLite with single writer on Windows network share

On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: > >> How about you give up on the idea of using Windows shares to distribute a >> SQLite DB and use a tool meant for the job, such as BedrockDB? > > BedrockDB is recommended here now and then, and it sounds interesting indeed. > However, it's

Re: [sqlite] SQLite with single writer on Windows network share

> How about you give up on the idea of using Windows shares to distribute a > SQLite DB and use a tool meant for the job, such as BedrockDB? BedrockDB is recommended here now and then, and it sounds interesting indeed. However, it's not available for Windows. (This should always be noted when

Re: [sqlite] Partial NOT NULL index malfunctions with IS NOT/!=

On 11/5/62 16:54, Manuel Rigger wrote: Hi everyone, I found another test case that demonstrates a malfunctioning index: CREATE TABLE IF NOT EXISTS t0 (c0); CREATE INDEX IF NOT EXISTS i0 ON t0(1) WHERE c0 NOT NULL; INSERT INTO t0(c0) VALUES(NULL); SELECT * FROM t0 WHERE t0.c0 IS NOT 1; --

[sqlite] Partial NOT NULL index malfunctions with IS NOT/!=

Hi everyone, I found another test case that demonstrates a malfunctioning index: CREATE TABLE IF NOT EXISTS t0 (c0); CREATE INDEX IF NOT EXISTS i0 ON t0(1) WHERE c0 NOT NULL; INSERT INTO t0(c0) VALUES(NULL); SELECT * FROM t0 WHERE t0.c0 IS NOT 1; -- returns no row If the index is created, no