D 2020-01-24T02:27:10.435
J foundin All\sto\sdate
J icomment When\smaking\scalls\sto\sthe\sWin32\sCreateFile()\sfunction,\sSQLite\sappears\sto\salways\sset\sthe\sfile\ssharing\sparameter\sdwShareMode\s=\sFILE_SHARE_READ\s|\sFILE_SHARE_WRITE\swhich\sallows\sthe\sfile\sto\sbe\sopened\sfor\sshared\saccess\sacross\sprocesses.\s\sCreateFile()\smust\sbe\scalled\swith\sa\sdwShareMode\s=\s0\sin\sorder\sto\sopen\sthe\sfile\sin\sa\strue\sprocess\sexclusive\saccess\smode.\sSee\shttps://docs.microsoft.com/en-us/windows/win32/fileio/creating-and-opening-files\sfor\sfull\sdetails.\r\n\r\nA\sside\seffect\sof\sthis\sbehavior\sis\seven\swhen\sSQLite\sis\sconfigured\sfor\sEXCLUSIVE\sWAL\smode,\susers\sare\sstill\sable\sto\scopy\sopen\sSQLite\sdatabase\sfiles\son\sWindows\susing\sExplorer\sor\sother\smeans\swhich\scan\sresult\sin\scorrupt\scopies\sthat\sbefuddle\send\susers.\r\n\r\nTo\savoid\sthis\sfor\sour\suse\scases,\swe're\scurrently\shaving\sto\srebuild\sour\sown\scustom\sversion\sof\sSQLite\swhich\sallows\sus\sto\sforce\sdwShareMode\s=\s0.\s\sWe're\sreaching\sout\sand\ssee\sif\sthere\swould\sbe\sany\sappetite\sto\sadd\san\soption\sto\sallow\sfor\sa\sprocess\sexclusive\sfile\saccess\smode\sin\sthe\supstream\sSQLite?
J login anonymous
J mimetype text/plain
J private_contact a214446b313c03bc7875380263b179ad1b3e7c88
J severity Important
J status Open
J title Add\soption\sfor\sa\sprocess\sexclusive\smode\sto\sopen\sfiles\son\sWindows
J type Feature_Request
K 0b91277bb4e13c7c68bdbbb76558871ed5dd5c35
U anonymous
Z 3ee615f97be74015e348ddabd087e19d