Hi, I am in need of some new SQL functions and wanted to ask advice on the best way to integrate these functions into SQLite 3. I am not a proficient C coder unfortunately.
I have compiled the source for 3.5.5 using Visual Studio.NET 2003 and all works fine. I have added a couple of simple functions into func.c and these work. Great so far. However it would be good if there were a project somewhere to collate extension functions into a set of C files to enable a more powerful version of SQLite. I have found a few already on the web. Eg. http://www.brayden.org/twiki/bin/view/Software/SqliteExtensions#SQLite_Extensions What I am looking for specifically are more powerful string manipulation functions that mimic Microsoft SQL Server. In order of importance: charindex - This one is a show stopper for me. Need this function badly. patindex ltrim rtrim replace difference (integer diff on soundex values) What is the best way forward? Have someone develop these and add them directly to func.c or (to aid upgrading) create a new source and header file and add them to the project? How can new functions be added without removing the ability to upgrade the source to 3.5.6 etc when patches are released to func.c? Does anyone know how these string functions might be implemented? Any help appreciated. Thanks, Mike -- View this message in context: http://www.nabble.com/Extra+functions+-+New+Project--t1674436.html#a4539325 Sent from the SQLite forum at Nabble.com.
