Hi, here's what's there in one of the sqlite log files. The log files for all the issues are similar to this:
# This file contains the result of Yarn building a package (sqlite3@virtual:ea905facafa672edd4ca6ebe811ab4147a7111a450556bbd4dd4fb8ba9d210a2390363e464760eaa3fbdf0715da61706a598d3f51450dfbadcf2f95b9d4d954f#npm:5.1.6)
# Script name: install
node-pre-gyp info it worked if it ends with ok
node-pre-gyp info using node-pre-gyp@1.0.10
node-pre-gyp info using node@19.0.0 | linux | x64
node-pre-gyp info check checked for "/home/vbuntu/Desktop/Vatsal/Programming/open-source-contributions/joplin/packages/tools/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node" (not found)
node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-x64.tar.gz
node-pre-gyp info install unpacking napi-v6-linux-glibc-x64/node_sqlite3.node