Re: [sqlite] Saving PDF Files in SQlite

[David King]

> How do I save PDF files in SQLIte?

Why do you want to store PDF files in sqlite? What is the "real" problem that 
that solves for you?

There is http://www.sqlite.org/sar/doc/trunk/README.md which does what you're 
literally asking, but I feel that with more context we can give you better 
direction



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Saving PDF Files in SQlite

[tonyp]

From the SQLite3 shell (recent version), use the readfile('filename') 
function to import into a blob field, and the writefile('filename',field) 
for exporting back to a file.


See here: http://www.sqlite.org/cli.html

-Original Message- 
From: John Payne

Sent: Thursday, January 15, 2015 10:24 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Saving PDF Files in SQlite



How do I save PDF files in SQLIte? Is there a preferred method? All the
online suggestions seem to require writing some custom code. Is there an
add-on for saving PDF or other digital objects? I'm not a programmer, do
not know php and rather clueless on how to proceed.

Thanks

John Payne
j...@pde-usa.net
630-815-8849

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Saving PDF Files in SQlite

[Simon Slavin]

On 15 Jan 2015, at 8:24pm, John Payne  wrote:

> How do I save PDF files in SQLIte?

Read the bytes of the file and save them in a BLOB field.

But I have to warn you ...

> I'm not a programmer,

SQLite is a tool for programmers.  It makes database facilities available to 
programmers.  It's not designed for people who know only how to use programs.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Saving PDF Files in SQlite

[John Payne]

 

How do I save PDF files in SQLIte? Is there a preferred method? All the
online suggestions seem to require writing some custom code. Is there an
add-on for saving PDF or other digital objects? I'm not a programmer, do
not know php and rather clueless on how to proceed. 

Thanks 

John Payne
j...@pde-usa.net
630-815-8849
 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users