-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/04/2010 03:35 PM, Barton Torbert wrote: > We are thinkng about writing C Extensions to SQLite to do this. But I was > wondering if there are a set already written that could be used?
Not to my knowledge as every programming language already includes formatting. SQLite is a library within your process so there is no need to use SQLite C extension functions - just use whatever language the process is written in. The only time you'd need to use C extensions is if SQLite itself needs to be aware of your formatting such as for filtering or sorting which mainly means a collation. However it is usually better to store an additional column with the formatted data rather than have functions repeatedly called whenever SQLite needs to access the row. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkzTWWMACgkQmOOfHg372QSOiQCgnMeSSObhijsTP3Ra5IXw1QyW YZAAn1Qs9QqueHG5k6b4g/+Mf8Fv9Ho+ =cEtz -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
