Re: [sqlite] Date time input

2019-10-08 Thread Gary R. Schmidt
On 09/10/2019 10:25, Kevin Benson wrote: On Tue, Oct 8, 2019 at 2:40 PM James K. Lowden wrote: On Tue, 8 Oct 2019 09:06:24 -0700 Jens Alfke wrote: I think the idea of a semi-official ?SQLite++? has been floated here before OK, but it needs a better name. -- SQLiteXTD SQLArdArse.

Re: [sqlite] Date time input

2019-10-08 Thread Kevin Benson
On Tue, Oct 8, 2019 at 2:40 PM James K. Lowden wrote: > On Tue, 8 Oct 2019 09:06:24 -0700 > Jens Alfke wrote: > > > I think the idea of a semi-official ?SQLite++? has been floated here > > before > > OK, but it needs a better name. -- > SQLiteXTD -- -- --Ö¿Ö-- K e V

Re: [sqlite] Date time input

2019-10-08 Thread Doug
I like SQLoaded! Doug > -Original Message- > From: sqlite-users > On Behalf Of Jose Isaias Cabrera > Sent: Tuesday, October 08, 2019 12:15 PM > To: sqlite-users@mailinglists.sqlite.org > Subject: Re: [sqlite] Date time input > > > James K. Lowden, on Tuesday, October 8, 2019 02:39 PM,

[sqlite] SELECT uses index with SUBSTR but UPDATE doesn't

2019-10-08 Thread Brannon King
I have this query: UPDATE nodes SET parent = ? WHERE SUBSTR(name, 0, ?) = ? EXPLAIN QUERY PLAN tells me that it is going to do a table scan. At the same time, the query plan for this: SELECT * FROM nodes WHERE SUBSTR(name, 0, ?) = ? tells me that it can and will use the (primary key) index on the

Re: [sqlite] Date time input

2019-10-08 Thread Jose Isaias Cabrera
James K. Lowden, on Tuesday, October 8, 2019 02:39 PM, wrote... > > On Tue, 8 Oct 2019 09:06:24 -0700 > Jens Alfke, on > > > I think the idea of a semi-official ?SQLite++? has been floated here > > before > > OK, but it needs a better name. What better place than here to debate > that? ;-)

Re: [sqlite] Date time input

2019-10-08 Thread Simon Slavin
On 8 Oct 2019, at 7:39pm, James K. Lowden wrote: > Simon Slavin wrote: > >> Converting data to and from a convenient storage format is not the >> job of a DBMS. > > While I have no quarrel with your specific point about date strings, > this particular statement is too broad. Arguably, data

Re: [sqlite] Date time input

2019-10-08 Thread James K. Lowden
On Mon, 7 Oct 2019 18:17:14 +0100 Simon Slavin wrote: > Converting data to and from a convenient storage format is not the > job of a DBMS. While I have no quarrel with your specific point about date strings, this particular statement is too broad. Arguably, data conversion is an inherent,

Re: [sqlite] Date time input

2019-10-08 Thread James K. Lowden
On Tue, 8 Oct 2019 09:06:24 -0700 Jens Alfke wrote: > I think the idea of a semi-official ?SQLite++? has been floated here > before OK, but it needs a better name. What better place than here to debate that? ;-) What the opposite of "Lite"? I don't know. It's like asking for the opposite

Re: [sqlite] LSM Extension Performance (from sqlite3 tree)

2019-10-08 Thread Amirouche Boubekki
Le jeu. 16 mai 2019 à 13:47, Amirouche Boubekki a écrit : > > Hello, > > > I am considering using lsm extension for a project. I a did a few benchmark > with the following configuration: > > LSM_CONFIG_AUTOFLUSH 1048576 > LSM_CONFIG_BLOCK_SIZE 65536 > LSM_CONFIG_AUTOWORK 1 > LSM_CONFIG_MMAP 0 >

Re: [sqlite] Date time input

2019-10-08 Thread Jose Isaias Cabrera
Jens Alfke, on Tuesday, October 8, 2019 12:06 PM, wrote... > > > > On Oct 8, 2019, at 5:34 AM, Jose Isaias Cabrera, on > > > > No, that is not what I was trying to say or ask. Not even close. What I was > trying to say, and most of you missed it was, that if I give date a date > format, > and

Re: [sqlite] Date time input

2019-10-08 Thread Jens Alfke
> On Oct 8, 2019, at 5:34 AM, Jose Isaias Cabrera wrote: > > No, that is not what I was trying to say or ask. Not even close. What I was > trying to say, and most of you missed it was, that if I give date a date > format, and I also provide the format of how that date is to be understood, >

Re: [sqlite] [EXTERNAL] Re: Date time input

2019-10-08 Thread Jose Isaias Cabrera
Shawn Wagner, on Tuesday, October 8, 2019 09:40 AM, wrote... > > So, I have a bunch of sqlite extension modules that I really should polish > up for an official release Real Soon Now... > > I just added a basic interface to the POSIX strptime() function to the > string functions library: > >

Re: [sqlite] [EXTERNAL] Re: Date time input

2019-10-08 Thread Jose Isaias Cabrera
Hick Gunter, on Tuesday, October 8, 2019 08:46 AM, wrote... > > What it boils down to is asking the data storage layer to perform a > presentation > layer task. Thanks, Hick. > > If you insist on solving the problem inside an SQL statement, you can always > write your own extension function to

Re: [sqlite] [EXTERNAL] Re: Date time input

2019-10-08 Thread Shawn Wagner
So, I have a bunch of sqlite extension modules that I really should polish up for an official release Real Soon Now... I just added a basic interface to the POSIX strptime() function to the string functions library: sqlite> .load ./libstring_funcs sqlite> select date(strptime('%m/%d/%Y',

Re: [sqlite] [EXTERNAL] Re: Date time input

2019-10-08 Thread Hick Gunter
What it boils down to is asking the data storage layer to perform a presentation layer task. If you insist on solving the problem inside an SQL statement, you can always write your own extension function to "easily" perform the necessary conversion. -Ursprüngliche Nachricht- Von:

Re: [sqlite] Date time input

2019-10-08 Thread Jose Isaias Cabrera
Jens Alfke, on Monday, October 7, 2019 09:18 PM, wrote... [clip] > I swear, half the questions on this list build down to "Why doesn't > SQLite act like MS Access?" If you need all the bells and whistles of > formatting > input and output, then use a fancy DBMS application. SQLite is for