how do i store audio files in sqlite3 database and play them in iphone?

Question

i want to store audio files(any of these formats mp3,wav,and iphone supported) in database and play them in iphone...any idea how to do this?

Answer 1

I don't know why you would want to store the audio files in a SQL database but sqlite3 supports BLOB. So store them as BLOB and retrieve them.

Alternatively why not store references to the files that you want to play?

Answer 2

In general it's best to not store binary files in any database. You are better off writing that file to the disk as a file and then storing the path in the database.