A BLOB is just a block of indeterminate, untyped data. You reference it
by a pointer and a length and recover it the same way. Sqlite will
store it as a linked list of pages.
Think of it as a file, which is a pointer and a length, stored by the
file system as a group or a group of groups of linked disk sectors.
When you open a file and memory map it you get a pointer and a length
for the file, that is compatible with a BLOB. When you recover a BLOB
you can write it to a file using a write API call, which has as its args
a file descriptor to an open file, a pointer and a length.
LuYanJun wrote:
Can anybody give a simple example for domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB type?
TKS.
----- Original Message -----
From: "Alex Roston" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, October 28, 2006 4:35 AM
Subject: Re: [sqlite] Music Files
At one point there was a project that did something like this, and it
was called Route66. I think it used mysql, perl and a player called
splay. You might google it.
Alex
sebcity wrote:
Is it possible to store mp3 files in a SSQLite database? would they be able
to be played from the database? How would you save them?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------