On Feb 11, 2017 7:15 PM, "James K. Lowden" <jklow...@schemamania.org> wrote:
On Fri, 10 Feb 2017 10:46:24 +0100 Dominique Devienne <ddevie...@gmail.com> wrote: > PS: In this context, I don't want to use a host-program provided UDF. > This is data meant to be viewed with any SQLite client, so kind of > "report". https://github.com/jklowden/sqlrpt While Clemens was parsimonously adding 14 lines to support a thousands separator in the SQL interpreter, I was extravagantly adding 225 to create a new utility. {snip} I thought it was DRH that added it? Regardless, what everyone seems to ignore, is the stated desire for a query that works with any stock compatible SQLite implementation. So it can be used with the sqlite shell, or any of the sqlite embedded database managers or library wrappers for a variety of languages. Sure, in a perfect world, people would use something like your new utility. Thank you for it. But given that SQLite already uses certain American-isms (decimal point for string coerced reals), adding this is not some horrible affront to software development, any more than a lack of "type safety" is. It's just a tool that you are free to ignore if it doesn't suit your use one's use case. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
