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.
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 i
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, w
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 n
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? ;-)
SQLi
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 con
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, cent
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
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
> L
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 I
> 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,
>
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:
>
> sqlit
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
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', '10/08/2
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: sqlite
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 embedded
16 matches
Mail list logo