Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
My idea was to fill up that base, and afterwards exploit the data: i want to be able to find the most recurrent profiles. Are there complex statistical tools that would work with sqlite's data format ? Or am i forced (as i suppose) to do everything? I'm particularly looking for market-partitioning

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Trevor Talbot
On 11/14/06, Florent THIERY <[EMAIL PROTECTED]> wrote: If i follow your saying, it would be best to create a new table when i encounter a new file-structure scheme, but keep a general purpose table with minimal and univeral information. Just to clarify, for simple key-value style headers I mea

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
If i follow your saying, it would be best to create a new table when i encounter a new file-structure scheme, but keep a general purpose table with minimal and univeral information. That's a great idea :) Thanks It allows me to distinguish clearly the types of organization. Will require more sql

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Trevor Talbot
On 11/14/06, Florent THIERY <[EMAIL PROTECTED]> wrote: 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

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-14 Thread Florent THIERY
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 secon

Re: [sqlite] Newbie sqlite questions: check existence of column

2006-11-13 Thread Jay Sprenkle
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

[sqlite] Newbie sqlite questions: check existence of column

2006-11-13 Thread Florent THIERY
Hi First of all i must say i'm pretty much impressed of how easy it is to buid a sqlite db up within minutes/hours of work. I'm... amazed :) Still, i'm lacking answears. My (soon-to-be-open-source-when-there-will-be-interesting-source-to-open) project is the following: i scan for files recursi