-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tim Romano wrote:
> I respectfully disagree, Roger, about the simplicity.  Creating an 
> external DLL would complicate my distribution scenario significantly 
> because I'll  have just as many users of my little database application 
> working with Apple OSX as with Windows.  I guarantee you, it would be
> easier for the very skilled programmers at SQLite to set these functions 
> up to be included|excluded by throwing a few compiler switches (as they 
> do for soundex() )  than for me to make my own external library for both 
> OSX and Windows platforms. Basing that strictly on my own set of limited 
> competencies.

You don't have to get the code in the SQLite core.  If you don't have the
inhouse expertise then you can pay/convince anyone/someone else to do the
work you want.  The APIs are simple, the extension mechanism is simple and
the documentation is excellent.

  http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions

(I just updated the build instructions on that page)

Even if the functionality was added to the SQLite core, it would take a
considerable amount of time until OSX included that updated code.  You still
have the issue that the code would likely be excluded by default just as
soundex is, so it would still require re-compiling SQLite.  It is easier to
compile an extension module than to recompile SQLite.  In addition the
extension module would work with more versions of SQLite.

> BTW, the Microsoft SQL Server 2000 reverse() function does it codepoint 
> by codepoint,

And this exactly why it is better that you have control over the extension
code.  You can make it work exactly the way you want.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAksEgOAACgkQmOOfHg372QSgMgCfeSQM6vFDarq53dou4Bhb5yki
PWIAn1vCLRzMBbjuaUmkv0KiWo+XHboa
=7Z/3
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to