I wasn't thinking necessarily of a local database which synced to an online version (great though this would be in some situations).
Wouldn't this require a remote connection, albeit not a server?
There are desktop applications which use SQLite (like Wappler). I was wondering if node.js would make it possible to create such applications. Neither SQLite nor PHP need a server to run.