Re: [sqlite] strip off file metadata in sqlar

2019-08-28 Thread Dominique Devienne
On Tue, Aug 27, 2019 at 11:46 PM Peng Yu wrote: > I just need the return status of sqldiff (as `cmp -s`). Is there an > option to suppress all the screen output? Thanks. > https://www.sqlite.org/cgi/src/artifact/7b9b7238284f0213 Doesn't look like it does. But redirecting to /dev/null or NUL wou

Re: [sqlite] strip off file metadata in sqlar

2019-08-27 Thread Peng Yu
I just need the return status of sqldiff (as `cmp -s`). Is there an option to suppress all the screen output? Thanks. On 8/27/19, Warren Young wrote: > On Aug 27, 2019, at 2:40 PM, Peng Yu wrote: >> >> Where is the binary or source code of sqldiff? > > The source is part of the complete SQLite s

Re: [sqlite] strip off file metadata in sqlar

2019-08-27 Thread Warren Young
On Aug 27, 2019, at 2:40 PM, Peng Yu wrote: > > Where is the binary or source code of sqldiff? The source is part of the complete SQLite source tree: https://www.sqlite.org/cgi/src/doc/trunk/README.md (As opposed to the amalgamation.) You will then find it in tool/sqldiff.c, and you can b

Re: [sqlite] strip off file metadata in sqlar

2019-08-27 Thread Peng Yu
Where is the binary or source code of sqldiff? I don't find sqldiff in the package sqlite installed in homebrew. I also don't find sqldiff after compiling sqlite-autoconf-329.tar.gz. > https://www.sqlite.org/sqldiff.html -- Regards, Peng ___ sqlit

Re: [sqlite] strip off file metadata in sqlar

2019-08-27 Thread Warren Young
On Aug 27, 2019, at 9:21 AM, Peng Yu wrote: > > The .sqlar files contain file metadata. I'd like two .sqlar files to > be exactly the same (`cmp` should return 0) when they store the same > content. Is it possible to strip off all metadata of stored files? [XY Problem][1]. Try sqldiff instead:

[sqlite] strip off file metadata in sqlar

2019-08-27 Thread Peng Yu
The .sqlar files contain file metadata. I'd like two .sqlar files to be exactly the same (`cmp` should return 0) when they store the same content. Is it possible to strip off all metadata of stored files? Thanks. $ sqlite3 my.sqlar -Atv -rwxr-xr-x181 2019-08-27 15:18:27 main.sh -- Rega