I have a nice solution that really works well, at least from C...
1. Create a template Database. (using whatever method you like, either
embedded in your code or via sqlite3).
2. Copy the database to a new file, using plane old cp, copy, or if you
like an in code copy using open, read/write, close... Then open the newly
created copy.
I've found that if you need mulitples of a single database structure this is a
very fast way to do this, a lot faster than creating the DB and then creating
the individual tables/indices.
If you want really, really fast, you could load your templated db into memory
and then just write this to disk whenever you need a new DB.
Kees Nuyt <[EMAIL PROTECTED]> wrote: On Fri, 29 Dec 2006 12:33:46 -0500, you
wrote:
> Sqlite3 newdatabase.db .read schemafile.txt
>
> But, when I issue this command from the DOS prompt,
> it gives me an error message saying that there
> is no command named "read".
Try input redirection:
Sqlite3 newdatabase.db
If your schemafile.txt contains valid SQLite statements, it
should work.
HTH
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
