I am using turso.tech (libsql) and Nuxt 3. I was planning to use websocket but it's just too complicated and just went with long-polling every 5 seconds to get the data and deploy it to cloudflare pages/worker.
There is no need to login and also no IP tracking. I use installation id and save it to cookies, so basically you can clear cookies to get a new installation id. I don't know a better way to get unique user without being "intrusive" but if you have a better idea please do give one.
You can check the source code here https://github.com/yunusefendi52/tab-vs-space
Thank you