Where to find bookmark configuration on disk (if saveBookmarksInProject=false)

[ede1998]

I've recently distro hopped and wanted to restore my bookmarks in the new setup. However I had some trouble finding them on disk. After searching for a while I found them in sqlite databases within the following directory:
~/.config/{VSCodium,Code - OSS}/User/workspaceStorage

(The name differs between my new and old distro, probably related to how vscode was packaged.)

There is a directory for each workspace with a separate state.vscdb which contains a table ItemTable with a row alefragnani.Bookmarks where the bookmark configuration is located.

I wrote a small script that restores my bookmarks to the individual vscode workspaces so that I don't have the same problem again in the future. ("bookmarks.saveBookmarksInProject": true option in vscode-bookmarks). It assumes that the workspace folders are still located in the same path as for the old distro.

Feel free to adjust it to your needs:

# assumes execution with pwd=~/.config/{VSCodium,Code - OSS}/User/workspaceStorage
# dependencies: bash, find, sqlite, jq
query="SELECT value FROM ItemTable WHERE key = 'alefragnani.Bookmarks';";

for dir in $(find * -maxdepth 0 -type d); do
	if [ ! -f "$dir/state.vscdb" ]; then
		echo No state db in $dir;
		continue;
	fi
	if [ ! -f "$dir/workspace.json" ]; then
		echo No workspace json in $dir;
		continue;
	fi
	result=$(sqlite -- "$dir/state.vscdb" "$query" | jq '.bookmarks' --raw-output | jq);
	if [ -n "$result" ]; then
		ws="$(jq '.folder' --raw-output < "$dir/workspace.json" | sed 's-^file://--')";
		echo "$result" > "$ws/.vscode/bookmarks.json";
	fi
done

[ede1998]

Just noticed this similar discussion: #640