Re: [sqlite] Simple SQLite-based spreadsheet?

On Fri, Dec 7, 2012 at 12:49 PM, Gilles Ganault wrote: > On Fri, 7 Dec 2012 16:02:13 +, "Duquette, William H (318K)" > wrote: >>I don't think the OP really cares about linking SQLite to a spreadsheet. >>If I'm reading him correctly,

Re: [sqlite] Please test the latest SQLite snapshot

On Mon, Dec 3, 2012 at 3:25 PM, Richard Hipp wrote: > A draft of the > release website can be seen here: > > http://www.sqlite.org/draft/index.html Typo at the very beginning of http://www.sqlite.org/draft/about.html : s/SQLite is a in-process library/SQLite is an

Re: [sqlite] SQLite driver for Java

On Sat, Nov 24, 2012 at 12:37 PM, Julian wrote: > Dear William > >> What driver are people using to access SQLite databases from Java >> applications? > > Personally I'm using the Xerial/Zentus driver, which seems available in > several places on the net, such as >

Re: [sqlite] Stricter parsing rules

On Wed, Nov 14, 2012 at 5:22 PM, Simon Slavin wrote: > > On 14 Nov 2012, at 9:46pm, BareFeetWare wrote: > >> I agree. this tolerance by SQLite for misquoted identifiers allows a lot of >> errors. I'd really like to see the rules tightened to

Re: [sqlite] datetime, its customary column affinity, and storage class info

On Mon, Oct 22, 2012 at 11:38 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Oct 2012, at 3:42am, John Gabriele <jmg3...@gmail.com> wrote: > >> Which column affinity is most customary to use for storing "-MM-DD >> HH:MM:SS" datetime values

[sqlite] datetime, its customary column affinity, and storage class info

Hi, Which column affinity is most customary to use for storing "-MM-DD HH:MM:SS" datetime values? I tried this: ~~~sql create table t1 ( id integer primary key, this_date text, that_date int, other_date none); insert into t1 (this_date, that_date, other_date) values