I'd like to use SQLite's new "loadable extension" capability to define
an additional collating sequence (IP address) that I need for a hurry-up
project. I'm working in TCL -- on Windows, unfortunately -- and do not
have compile and build tools for that platform (nor the skills to use
them). My collation function works fine under TCL, but when defined as
default collation for table columns, the tables cannot be manipulated in
collation-sensitive ways (e.g., "order by") in the SQLite shell, where
the TCL collation function is not defined.
Is there a reliable precomplied Windows binary of a post-3.3.6 CVS
version of SQLite available somewhere? If so, would it be possible to
package the TCL collation function so that it could be used with the
SQLite shell's new .load operation?
BTW ... thanks to Richard for developing a great tool. I'm a long-time
PostgreSQL user, but for small, quick, portable projects, SQLite looks
like just the ticket.
-- Bill Clay
Charlotte NC
