Thanks First i realized i hadn't the latest sqlite (gotta upgrade)... My project starts well ;)
I wanted to know: Is it best: - to create the table on-the-go: whenever a new column is needed, i add it and fill the data. The previous entries (which never needed this column) are NULL ? - my second option is to parse a lot of files and decide i have quite a good representation, i create the table once and for all, and fill the entries. Is it possible to progressively (i.e. with several distinct requests) fill a line (entry)? Is it possible to easily create additional columns? Is it possible to reorder columns? I'm beginning to think that sqlite (and maybe sql in general) is very single-request-oriented, and not progressive-construction-oriented. Do you know any related technology that would fit my needs, except than using native memory tables (! memory use)? Thanks Regards Florent On 11/14/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 11/13/06, Florent THIERY <[EMAIL PROTECTED]> wrote: > - check first if the column already exists; that, i have no idea how to > achieve it Hello Florent, Try this: select * from sqlite_master; This gives a lot of interesting info about tables and indices. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
