Re: [sqlite] Slow performances with COLLATE NOCASE

On 21/nov/06, at 17:07, Christian Smith wrote: Sergio 'OKreZ' Agosti uttered: Hi, I've a performance problem with an application written in realbasic, using a sqlite db: some of the tables have UNIQUE fields, and I've no problem with the default COLLATE mode (BINARY); but if I set

Re: [sqlite] Inserting uniquely

, it will work. But I dont want sqlite to throw error] How can I get this done? If you use INSERT OR IGNORE INTO table... you won't get any error thrown by sqlite --- Sergio 'OKreZ' Agosti --- icq: 112421063 msn: [EMAIL PROTECTED] skype: sergio.agosti iChat

Re: [sqlite] Enhancing decltype()?

, as many email clients (like Apple Mail) organize messages in threads by 'In-Reply-To' header, not only by subject... thanks :) --- Sergio 'OKreZ' Agosti --- icq: 112421063 msn: [EMAIL PROTECTED] skype: sergio.agosti iChat: sergio.agosti jabber: sergio.agosti

Re: [sqlite] Tool to find out the memory usage of a program

see options of ps (man ps) I want to find out the total and the peak memory usage of a program(in Linux) or try with 'top' --- Sergio 'OKreZ' Agosti --- icq: 112421063 msn: [EMAIL PROTECTED] skype: sergio.agosti iChat: sergio.agosti jabber: sergio.agosti

Re: [sqlite] Database on usbstick

actually is the path to the database file --- Sergio 'OKreZ' Agosti --- icq: 112421063 msn: [EMAIL PROTECTED] skype: sergio.agosti iChat: sergio.agosti jabber: sergio.agosti

Re: [sqlite] Getting Started With SQLite3

On 01/set/06, at 15:16, Rich Shepard wrote: Is there a way to write SQL statements that perform the same referential integrity checks as if foreign keys were available for constraints? http://www.rcs-comp.com/site/index.php/view/Utilities- SQLite_foreign_key_trigger_generator