Re: [sqlite] Music Files

2006-11-29 Thread LuYanJun
urn mpBuf; } - Original Message - From: "Isaac Raway" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 28, 2006 11:04 PM Subject: Re: [sqlite] Music Files > On 11/27/06, LuYanJun <[EMAIL PROTECTED]> wrote: >> >> Can anybody give a simple example for domest

Re: [sqlite] Music Files

2006-11-28 Thread John Stanton
I cannot be much help since we never use VB or other similar proprietary software prisons. However I did see this set of notes from someone who was using Sqlite from VB and created a modified sqlite.h. http://www.persistentrealities.com/index.php?p=18 If you don't already have a lot of VB cod

Re[2]: [sqlite] Music Files

2006-11-28 Thread made hendra
Hello John, Wednesday, November 29, 2006, 1:08:56 AM, you wrote: > Here are a couple of links to get you started. I suggest you google > your way until you find something which suits you. > http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers > http://www.freevbcode.com/ShowCode.asp?ID=6893 I

Re: [sqlite] Music Files

2006-11-28 Thread John Stanton
Here are a couple of links to get you started. I suggest you google your way until you find something which suits you. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers http://www.freevbcode.com/ShowCode.asp?ID=6893 made hendra wrote: Thanks John, Btw, i'm not a sqlite advance nor vb. I'm n

Re[2]: [sqlite] Music Files

2006-11-28 Thread made hendra
Thanks John, Btw, i'm not a sqlite advance nor vb. I'm not fully understand about vb wrapper. I always using ODBC to create database connection. Any suggest or clue? where i can find vb wrapper for sqlite(3). Tuesday, November 28, 2006, 11:11:04 PM, you wrote: > I cannot help you with ODBC, but

Re: [sqlite] Music Files

2006-11-28 Thread John Stanton
made hendra wrote: Hello John, Tuesday, November 28, 2006, 4:08:58 AM, you wrote: 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? Write them as a BLOB. Are there Sqlite ODBC that suppor

Re: [sqlite] Music Files

2006-11-28 Thread Isaac Raway
On 11/27/06, LuYanJun <[EMAIL PROTECTED]> 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? You can insert /any/ kind of data into a SQLite database (or most any other sort of DB for that matter). Here's

Re: [sqlite] Music Files

2006-11-28 Thread John Stanton
ect: 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 t

Re[2]: [sqlite] Music Files

2006-11-27 Thread made hendra
Hello John, Tuesday, November 28, 2006, 4:08:58 AM, you wrote: > 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? > Write them as a BLOB. Are there Sqlite ODBC that support BLOB, or maybe ot

Re: [sqlite] Music Files

2006-11-27 Thread Lloyd
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: > Sent: Saturday, October 28, 2006 4:35 AM > Subject: Re: [sqlite]

Re: [sqlite] Music Files

2006-11-27 Thread LuYanJun
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: Sent: Saturday, October 28, 2006 4:35 AM Subject: Re: [sqlite] Mu

Re: [sqlite] Music Files

2006-11-27 Thread Alex Roston
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

Re: [sqlite] Music Files

2006-11-27 Thread John Stanton
If you have BLOBs over 2GB in size you would not be storing them in some form of library or archive like Sqlite. You would want to use a more efficient storage mechanism with faster access, such as a directory of files. For storing modestly sized images and sound files and accessing them in

Re: [sqlite] Music Files

2006-11-27 Thread Nicolas Williams
On Mon, Nov 27, 2006 at 02:40:44PM -0600, John Stanton wrote: > You store them in the DB as a BLOB type, but save the data as a JPEG, > MP3, WAV or whatever it happens to be. The binary data resides as a DB > column and the same row may have other columns which could be text to > describe the i

Re: [sqlite] Music Files

2006-11-27 Thread John Stanton
You store them in the DB as a BLOB type, but save the data as a JPEG, MP3, WAV or whatever it happens to be. The binary data resides as a DB column and the same row may have other columns which could be text to describe the item or a number to store the size etc. sebcity wrote: Ok,so just sa

Re: [sqlite] Music Files

2006-11-27 Thread sebcity
Ok,so just save them as BLOB files? Igor Tandetnik wrote: > > sebcity <[EMAIL PROTECTED]> 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? > > SQLite does not know anything nor care about music or

Re: [sqlite] Music Files

2006-11-27 Thread John Stanton
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? Write them as a BLOB. - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Music Files

2006-11-27 Thread sebcity
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? -- View this message in context: http://www.nabble.com/Music-Files-tf2714035.html#a7566722 Sent from the SQLite mailing list archive at Nabble.com. -