On Tue, 27 Aug 2019 at 21:57, Peng Yu wrote:
> I haven't found an archive format that allows in-place delete (I know
> that .zip, .7z and .tar don't). This means that whenever delete is
> needed, the original archive must be copied first. This can be
> problematic when the archive is large and
On 8/27/19, Jens Alfke wrote:
> is [SQLite] engineered with the
> assumption that a database file may be malicious, or is the assumption
> "garbage in, garbage out"?
https://www.sqlite.org/security.html
https://www.sqlite.org/testing.html
Our intent is that SQLite database files are secure in
On Tuesday, 27 August, 2019 14:40, Jens Alfke wrote:
>> On Aug 27, 2019, at 12:21 PM, Keith Medcalf wrote:
>> Everything that has been touched by a third-party is inherently
>> untrustworthy. Thus it is and thus it has always been.
> Yes. I have a lot of experience with network coding and
> On Aug 27, 2019, at 12:21 PM, Keith Medcalf wrote:
>
> Everything that has been touched by a third-party is inherently
> untrustworthy. Thus it is and thus it has always been.
Yes. I have a lot of experience with network coding and security, so I'm aware
of this, thanks. My question
On Tuesday, 27 August, 2019 12:47, Jens Alfke wrote:
>Archive files often get transferred between people. Using this format
>for that purpose would involve opening and reading untrusted SQLite
>database files. Is that safe? Could maliciously corrupting the schema
>or other metadata of a
On 27 Aug 2019, at 7:47pm, Jens Alfke wrote:
> Archive files often get transferred between people. Using this format for
> that purpose would involve opening and reading untrusted SQLite database
> files. Is that safe? Could maliciously corrupting the schema or other
> metadata of a database
> On Aug 27, 2019, at 7:06 AM, Philip Bennefall wrote:
>
> There is the sqlar archive format, which you can test using the official
> sqlite3 command line shell. There is also a library for it as part of the
> Sqlite3 repository.
"An SQLite Archive is an ordinary SQLite database file that
> The standard "sqlite3" command-line tool will read and write SQLite
> archive files. See the documentation at
> https://www.sqlite.org/sqlar.html#managing_an_sqlite_archive_from_the_command_line
OK. So there is basically no need to install the sqlar command since
all features from the sqlar
The earliest version of the shell which ships with the archive support
is 3.22.0, according to the page I linked to. If you have an earlier
version you could simply grab the Mac OSX precompiled binaries from the
download page on sqlite.org and you'll be good to go.
Kind regards,
Philip
On 8/27/19, Peng Yu wrote:
>
> How to install it? In homebrew's sqlite package, I don't find sqlar. I
> use Mac OS X.
>
The standard "sqlite3" command-line tool will read and write SQLite
archive files. See the documentation at
> There is the sqlar archive format, which you can test using the official
> sqlite3 command line shell. There is also a library for it as part of
> the Sqlite3 repository.
>
> https://www.sqlite.org/sqlar.html
> https://sqlite.org/sqlar/doc/trunk/README.md
This is good to know.
How to install
https://sqlite.org/sqlar/doc/trunk/README.md
On Tue, Aug 27, 2019 at 3:57 PM Peng Yu wrote:
> Hi,
>
> I haven't found an archive format that allows in-place delete (I know
> that .zip, .7z and .tar don't). This means that whenever delete is
> needed, the original archive must be copied first.
There is the sqlar archive format, which you can test using the official
sqlite3 command line shell. There is also a library for it as part of
the Sqlite3 repository.
https://www.sqlite.org/sqlar.html
Kind regards,
Philip Bennefall
On 8/27/2019 3:56 PM, Peng Yu wrote:
Hi,
I haven't found
Hi,
I haven't found an archive format that allows in-place delete (I know
that .zip, .7z and .tar don't). This means that whenever delete is
needed, the original archive must be copied first. This can be
problematic when the archive is large and the file to delete is small.
Something along the
14 matches
Mail list logo
