Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-25 Thread Jens Alfke
> On Oct 25, 2017, at 8:54 AM, Peter Da Silva > wrote: > > Another question I have is... is an SQLITE database the best format for > exposing your data to other applications? Yes, it’s a common document format. Whether it’s “the best” is clearly dependent on the type of data and how it’s us

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-25 Thread Peter Da Silva
On 10/25/17, 11:18 AM, "sqlite-users on behalf of Richard Hipp" wrote: > On 10/25/17, Peter Da Silva wrote: > > Another question I have is... is an SQLITE database the best format for > > exposing your data to other applications? > Yes, it's the best format. Peter, were you not paying attenti

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-25 Thread Richard Hipp
On 10/25/17, Peter Da Silva wrote: > > Another question I have is... is an SQLITE database the best format for > exposing your data to other applications? > Yes, it's the best format. Peter, were you not paying attention during my talk at the Tcl conference last week? :-) -- D. Richard Hipp d.

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-25 Thread Peter Da Silva
On 10/25/17, 10:42 AM, "sqlite-users on behalf of Arno Gramatke" wrote: >Jens, Simon, > > thanks for your feedback and suggestions. I will take a closer look at > keeping a "shadow“ copy in the current location and copy the file to the > Documents folder when needed. That seems to be a fea

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-25 Thread Arno Gramatke
Jens, Simon, thanks for your feedback and suggestions. I will take a closer look at keeping a "shadow“ copy in the current location and copy the file to the Documents folder when needed. That seems to be a feasible approach, especially with what Jens wrote about APFS and its copy-on-write suppo

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-24 Thread Jens Alfke
> On Oct 24, 2017, at 8:14 AM, Arno Gramatke wrote: > > My first naive approach was to figure out, which commands will result in a > read and which will result in a write to the db file. I think you’ll need to assume that any SQLite access can both read and write the file. So at a high leve

Re: [sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-24 Thread Simon Slavin
On 24 Oct 2017, at 4:14pm, Arno Gramatke wrote: > These single files should be placed in the app’s „Documents“ folder, making > them accessible from other apps or the Files.app when allowed by the user. > With the single db file from above it was only ever our app to access this > file and we

[sqlite] SQLite on iOS with NSFilePresenter/NSFileCoordinator

2017-10-24 Thread Arno Gramatke
Hi all, in an iOS app we have been storing multiple user „documents“ (hierarchical data mostly, but some larger blobs (~2MB) as well) in a single data base file, that was stored in the app’s "Application Support“ folder. That has worked without problems so far. Since iOS 11 we would like to gi