@sqlite.org
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 domestrating ?
I am puzzled by this topic, how does a music file be sotred in DB as BLOB
type?
You can insert /any
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
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
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
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
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
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
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
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.
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
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 MP3. It
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
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 item
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
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
] 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
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
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 other
18 matches
Mail list logo