Regarding:
sebcity <[EMAIL PROTECTED]> wrote:
> ... After you create your tables how do you save them so
> they are permenently there?
And Igor T's reply:
They are "permanently there" from the very moment you create them. All
changes are written to the database file when a >>transaction is
committed, or at the end of every statement if you don't open any
transactions explicitly.
However, if you are using the command shell for sqlite, you must provide
the name of your database file (even a new filename) when you invoke it.
Otherwise, the tables are created in volatile RAM.
E.g.
sqlite Mydata.db
instead of just
Sqlite
Regarding storing MP3 data:
One answer might be: Yes, you can use BLOBs, but you may be better
off using SQLITE just to *index* existing mp3 files.
But I suspect a better answer is: Unless you're familiar with
using SQL databases, you may find that you're better off using an
application already designed for indexing mp3 files, since SQLITE is a
great little database for *building* applicates, but not an application
itself.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
