[sqlite] UDTs

2015-06-05 Thread Joe Mucchiello
All these subject lines about UDTs in SQLite and the one and only thing I would use such a thing for is not listed: Date/Time values. I'd love for there to be native date/time formats in SQLite. I'm surprised it never came up. Although I'm also surprised the NoSQL-ite came up. > That's six sets

[sqlite] UDTs

2015-06-05 Thread Simon Slavin
On 5 Jun 2015, at 9:14pm, Joe Mucchiello wrote: > All these subject lines about UDTs in SQLite and the one and only thing I > would use such a thing for is not listed: Date/Time values. I'd love for > there to be native date/time formats in SQLite. I'm surprised it never came > up. Although I

[sqlite] UDTs

2015-06-05 Thread Nico Williams
On Fri, Jun 05, 2015 at 09:36:09PM +0100, Simon Slavin wrote: > One advantage I can think of of having a DateTime type -- enforcement > of storing the correct thing in the correct column -- won't work in > SQLite anyway, because rather than enforce column types is uses only > affinities. > > How w