Loading SQLite from the WSL file system

[rozsazoltan]

Describe the bug
I use the WSL file system for my PHP development. The reason is that it's easier to move the development environment. For one of my PHP packages, I'm creating an SQLite database for testing purposes. I thought after the test, I'd take a look with Antares. It's more convenient than querying what I need from the terminal.

I'm running Antares in the Windows environment. Windows can access the SQLite file from the WSL file system. However, when I open it with Antares (which loads the Windows-based SQLite), I get an error message:

Caution

SqliteError: database is locked

I checked:

• From Windows, only Antares would use the database.
• From Linux, no process is using the database.
• I can only access the file again from anywhere if I restart Antares after the connection attempt (until then, it keeps the file locked).
• If I open the same file directly from Windows (without WSL), it connects perfectly.

SQLite promises to provide a cross-platform solution. And it actually works; if I manually copy the SQLite file from Linux to Windows and open it with Antares, there is no problem. I assume the issue might be related to accessing the WSL filesystem?

Screenshots

Application (please complete the following information):

• App client [SQL Client]
• App version [0.7.29]
• Installation source: [exe]

Environment (please complete the following information):

• OS name: [Windows 11]
• OS version [23H2]
• DB name [SQLite]
• DB version [3.45.3 (x64 Windows_NT 10.0.2263.1)]

[rozsazoltan]

I wrote the issue too quickly. It seems that SQLite itself is incapable of this with WSL.

The problem has been discussed at WSL for quite some time: microsoft/WSL#4689