How to access sqlite on a remote site

I have a sqlite db on a web server for eg: ( How do i access that db from local machine. Can i access like Getfolderitem(

A couple choices spring to mind

  1. download it so its local
  2. write some app that runs on the web server that provides an api to use it - but then you don’t open t as a database any more

But no you can’t just open it like you’re example code showed unless you have some way to mount that web site as a volume so it appears like it is local (but I’d suggest not doing that anyways since performance may be poor esp with db locking)

Depends on your server architecture but I would use php on mine to connect, retrieve a record set and then return XML. You would call your php from httpsocket.