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 support BLOB, or maybe other way to access
blob without ODBC?
I cannot help you with ODBC, but if you have an embedded sqlite database
you may be much better off to use the Sqlite API directly rather
than SQL/CLI (ODBC). The Sqlite API handles BLOBs very effectively.
Even if you use something like VB you can find an interface (wrapper)
for the Sqlite API which will work effectively.
You should be aware that Sqlite is not a DBMS server like Sql Server,
Oracle or DB2, it is a library of routines to embed in your application.
If you use it that way the ODBC route does not make much sense and you
lose much of the simplicity of Sqlite.
An Sqlite database is just a single file, so you can see how simple that
makes managing your application. Backups and recovery are so simple.
Distribution of databases cannot be simpler.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
