How to access SQLite file in WSL2

SQLite Jul 4, 2023

My case is when I initialize the database in WSL2 and try to access it with GUI tool on the Window, for example, Dbeaver, DB for SQLite etc.

Possible Cause

From internet search, seem like the WSL path \\wsl$\Ubuntu ... is the problem.

So the file must be on the Window path

Linking Workaround

Now we move the database file to Window path.

As an example foo.db is in my desktop.

Now link it into our WSL machine. Note that we need flag -s.

Also note that way to access Window’s file in WSL2 is through /mnt/c/...

Command
ln -s <source path> <destination path>Inside WSL2
ln -s /mnt/c/Users/Tanut/Desktop/foo.db ./foo.db

Now we can:

  1. Access from GUI from Window machine
  2. Have convenient short path that can access from WSL machine

Hope this help !

Tags

TeamCMD

We are CODEMONDAY team and provide a variety of content about Business , technology, and Programming. Let's enjoy it with us.