Re: [sqlite] Possible bug with strftime('%s') < strftime('%s')

sqlite> select datetime('now', '+300 seconds') < datetime('now'); > 0 > > sqlite> select datetime('now', '-300 seconds') < datetime('now'); > 1 > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf

Re: [sqlite] Possible bug with strftime('%s') < strftime('%s')

So strftime always returns TEXT. Correct? It was the application of +300 to that result that changed the type to INTEGER. And had "+300 seconds" been applied as a modifier in the strftime function, then the addition would have occurred before producing the result, with the result being type TEXT.

Re: [sqlite] How to create primary key from two another PK's?

Just asking some leading questions. You have students. And students have work pieces. You are then creating a list "uniqueworkpiece" showing the work pieces associated to each student. Your primary key will ensure the uniqueness of the student to work piece. Do you also need to ensure that the

Re: [sqlite] Simple Search using LIKE or something else

I'd take regular expressions, sure, but, how do you get SQLite syntax > to take that on? > > On Fri, Nov 10, 2017 at 8:45 AM, Don V Nielsen <donvniel...@gmail.com> > wrote: > > Assuming you are looking for "Abc" or "Def" anywhere in the argument, how > >

Re: [sqlite] Simple Search using LIKE or something else

A good StackOverflow post on adapting in C# for use in Linq queries: https://stackoverflow.com/questions/24229785/sqlite-net-sqlitefunction-not-working-in-linq-to-sql/26155359#26155359 On Fri, Nov 10, 2017 at 8:31 AM, Don V Nielsen <donvniel...@gmail.com> wrote: > Brent Ashley has a

Re: [sqlite] Simple Search using LIKE or something else

Assuming you are looking for "Abc" or "Def" anywhere in the argument, how about regular expression? (Abc|Def) On Thu, Nov 9, 2017 at 3:00 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" < >

Re: [sqlite] Best way to develop a GUI front-end

Ruby on Rails On Tue, Nov 14, 2017 at 10:09 AM, Drago, William @ CSG - NARDA-MITEQ < william.dr...@l3t.com> wrote: > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > > Behalf Of Bart Smissaert > > Sent: Monday, November 13, 2017

Re: [sqlite] Lots of enhancements coming to version 3.24.0 - please test

Two thumbs up, Dan. Thanks for the clarification. On Tue, May 8, 2018 at 11:11 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 05/08/2018 11:04 PM, Don V Nielsen wrote: > >> " UPDATE <https://www.sqlite.org/draft/lang_update.html> avoids writing >>>

Re: [sqlite] Lots of enhancements coming to version 3.24.0 - please test

> " UPDATE avoids writing database pages that do not actually change. For example, "UPDATE t1 SET x=25 WHERE y=?" becomes a no-op if the value in column x is already 25." I have a ridiculous assertion concerning this, but please here me out. Given

Re: [sqlite] Newbie help

> the monitoring program is constantly launching sqlite3.exe with new commands or files of commands So the monitoring program has the ability to interact with the outside world when something changes? Can you write a service that listens for activity from our monitoring program, and the service

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

Any thought, comments, or observations of using Slack? On Fri, Jun 15, 2018 at 1:25 PM J. King wrote: > On June 15, 2018 12:17:31 PM EDT, dmp > wrote: > >> Mailing lists are now back on-line and once again accepting > >> subscriptions. I have implemented measures to block the subscription >

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

> Do we need any further evidence that the heart of man is deceitful above all things, and desperately wicked? Per Keith Metcalf: "The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume." On Thu, Jun 14, 2018 at 12:38 PM R Smith

Re: [sqlite] random rows

?? SELECT * FROM table WHERE id IN (SELECT id FROM table ORDER BY RANDOM() LIMIT x) Maybe. It is more memory efficient then trying to sort the entire lot of data. On Thu, May 31, 2018 at 7:13 PM Torsten Curdt wrote: > I need to get some random rows from a large(ish) table. > > The following

Re: [sqlite] Infinite loop when updating indexed with case and where clause

Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" Is there a performance bonus or compiler optimization if one compares a target constant to a source condition versus comparing a target condition to a source constant, as in "(wctrlFlags & WHERE_ONEPASS_MULTIROW)!=0"?

Re: [sqlite] Move to Github!!?

> What's not so easy to replace is the Git integration in my editor (Visual Studio Code) Same here, but I use JetBrains products. I put a bug in the ear of JetBrains. At least its something. Have a good one, all On Tue, Dec 26, 2017 at 9:27 AM, J. King wrote: > I use Git,

