> I don't know a way to write binary data to a file using the
> command-line tool. Maybe there's one out there someone else knows of.
The SQL functions readfile and writefile mayhaps?
They have to be loaded as an extension (or compiled into) to lib/dll if you
want them there.
On 29 Apr 2016, at 3:00am, James K. Lowden wrote:
> I don't know a way to write binary data to a file using the
> command-line tool. Maybe there's one out there someone else knows of.
Nobody else knew of a way either, so one was specially introduced into a recent
version. On this page
On 2016/04/28 8:27 PM, deltagamma1 at gmx.net wrote:
> What is a convenient way to store the path from a external blob (jpg,
> pdf) ?
> How can I retrieve this blob ?
> Is there a Frontend which opens the jpg directly from the listed
> table-content ?
>
> If I store the blob directly in the
On Thu, 28 Apr 2016 20:27:17 +0200
"deltagamma1 at gmx.net" wrote:
> If I store the blob directly in the sqlite, is there a way to open the
> blob directly with the respective programm (e.g. irfanview or a pdf
> with acroread) ?
I have heard of a FUSE filesystem implemented with SQLite. I
What is a convenient way to store the path from a external blob (jpg,
pdf) ?
How can I retrieve this blob ?
Is there a Frontend which opens the jpg directly from the listed
table-content ?
If I store the blob directly in the sqlite, is there a way to open the
blob directly with the respective
I strongly recommend that you store a SHA-256 hash (or pick a better hash
algorithm if there is one) of the file content as a blob in the database as the
canonical way to identify the file. This is much more reliable than doing it
with the file's name, and any filename info can then be
Semantics and methodology of use aside, SQLite is the same as MySQL, MSSQL,
Access, etc, in that it is a tool to store and retrieve bytes in a
retrievable way via some kind of structured language. None of mentioned
tools actually do any sort of presentation of said data. "From the
factory",
7 matches
Mail list logo