Re: [sqlite] Why do you use SQLite? Comments for an article needed

John Elrick wrote: Tim Anderson wrote: I'm writing an article about SQLite and I'd love to get some comments from users about why you use it. Performance? Features? Reliability? Cost? Is the open source aspect important? Anything else? For that matter, anything you really don't like about

Re: [sqlite] Table question

My ideea was to create some database structure where some tables would store the real data (the actual values of the columns) and some other tables that have the values i need to work with calculated based upon the data stored in the first tables. Triggers seem the way to go, but i was

[sqlite] Table question

Is there a way o creating tables that have fields that are expressions rather than values? Those expresions would return a value based on values stored in other fields of some other table (or the same table if that's necessary).

Re: [sqlite] Create table IF NOT EXISTS

Sripathi Raj wrote: Hi, Is the IF NOT EXISTS constraint supported? When I try to use it, I get an error message saying that there is a syntax error at 'NOT'? I'm using Sqlite 3 on Windows and I'm trying to connect to it from Perl. Thanks, Raj I can't use it either..same error so i

Re: [sqlite] Re: Fields update notification

On 2/28/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > > CREATE TRIGGER > http://sqlite.org/lang_createtrigger.html > > Igor Tandetnik > Great! Thanks. (I should have mentionded that this was a beginners question)

[sqlite] Fields update notification

Is there a way to track changes performed on a table? What i need is a way of knowing when an insert/update has been issued on a table so that i can read the new values.

Re: [sqlite] Creating a (really) big table

Jay Sprenkle wrote: On 2/10/06, Fred Williams <[EMAIL PROTECTED]> wrote: Well, unfortunately our bid'ness seems to be a "contact sport" for many. I have been guilty of pretty much the same more times than I am proud of. That said... The question is quite valid. I do agree that something

Re: [sqlite] Re: How to read column names

Igor Tandetnik wrote: Eugen Stoianovici wrote: Is there a way of reading the names of the columns in a table? how about the table names in a data base? select * from sqlite_master where type='table' pragma table_info(table_name); Igor Tandetnik Thanks

[sqlite] How to read column names

Is there a way of reading the names of the columns in a table? how about the table names in a data base?

Re: [sqlite] SQLite usage (a project management question)

Sorry for that question...after two days with no sleep it seemd resonable. After six hours of sleep, i seem to think more clearly. John Stanton wrote: You don't have much text so you can easily take your choice, flat file or DBMS. The decision would be one based on how you intend to use the

[sqlite] SQLite usage (a project management question)

I need some help...I'm writing an app which scans some pictures and then performs ocr on those pictures saving a text buffer(around 50 bytes long) for later processing. This application will scan around 500 pages/day (hopefully) and the ocr info should remains stored for about 2 months. Here