[sqlite] Feature suggestion / requesst

Background: I never finished a degree back in the dark ages, but recently was provided an opportunity to earn a degree to go along with my experience at a really affordable price. As a result, I'm taking various classes to demonstrate my worthiness. :) Last semester I had a class that used

Re: [sqlite] Subject: Re: SQL Date Import

On 2 Jun 2018, at 8:55pm, Thomas Kurz wrote: > Are there any plans to implement a DATETIME and/or TIMESTAMP field types? No. SQLite has many routines which understand standard ways of storing datestamps: So you can store IS0-8601-format strings, unix

Re: [sqlite] Subject: Re: SQL Date Import

programme of experimentation is the right way to > pursue this. But I wanted to save you some time. > > SQLite doesn't have a DATE type. You can store dates in a SQLite database > as text, or integers or floating point numbers (e.g. "20180602", a number of > days, a numb

Re: [sqlite] Subject: Re: SQL Date Import

ve a DATE type. You can store dates in a SQLite database as text, or integers or floating point numbers (e.g. "20180602", a number of days, a number of seconds). But when you ask for a value, that's what you'll get back. Any interpretation of that value as a date is up to you or yo

Re: [sqlite] Subject: Re: SQL Date Import

to pursue this. But I wanted to save you some time. SQLite doesn't have a DATE type. You can store dates in a SQLite database as text, or integers or floating point numbers (e.g. "20180602", a number of days, a number of seconds). But when you ask for a value, that's what you'll get back.

[sqlite] Subject: Re: SQL Date Import

Keith Medcalf wrote: > Yes, and the database will store the data as entered/bound if it > cannot be converted to the requested storage type (column affinity). Yes, that was my understanding and there-lies the problem. A column of type DATE, TIME, or TIMESTAMP that may have NUMERIC and TEXT data.

[sqlite] Request to add define SQLITE_PREPARE_NONE

Hello Dr. Hipps There is a #define SQLITE_PREPARE_PERSISTENT x01 line in sqlite3 source code for sqlite3_prepare_v3() flags. Could you add SQLITE_PREPARE_NONE meaning no flag set? Thanks --- --- Eduardo Morras ___ sqlite-users mailing list

Re: [sqlite] random rows

On 06/01/18 04:41 , Abroży Nieprzełoży wrote: > 2018-06-01 2:12 GMT+02:00, Torsten Curdt : >> I need to get some random rows from a large(ish) table. >> >> The following seems to be the most straight forward - but not the fastest. >> >> SELECT * FROM table ORDER BY random() limit 200 >> >> Is

[sqlite] ext/misc/csv.c breaks on single-column CSVs as at 3.23.1 2018-04-10

[Please CC me in replies, as I am not subscribed to this mailing list.] The ext/misc/csv.c loadable extension handles single-column CSVs incorrectly. Note that this is *not* the same code as ".mode csv" + ".import 1.csv t1". Ref. https://sqlite.org/csv.html A minimal reproduction follows. A full

Re: [sqlite] Size of the SQLite library

"You are soo, bloated," said Java. On Thu, May 31, 2018, 11:58 R Smith wrote: > > On 2018/05/31 5:17 PM, ven...@intouchmi.com wrote: > > I have to agree with Bob! > > > > We have considered SQLITE for our project. Going over 500Kbytes puts it > > just beyond the size of our Flash - the