Re: [sqlite] is there any way for create a sqlite blob field with python?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/16/2010 11:35 AM, Fabio Spadaro wrote: > You can also determine the path and file name from the blob or should I > create a column attached with this information stored? You are overthinking this. A blob is just a collection of bytes in the

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/16 Roger Binns > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/16/2010 04:14 AM, Fabio Spadaro wrote: > > But the next time I select a single line instead of two: > > fetchall [( > 0x02CC2A30>,)] > > > > What's wrong. > > Errr, nothing.

Re: [sqlite] is there any way for create a sqlite blob field with python?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/16/2010 04:14 AM, Fabio Spadaro wrote: > But the next time I select a single line instead of two: > fetchall [( 0x02CC2A30>,)] > > What's wrong. Errr, nothing. Blobs are returned as buffers too. (This way you can distinguish them

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/15 Roger Binns > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/15/2010 01:46 PM, Fabio Spadaro wrote: > > I am developing an interface to Python 's SQLite and would it be > > you can store files in the sqlite database. To do this > > obviously need

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi, 2010/6/16 Fabio Spadaro > Hi > > 2010/6/15 Roger Binns > > -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 06/15/2010 01:46 PM, Fabio Spadaro wrote: >> > I am developing an interface to Python 's SQLite and would it be >> > you can

Re: [sqlite] is there any way for create a sqlite blob field with python?

Hi 2010/6/15 Roger Binns > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/15/2010 01:46 PM, Fabio Spadaro wrote: > > I am developing an interface to Python 's SQLite and would it be > > you can store files in the sqlite database. To do this > > obviously need

Re: [sqlite] is there any way for create a sqlite blob field with python?

On 15 Jun 2010, at 10:26pm, Roger Binns wrote: > On 06/15/2010 02:16 PM, Simon Slavin wrote: >> An image file is just a file. If you really want to store a file in a >> database, open the file, read the contents, and store what you read in a >> BLOB field. > > That is the general correct

Re: [sqlite] is there any way for create a sqlite blob field with python?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 02:16 PM, Simon Slavin wrote: > An image file is just a file. If you really want to store a file in a > database, open the file, read the contents, and store what you read in a BLOB > field. That is the general correct answer but not

Re: [sqlite] is there any way for create a sqlite blob field with python?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/15/2010 01:46 PM, Fabio Spadaro wrote: > I am developing an interface to Python 's SQLite and would it be > you can store files in the sqlite database. To do this > obviously need to create a blob field but how to store image files? If you are

Re: [sqlite] is there any way for create a sqlite blob field with python?

On 15 Jun 2010, at 9:46pm, Fabio Spadaro wrote: > I am developing an interface to Python 's SQLite and would it be > you can store files in the sqlite database. To do this > obviously need to create a blob field but how to store image files? An image file is just a file. If you really want to

[sqlite] is there any way for create a sqlite blob field with python?

Hi all. I am developing an interface to Python 's SQLite and would it be you can store files in the sqlite database. To do this obviously need to create a blob field but how to store image files? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users