Thanks all for the info. I'm still doing thought wrestling on the path I want to take.
On one hand, its brain dead simple for me to go the tokenizer route and have my application dynamically generate the SQL string, I just don't like that kind of code style as there are many faults with it, especially with how the wrapper deals with binding and user provided data. On the other hand, since at least one of my dev environments has the tools already to do a Windows build of the amalgamation, I can write out a batch file so that the DLL is built on a whim, with the required extensions at the ready. The magic touch is to find out how to get my source code in the wrapper to handle the new kind of DLL naming (Since I don't want a generic SQLite3.dll being in multiple places that do different jobs) while the exact same wrapper code CAN handle SQLite3.dll. Much more work, but later on, might be useful for other aspects. The last rabbit out of the hat is to modify the installer to put the new DLL in the application directory instead of System32/Wherever, but that's easier to correct than doing the tokenizer. @Jens; Although there are pay for, and free to use, libraries that can be linked into my applications, I've never been satisfied with the code provided. Often times, it has so many dependencies on stuff that isn't required that I'm just not going to put into my code. Not to mention, the routines that they provide are limited in some fashion that just isn't compatible with my mindset. The one library I did find ( http://www.itwriting.com/blog/articles/a-simple-delphi-wrapper-for-sqlite-3 ), and was easily able to modify for my own purposes, however, requires external DLLs. I've tried taking the amalgamation and convert it into something that I can directly embed into my applications (Which would be great), but, I've yet to be successful. Obviously it can be done, but, I've not been able to do it on my own. On Fri, Nov 10, 2017 at 8:03 PM, Jens Alfke <j...@mooseyard.com> wrote: > > >> On Nov 10, 2017, at 6:50 AM, Peter Da Silva <peter.dasi...@flightaware.com> >> wrote: >> >>> I'm using the amalgamation by default, so I don't think FTS is in the DLL. >>> I can recompile, but that now introduces complications on machines that may >>> not have this exact DLL. (A couple people in my company use this app) >> >> The same problem would presumably apply to the regex extension... not all >> users would have that extension. > > What platform is this for? Apple platforms ship with SQLite libraries that > include FTS (not sure about regex, but it’d be easy to check.) > > On other platforms, you can just statically link SQLite into your application > and not have to worry what version or configuration might be on the user’s > machine. > > —Jens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