Re: [sqlite] Add Column with "If Not Exists"

This makes me feel there is a lot of pain coming in the future. Given an update statement for n dbs of unknown state, When a db lacks columns necessary to successfully execute the sql Then add the columns to the db I'm trying to imagine how to keep n remote dbs in a known state, say z, when

Re: [sqlite] sqlite on IBM z/OS Unix

This is what I was trying to remember. It is for calling LE Cobol, but it demonstrates the use of the CEEENTRY and CEETERM macro that are used to establish the environment without having to use a LE C stub program. I used to use the Cobol stub method in the past.

Re: [sqlite] sqlite on IBM z/OS Unix

"Having successfully ported sqlite to z/OS Unix as a 32 bit app" Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I believe he is a guru with the mainframe. It is not SqlLite. It is that communication mechanism between the non-LE program calling into the LE environment.

Re: [sqlite] Can this be done with SQLite

Cecil, you need to make a backup of the values before they are altered, and then alter them from the backup. That way, by the time you have come full circle, you are not working with the changed values. On Mon, Jan 22, 2018 at 4:11 PM, Cecil Westerhof wrote: >

Re: [sqlite] SQLite equivalent of SQL Over(Partition)

That seems like an odd application of OVER (Partition by). Is there some performance reason one would want to do DISTINCT OVER (PARTITION BY) instead of a simple GROUP BY Sites.Customer, Sites.Digit, Count()? On Fri, Apr 6, 2018 at 12:20 PM, Simon Slavin wrote: > On 5 Apr

[sqlite] Documentation update

"For the purposes of unique indices, all NULL values are considered [to] different from all other NULL values and are thus unique." I think it should read "...NULL value are considered different..." https://www.sqlite.org/lang_createindex.html dvn ___

Re: [sqlite] Documentation update

I'm adding to my bucket list meeting some of you in person. On Mon, Apr 9, 2018 at 5:58 AM, Niall O'Reilly wrote: > On 9 Apr 2018, at 11:02, R Smith wrote: > > > Gentlemen - shall we call pistols at dawn to settle this? > > Or my favourite duel: Face-pulling at midnight.

Re: [sqlite] Documentation update

"to be", or not "to be" :) On Sun, Apr 8, 2018 at 7:08 PM, Don V Nielsen <donvniel...@gmail.com> wrote: > "For the purposes of unique indices, all NULL values are considered [to] > different from all other NULL values and are thus unique."

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

And my dating success rate has dropped dramatically On Wed, Apr 18, 2018 at 8:54 AM, José María Mateos wrote: > On Tue, Apr 17, 2018, at 17:39, Simon Slavin wrote: > > Dear list-posters, > > > > Are you getting a new dating-spam each time you post to this list ? If > > you

Re: [sqlite] JDBC driver experience

1. Xerial 2. Couple years? 3. None. But I am just a dumb user. I use JetBrains IDE's (RubyMine, Rider, Datagrip). The IDE's provide direct access to the datasource for looking at the db, manipulating data, manipulating tables. That sort of stuff. Never once have I had an issue with the driver

Re: [sqlite] non-returned column aliases for repeating expressions?

I'm not the sharpest tool in the shed, here, but a couple of observations / ideas. First, why in the ORDER clause use _3 and then "id" instead of _1? Using one alias and not the other is inconsistent and could be confusing. Personally, I would have did the following. Acquire the data using the

Re: [sqlite] Regarding CoC

I really feel for you, DRH. You tried covering all the bases, unfortunately, you going to get tagged out at everyone because everybody is referee and they all follow their own rules.This goes straight to your first point, "What is professional to some might be unprofessional to others." This akin

Re: [sqlite] Displaying row count

I really enjoy using JetBrains DataGrip. It connects to everything and has great intellisense, find and replace tools, sql templates, all the goodies a big IDE brings to the table. On Wed, Oct 31, 2018 at 11:05 AM Dominique Devienne wrote: > On Wed, Oct 31, 2018 at 3:55 PM Clemens Ladisch >

Re: [sqlite] A SQL statement reformatter

Slick. That line width slider feature is something we don't get using Poor Man's Sql Formatter. Thanks! On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin wrote: > For those times when you have to understand a poorly-formatted SQL > statement: > > > > I seem to prefer 'full'

