[sqlite] Interference between my md5 extension and SQLite tests code

Hello! I did create md5 extension with functions md5() and md5sum() based on test_md5.c. But "make test" return errors with this extension. How may it be fixed? And why did not included md5 functions in SQLite core with SQLITE_MD5 define (as SQLITE_SOUNDEX for example)? Best regards, Alexey.

Re: [sqlite] need examples of sqlite interface for c

"baxy77bax" wrote in message news:21519820.p...@talk.nabble.com > i'm a perl programmer who needs some examples (basic and complete and > functional) of c programming code that interface with sqlite. > something like >> > > 1. connect to the database xy sqlite3* db; sqlite3_open("/path/to/xy", &d

Re: [sqlite] Problem with indexes and speed

"Mike Martin" wrote in message news:ecc841d80901170913rc46c75dhfc5eefc6c25f...@mail.gmail.com > Is it possible to do an index on a substring of a field > eg: subtr(start,10) to get just the day No, SQLite can't do that. Igor Tandetnik ___ sqlite-use

[sqlite] need examples of sqlite interface for c

hi , i'm a perl programmer who needs some examples (basic and complete and functional) of c programming code that interface with sqlite. something like : 1. connect to the database xy 2. create a table xz 3. index a table (create index r1 on ...) 4. insert data that c program is producing into

Re: [sqlite] Problem with indexes and speed

Thanks for that Is it possible to do an index on a substring of a field eg: subtr(start,10) to get just the day On 17/01/2009, Igor Tandetnik wrote: > "Mike Martin" wrote > in message > news:ecc841d80901170714l745078a4uf228f9c8a584f...@mail.gmail.com >> The following query runs in around 10 se

Re: [sqlite] Problem with indexes and speed

"Mike Martin" wrote in message news:ecc841d80901170714l745078a4uf228f9c8a584f...@mail.gmail.com > The following query runs in around 10 secs with no indexes, however if > I index the start field (datetime) it takes around 10 minutes + > Select guide.id,channels.Channel,start,start,name,stop,stop,c

[sqlite] Problem with indexes and speed

Hi I have a relatively simple DB with sqlite 3.5.6 The following query runs in around 10 secs with no indexes, however if I index the start field (datetime) it takes around 10 minutes + Select guide.id,channels.Channel,start,start,name,stop,stop,cat0 from guide join channels on pnr=ind left join

[sqlite] How can I redefine NOCASE collation

Hello! I'm using in sqlite3IcuInit this code /* register russian collation as NOCASE */ UErrorCode status = U_ZERO_ERROR; UCollator *pUCollator;/* ICU library collation object */ pUCollator = ucol_open("ru_RU", &status); if( !U_SUCCESS(status) ){ return SQLITE_ERROR; } rc