Re: [sqlite] Is there a way to yield an error when opening a nonexistent dbfile?

You could use the second method (opening the file by handle) if you do not want your code to be portable. Yes, APSW is far superior to sqlite3. It does not have any "magic" and wraps SQLite3 into Python so that it works like SQLite3 works, so the interface works as documented for the

Re: [sqlite] Is there a way to yield an error when opening a nonexistent dbfile?

What is the recommended way to do so in python? I see the following two ways. ``` db = sqlite3.connect('file:/path/to/database?mode=ro', uri=True) fd = os.open(filename, os.O_RDONLY) c = sqlite3.connect('/dev/fd/%d' % fd) os.close(fd) ```

Re: [sqlite] Is there a way to yield an error when opening a nonexistent dbfile?

On Fri, 31 Jan 2020 09:02:10 -0600, Peng wrote: > Hi, > > By default the command sqlite3 will just open a dbfile if it does not exist. > > Suppose that I just want to perform read-only operations in a sqlite3 > session, I will not need to create a non-exsitent file. Rather, I want > the sqlite3

[sqlite] Is there a way to yield an error when opening a nonexistent dbfile?

Hi, By default the command sqlite3 will just open a dbfile if it does not exist. Suppose that I just want to perform read-only operations in a sqlite3 session, I will not need to create a non-exsitent file. Rather, I want the sqlite3 to fail when the dbfile does not exist. Is there a way to