Re: [sqlite] Grouping guidance

Making a mountain out of a mole hill, but isn't the solution more complex that that? The description has to be Foo & Bar. But if given the following, then the simple answer dies. create table requests (request,task,description); insert into requests values ('REQ0090887','TASK0236753','Foo'),

Re: [sqlite] Grouping guidance

Two thumbs up on Igor. They say the quickest way to the correct answer is to post the wrong answer on the internet. Hypothesis just proven. On Thu, Dec 13, 2018 at 3:00 PM Igor Tandetnik wrote: > On 12/13/2018 3:41 PM, Igor Tandetnik wrote: > > On 12/13/2018 3:27 PM, Don V Niel

Re: [sqlite] SQlite.NET.chm

Is the chm file on a server? I remember this problem from years ago...I haven't used a chm file in a long time. Unblocking did not fix it while it resided on the server. However, copying it locally and unblocking it did work. Hope this helps, dvn On Wed, Jan 9, 2019 at 11:29 AM Rizzuto, Raymond

Re: [sqlite] Can I get help with db design for SQLite use?

> Do be aware that almost all of us are just users like you. And be aware these guys are freakin brilliant. No lie. On Tue, Apr 2, 2019 at 10:26 AM Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > > I need help with a db design to be modeled for use with SQLite. The >

Re: [sqlite] Is there a tool to convert `where`s to equivalent `join`s?

> So for learning sake, is there a tool that converts a query using `WHERE` to a query (that yields identical results) using JOINs? I'm not aware of a tool, but I would assert that not using a tool is for learning sake. Recoding by hand is going to be your best learning experience. Note: there

Re: [sqlite] Documentation correction

On the heel of Tom's input is the fragment " then that name always refers the explicitly declared column". Should that be " then that name always refers *to* the explicitly declared column"? On Mon, Apr 15, 2019 at 3:32 PM wrote: > Hi, I just wanted to point out a minor discrepancy in the docs

Re: [sqlite] Making blob as a sqlite database.

Sorry to bother, Mohd. What is your use case? I mentioned this to developers around me and they are intrigued. You are storing a database file as blob in a database? We are curious as to the application. I am assuming the database being stored is a collection of sensor or event data? On Fri, Apr

[sqlite] Grammar police

" An application interact with the database engine using function calls, not be sending messages to a separate process or thread." "An applications [interacts] ..., [not by]... ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Grammar police

Sorry. This was in the Quirks, Caveats page, #2. On Thu, Jul 11, 2019 at 9:57 AM Don V Nielsen wrote: > " An application interact with the database engine using function calls, > not be sending messages to a separate process or thread." > > "

Re: [sqlite] Grammar police

Not to be argumentative with Keith, as I'm have the sinking feeling that slitting my own throat would be a more pleasurable experience. But, here it goes: A *lexicon* is a list of words that belong to a particular language. Sometimes, *lexicon* is used as another word for *thesaurus* (see below)

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

If I were to have coded that junk (and I do see it too many times to count), I would have coded it even junkier, as in bool is_true (bool tf) { if (tf == true) return true; else return false; } If it's single statement following an if and that statement isn't beyond 80 characters, I will

Re: [sqlite] Last record

Keith, what if one has a peanut allergy? On Tue, Oct 15, 2019 at 1:33 PM Jose Isaias Cabrera wrote: > > > Keith Medcalf, on Tuesday, October 15, 2019 02:26 PM, wrote... > > > > > > On Tuesday, 15 October, 2019 09:35, Philippe RIO, on > > > > >A short question : how could I know if I am reading

Re: [sqlite] Last record

Pardon me for being thick. But the end of what? The end of the sqlite file? The end of a table? The end of a select? I always thought there was no such thing as "a start or an end" as the database is basically air until you request something from it. Even when you have something, it could change

Re: [sqlite] New word to replace "serverless"

As R Smith pointed out, you already have a good description in your existing documentation: "SQLite is a self-contained, server-free, zero-configuration ... " I would also throw in the term "library", because it is what it is. Sqlite is just non-executable code that doesn't function on it's own.

Re: [sqlite] DRH interview on why/how SQLite succeeded

DRH sounds so much more human in the podcast than the DRH I have assembled in my head from reading this mailing list. :) On Wed, Feb 19, 2020 at 11:39 AM Simon Slavin wrote: > > > Podcast / transcription of DRH interview: > > " We talked to Richard about the

<    1   2