Re: [sqlite] Why isn't my time formatting working?

2017-03-11 Thread Michael Falconer
UmI'm one of those sad old hacks who doesn't store dates at all. Just Years, Months, and Days. You can do just about anything with them stored that way, and in sqlite it seems to matter little whether they are string or numeric columns. Dates are a rubbery concept not well suited to db storage

Re: [sqlite] [sqlite-dev] End-of-line characters in the output of ".dump"

2017-03-11 Thread Richard Hipp
On 3/11/17, James K. Lowden wrote: > On Sat, 11 Mar 2017 08:50:49 -0500 > Richard Hipp wrote: > >> The SQLite CLI could be improved to be cleaner about this, but it >> depends on external utilities such as readline() or linenoise() > > Could you expand on that a bit, please? Readline() strips \n