Can I connect remotely to the Sqlite3 database via python, and if so, how?

  • Can. sqlite connects as a file. Accordingly, having mounted a remote host it is possible to connect the file from it. The way of mounting depends on the target and end system (Windows, Linux, etc ..?). - Mikhail Alekseevich
  • Well, how to specify the path to the site, for example, I think not so pro = sqlite3.connect ('site') - Twiss
  • one
    @ Dmitry put the information necessary for the answer in the question itself (there is a button to edit ) "when the user entered the program" - what does this mean? If you mean that the person in the browser comes to the page, and your task is to implement the web application that forms this page, then the sqlite database is better local to the web application, although it can work with network file systems (the users themselves can be anywhere). - jfs
  • one
    @ MikhailAlekseevich That's just the point, what it says about bugs in locking files in the network file systems themselves. I just did not get the whole translation in the comments. There is nothing dependent on the database developer. - Dmitry
  • one
    @ Dmitry, in this case, your GUI program can write / read data by making requests to the server, which is next to the database (you should not open the database on the Internet), for example, using the REST API or GraphQL. - jfs

0