> On Feb 19, 2018, at 7:49 PM, petern <peter.nichvolo...@gmail.com> wrote: > > 3. Why can't SQLite have the expected common static SQL functions for > getting rapid development done without external tools?
Because its primary use case is as an embedded library for programs, not as a standalone tool or server. From that perspective, it’s wasteful for SQLite to include functionality that can be done as well or better by the program that calls it. It’s also very easy to add custom SQL functions to SQLite, so if you have a need for these, you can write them yourself and either link them into your app, or build them as a library that the sqlite3 tool can load. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users