[sqlite] Why is this so much more efficient?

efficient. Why is this? ​In case it is important: I did this in sqlitebrowser 3.7.0​, which uses SQLite 3.8.10.2. -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listin

[sqlite] Storing a INTEGER in a TEXT field

AS Date ,time AS Time ,CAST(message AS INTEGER) AS DownloadCount FROM messages WHEREtype = 'download-count' ; -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Storing a INTEGER in a TEXT field

2017-02-15 1:32 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > > On 15 Feb 2017, at 12:22am, Cecil Westerhof <cldwester...@gmail.com> > wrote: > > > Is there a way to store an INTEGER in a TEXT field? > > No. But you can do it the other way around. You

Re: [sqlite] Storing a INTEGER in a TEXT field

2017-02-15 11:12 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > 2017-02-15 5:40 GMT+01:00 Darko Volaric <li...@darko.org>: > >> The problem is that you're giving your column a type when you don't want >> it >> to have. If the second last line was

Re: [sqlite] Thread safety of serialized mode

do it much more > safely than if you are explicitly using "threads" in code. ​As I said before: I did not work much with threads. Mostly for GUI performance. Do you (or anyone else) have any resources about those concurrency models​? -- Cecil Westerhof

Re: [sqlite] Why is this so much more efficient?

2017-02-15 12:02 GMT+01:00 R Smith <rsm...@rsweb.co.za>: > > On 2017/02/15 12:33 PM, Cecil Westerhof wrote: > >> I have a table vmstat that I use to store vmstat info. ;-) >> At the moment it has more as 661 thousand records. >> >> In principle the v

[sqlite] Seems that '-cmd .timer on' does not work in non interactive mode

ppening here? I got around it with: sqlite3 -batch -cmd '.timer on' ~/Databases/general.sqlite < 101 ; EOT ​ -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why is this so much more efficient?

2017-02-15 12:02 GMT+01:00 R Smith : > Note however that this may not be entirely true. The Query might read data > from the disk cache (or several memory caches may be in play) during the > second run. Run each statement many times, and compare average return times. > > Also

Re: [sqlite] Why is this so much more efficient?

2017-02-15 13:40 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > I wrote the following Bash script: > ​I wrote a better one. See end of post. Inprinciple you are only interested in the totals. I also changed the runs from 10 to 25. The OR version is the least efficient and i

Re: [sqlite] Beginning of release testing for version 3.17.0

2017-02-09 18:46 GMT+01:00 Roger Binns <rog...@rogerbinns.com>: > On 08/02/17 11:41, Cecil Westerhof wrote: > > ​OK, glad to help. What should I do? > > It is nicest if whatever software/tools you already have also has some > sort of testing (ideally automated, but a ma

Re: [sqlite] Why is this so much more efficient?

2017-02-16 21:10 GMT+01:00 Dominique Pellé <dominique.pe...@gmail.com>: > Cecil Westerhof <cldwester...@gmail.com> wrote: > > > I have a table vmstat that I use to store vmstat info. ;-) > > At the moment it has more as 661 thousand records. > > > > In pr

Re: [sqlite] Difference between min and max time, especially for sys

2017-02-16 19:31 GMT+01:00 Jens Alfke <j...@mooseyard.com>: > > > On Feb 15, 2017, at 11:47 AM, Cecil Westerhof <cldwester...@gmail.com> > wrote: > > > > But the difference between sys can be almost a factor twenty. What seems > very big to me. > >

Re: [sqlite] Why is this so much more efficient?

2017-02-15 14:18 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > The OR version is the least efficient and it look likes the BETWEEN > version 2 is the most efficient. It looks like it uses less user and more > sys. > ​Which is the most efficient is also depe

[sqlite] Difference between min and max time, especially for sys

twenty. What seems very big to me. Also it looks like SQLite suggests a precision it does not have. It shows four digits after the point, but it looks like that the smallest value greater as zero is 0.004. So why does SQLite not show three digits after the point? -- Cecil Westerhof

Re: [sqlite] How to circumvent UNIQUE constraint

2017-01-23 16:53 GMT+01:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: > >> UPDATE desktops > >> SET indexNo = indexNo + 1 > >> > >> But it does not, it gives: > >> Error: UNIQUE constraint failed: desktops.in

[sqlite] How to circumvent UNIQUE constraint

has to be increased with one for all records. I would think that this would work: UPDATE desktops SET indexNo = indexNo + 1 But it does not, it gives: Error: UNIQUE constraint failed: desktops.indexNo ​How can I make this work? -- Cecil Westerhof

Re: [sqlite] Not empty

2016-08-21 12:11 GMT+02:00 Richard Hipp <d...@sqlite.org>: > On 8/21/16, Cecil Westerhof <cldwester...@gmail.com> wrote: > > I have a field subject that I do not want to be empty. That means it > should > > not be NULL and it should not contain

[sqlite] Not empty

I have a field subject that I do not want to be empty. That means it should not be NULL and it should not contain ''. At the moment I do it like this: subjectTEXT NOT NULL subject <> ''), Is there a better way? -- Cecil Westerhof ___

Re: [sqlite] SQLite 3.15.0 scheduled for 2016-10-14

2016-09-22 21:04 GMT+02:00 Richard Hipp <d...@sqlite.org>: > Our current schedule for the next SQLite release (3.15.0) is for > 2016-10-14. > > Your beta-tests are appreciated. ​What can I do to beta test? -- Cecil Westerhof ___ sq

Re: [sqlite] Select older or not selected records

gt; seen for 10 years. > > As for selecting a quote, why not just select the quote with the earliest > last-seen-timestamp ? It can be done in one SELECT operation which uses an > index, so it'll happen almost instantly. Because you

[sqlite] Strange problem with using random with a table

FROM proverbs ) LIMIT 5; I get very strange results: 382|606000 172|148000 144|592000 181|136000 123|469000 What could be happening here? I am using SQLite version 3.8.10.2 on openSUSE Leap 42.1. -- Cecil Westerhof ___ sqlite-users mailing list

[sqlite] Select older or not selected records

records. The other three records are selected at random from the already selected ones, where the older ones have a higher chance of getting selected. Is this possible, or should it be done in two queries? I hope I am clear enough. -- Cecil Westerhof

Re: [sqlite] Select older or not selected records

gt; certainly terrible :P I think the approach is ok, though I remember some > recent threads suggesting the interaction between ORDER BY and LIMIT is not > as intuitive as one might expect. I am going to play with it. Thanks. > On 11 November 2016 at 16:26, Cecil Westerhof <

Re: [sqlite] Strange problem with using random with a table

2016-11-11 11:01 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > When I execute the following query: > SELECT * > , randomiser * 1000 > FROM ( > SELECT abs(random()) / 1 AS randomiser > ); > > I get normal results: > 61|61000 > &

Re: [sqlite] Select older or not selected records

a selected is never more as three week used after a not selected one. I want the spread in the never selected to be a little bigger as the selected. That is why I use the '/ 5'. > On 11 November 2016 at 16:26, Cecil Westerhof <cldwester...@gmail.com> > wrote: > >> I have an app

Re: [sqlite] Strange problem with using random with a table

2016-11-11 11:22 GMT+01:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: >> When I execute the following query: >> SELECT *, randomiser * 1000 >> FROM (SELECT abs(random()) / 1 AS randomiser); >> >> I get normal resul

[sqlite] Changing ID's to UUID

I have several tables where a numeric ID is used. I want to change those to UUID's. Is there a smart way to do this, or need I to do this one by one? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

[sqlite] SQLite comes bundled with the Python programming language?

At: http://www.sqlite.org/famous.html I see: SQLite comes bundled with the Python programming language since Python 2.5. Should that not be: The Python programming language comes bundled with SQLite since Python 2.5. -- Cecil Westerhof

Re: [sqlite] Changing ID's to UUID

2016-11-15 12:02 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > > On 15 Nov 2016, at 8:03am, Cecil Westerhof <cldwester...@gmail.com> wrote: > >> I have several tables where a numeric ID is used. I want to change >> those to UUID's. Is there a smart way to do

[sqlite] Advanced SQL course

I can follow an advanced SQL course. It is tailored for the Oracle database which I do not use. I mostly use SQLite. ;-) Would it still be interesting to follow this course, or would it be a waste of time? -- Cecil Westerhof ___ sqlite-users mailing

[sqlite] Unable to connect

When going to www.sqlite.org I get: Unable to connect -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite comes bundled with the Python programming language?

that it is about Firefox using SQLite and not the other way around. Not all users of SQLite are fluent speakers of English, so it would be good to prevent this kind of ambiguity. Kudos for the fast change of the text. -- Cecil Westerhof

Re: [sqlite] Unable to connect

2016-11-14 7:47 GMT+01:00 jungle boogie <jungleboog...@gmail.com>: > On 11/13/2016 10:29 PM, Cecil Westerhof wrote: >> >> When going to www.sqlite.org I get: >> Unable to connect >> > > Also happening for me. > > Use https://www.sqlite.org/ unt

[sqlite] Why takes the second SELECT three times as much time?

* FROM temperatureStatistics WHEREdate BETWEEN (SELECT date('now', '-7 day')) AND (SELECT date('now', '-1 day')) ORDER BY date DESC But the first one is about three times as fast as the second one. What am I doing wrong here? -- Cecil Westerhof

Re: [sqlite] Why takes the second SELECT three times as much time?

ry? >> >> —Jens >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >

[sqlite] A total with a GROUP BY

At the moment I have the following code: SELECT totalUsed, COUNT(*) AS Count FROM tips GROUP BY totalUsed This shows the total number of records for every value of totalUsed. Would it be possible to get the total number of records also. (Sum of all the Count's.) -- Cecil Westerhof

Re: [sqlite] A total with a GROUP BY

2016-12-01 21:37 GMT+01:00 Igor Tandetnik <i...@tandetnik.org>: > On 12/1/2016 1:57 PM, Cecil Westerhof wrote: >> >> At the moment I have the following code: >> SELECT totalUsed, COUNT(*) AS Count >> FROM tips >> GROUP BY totalUsed >> >> Thi

[sqlite] Get version at runtime

If I recollect correctly there is a way to determine at runtime what the version of SQLite is. But I do not remember how. How can this be done? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Get version at runtime

; -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Cecil Westerhof > > Sent: Saturday, 18 March, 2017 03:09 > > To: SQLite mailing list > > Subject: [sqlite] Get version at runtime > > > > If I recollect

[sqlite] Why the high cost of a double sort

erence? Then I could install that one and see the results from that. (The JDBC uses 3.20.2.) -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why the high cost of a double sort

2017-08-19 20:37 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: > > I have the following query: > > SELECT used > > FROM usedProverbs > > LIMIT 1 > > > > The view useProverbs is defined as: >

Re: [sqlite] Why the high cost of a double sort

uot;order by" from the view, then the query flattener will > be able to flatten the query and re-write and execute as if you had entered: > > SELECT used > FROM proverbs >WHERE CAST(used AS INT) <> 0 > ORDER BY used >LIMIT 1 > ​Thanks. I learned someth

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

2017-09-05 23:11 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > > > On 5 Sep 2017, at 9:21pm, Cecil Westerhof <cldwester...@gmail.com> wrote: > > > I want to know the number of teas I have in stock. For this I use: > > SELECT COUNT(Tea) > > FROM

[sqlite] Getting number of rows with NULL

It is not very important, but I am just curious. I need to know how many records are not yet used. I do that with: SELECT COUNT(*) - COUNT("Last Used") AS "Not Used" FROM teaInStock Is that the correct way, or is there a better way?

Re: [sqlite] Getting number of rows with NULL

ss > roundabout way. ​Yes, your query is the better one. -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

, or are people just ‘lazy’?​ -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Getting number of rows with NULL

2017-09-05 21:55 GMT+02:00 Igor Tandetnik <i...@tandetnik.org>: > On 9/5/2017 3:45 PM, Cecil Westerhof wrote: > >> It is not very important, but I am just curious. I need to know how many >> records are not yet used. I do that with: >> SELECT COUNT(*) - COUNT(&quo

Re: [sqlite] Getting number of rows with NULL

ntil the OP mentioned his Tea column cannot have NULL > values, so now I'm slightly lost and Stephen's interpretation seems more > sensible, but then the OP said that Igor's solution is working for him, > which should only work if there are NULL values... so yes, I am very much &g

Re: [sqlite] Sharing data between desktop and Android

2017-09-06 12:01 GMT+02:00 Andy Ling <andy.l...@s-a-m.com>: > Cecil Westerhof wrote: > > I am thinking about writing some Android applications. I would like to > > share data between the phone (or tablet) and de desktop. What is the best > > way to do this? In a way th

Re: [sqlite] Sharing data between desktop and Android

2017-09-06 12:54 GMT+02:00 Andy Ling <andy.l...@s-a-m.com>: > > Cecil Westerhof wrote: > > > I am thinking about writing some Android applications. I would like to > > > share data between the phone (or tablet) and de desktop. What is the > best > > >

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-06 23:49 GMT+02:00 Jens Alfke <j...@mooseyard.com>: > > > > On Sep 6, 2017, at 2:37 PM, Cecil Westerhof <cldwester...@gmail.com> > wrote: > > > > But should in the first case the 0 not be cast to a 0.0? > > No, SQLite ignores colu

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-07 0:20 GMT+02:00 Wolfgang Enzinger <sql...@enzinger.net>: > Am Thu, 7 Sep 2017 00:15:39 +0200 schrieb Cecil Westerhof: > > > 2017-09-07 0:05 GMT+02:00 R Smith <rsm...@rsweb.co.za>: > > > >> On 2017/09/06 11:58 PM, R Smith wrote: > >>

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-06 23:58 GMT+02:00 R Smith <rsm...@rsweb.co.za>: > On 2017/09/06 11:37 PM, Cecil Westerhof wrote: > >> But should in the first case the 0 not be cast to a 0.0? >> > > What makes you believe SQLite should massage the data into specific types > for you wit

Re: [sqlite] Should the INTEGER not be cast to a REAL

d do: INSERT INTO testing (float) VALUES (0) The insert is successful of-course. When I then execute: SELECT float, TYPEOF(float) FROM testing I get: "0.0""real" Maybe this is correct, but it is certainly confusing. -- Cecil Westerhof ___

Re: [sqlite] Should the INTEGER not be cast to a REAL

TRAINT float CHECK(TYPEOF(float) IN ("real","integer")) ); Instead of "int" you need "integer". -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Should the INTEGER not be cast to a REAL

ing (float) VALUES (0.0) I get: Query executed successfully But should in the first case the 0 not be cast to a 0.0? I do this in DBBrowser which uses 3.15.2. -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-07 0:20 GMT+02:00 Richard Hipp <d...@sqlite.org>: > On 9/6/17, Cecil Westerhof <cldwester...@gmail.com> wrote: > > > > Maybe this is correct, but it is certainly confusing. > > > > The constraint check occurs before the implicit conversion. >

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-07 0:36 GMT+02:00 Wolfgang Enzinger <sql...@enzinger.net>: > Am Thu, 7 Sep 2017 00:28:56 +0200 schrieb Cecil Westerhof: > > > 2017-09-07 0:20 GMT+02:00 Wolfgang Enzinger <sql...@enzinger.net>: > > >> Add this trigger and everything i

Re: [sqlite] Should the INTEGER not be cast to a REAL

2017-09-07 0:57 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > > > On 6 Sep 2017, at 11:31pm, Cecil Westerhof <cldwester...@gmail.com> wrote: > > > 2017-09-07 0:20 GMT+02:00 Richard Hipp <d...@sqlite.org>: > > > >> On 9/6/17, Cecil Westerh

Re: [sqlite] Do you really need an ORDER BY after a GROUP BY

2017-08-24 14:38 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: > > 2017-08-24 11:29 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: > >> Cecil Westerhof wrote: > >>> But when I leave the ORDER BY out in this case, the res

Re: [sqlite] Do you really need an ORDER BY after a GROUP BY

2017-08-24 11:29 GMT+02:00 Clemens Ladisch <clem...@ladisch.de>: > Cecil Westerhof wrote: > > I always use an ORDER BY after a GROUP BY. > > Without an ORDER BY, there is no guarantee that the result has any > specific order (in SQLite and in any other SQL database). &g

[sqlite] Better way to use a large constant

iser gives a value between 1 and 37. I use: (250 * 1000 * 1000 * 1000 * 1000 * 1000) because I find that more clear as: ​25​ ​But is there a better way?​ -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

Re: [sqlite] [EXTERNAL] Better way to use a large constant

ilinglists.sqlite.org] > Im Auftrag von Cecil Westerhof > Gesendet: Dienstag, 05. September 2017 13:49 > An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Betreff: [EXTERNAL] [sqlite] Better way to use a large constant > > I have the following query: > SELECT

[sqlite] Sharing data between desktop and Android

I am thinking about writing some Android applications. I would like to share data between the phone (or tablet) and de desktop. What is the best way to do this? In a way that would also be convenient for other people. -- Cecil Westerhof ___ sqlite

Re: [sqlite] Good resources for TCL/TK

2017-12-04 14:33 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > > > 2017-11-19 23:00 GMT+01:00 jungle boogie <jungleboog...@gmail.com>: > >> Thus said Cecil Westerhof on Sat, 18 Nov 2017 14:43:23 +0100 >> >>> I found the benefits for

[sqlite] Tcl script to get temperature statistics

-+-- 42.0 |96 41.5 | 161 41.0 |96 40.5 | 8 -----+------ SubTotal | 361 -+-- Total | 1440 -+-- If people are interested I can share some more. -- Cecil Wes

Re: [sqlite] Starting with TCL

xpr ${i} + 1] \ [dict get [lindex $teaList ${i}] Tea] \ [dict get [lindex $teaList ${i}] LastUsed] \ [dict get [lindex $teaList ${i}] Location] \ [dict get [lindex $teaList ${i}] Randomiser]] incr i } This does what

Re: [sqlite] Starting with TCL

ng instead of an array. How do I get it filled as an array? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Starting with TCL

2017-11-17 9:38 GMT+01:00 Dan Kennedy <danielk1...@gmail.com>: > On 11/17/2017 03:20 PM, Cecil Westerhof wrote: > >> The folowing works: >> db eval ${getTeasToDrinkStr} { >> puts [format "%-30s %-10s %2s %d" ${Tea} ${Last Used} ${Location} &

Re: [sqlite] Starting with TCL

​In Bash I can use: continue 2 ​to continue not the current loop, but the loop surrounding it. This does not work in TCL. Is there another way to do this? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Starting with TCL

FROM teaInStock ORDER BY LastUsed DESC LIMIT? ; } ​In Java I would do something like: psSel.setInt(1, nrToFetch);​ ​How do I do this in TCL?​ -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users

Re: [sqlite] How not to let random be calculated again and again and

2017-11-06 11:11 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > 2017-11-06 10:39 GMT+01:00 Keith Medcalf <kmedc...@dessus.com>: > >> >> The easiest way is likely to make the query so that it cannot be >> flattened by adding an ORDER BY (that does no

Re: [sqlite] Starting with TCL

2017-11-17 12:43 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > I have the following: > set getLatestTeasStr { > SELECT Tea > FROM teaInStock > ORDER BY LastUsed DESC > LIMIT5 > ; > } > > Bu

Re: [sqlite] Starting with TCL

FROM ( SELECT * ,abs(random()) / CAST(1.4E18 AS INTEGER) AS Randomiser FROM teaInStock ORDER BY LastUsed ) ORDER BY randomiser + IFNULL(JULIANDAY(LastUsed), 0) ASC LIMIT:limitNr " -- Cecil Wester

[sqlite] Good resources for TCL/TK

I found the benefits for TCL/TK. But this is a SQLite mailing list, so not the right place to ask questions if it is not connected to SQLite also. What would be good resources for TCL/TK? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Good resources for TCL/TK

2017-11-18 15:14 GMT+01:00 Eric <e...@deptj.eu>: > On Sat, 18 Nov 2017 14:43:23 +0100, Cecil Westerhof < > cldwester...@gmail.com> wrote: > > I found the benefits for TCL/TK. But this is a SQLite mailing list, so > not > > the right place to ask questions if i

Re: [sqlite] Starting with TCL

2017-11-17 5:38 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>: > setsqliteVersion [sqlite3 -version] > ​By the way, I think it is a good idea to amend: https://sqlite.org/tclsqlite.html to show this possibility. -- Cec

Re: [sqlite] Starting with TCL

2017-11-16 18:44 GMT+01:00 Peter Da Silva <peter.dasi...@flightaware.com>: > > On 11/16/17, 11:37 AM, "sqlite-users on behalf of Cecil Westerhof" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of > cldwester...@gmail.com> wrote: > > Wh

[sqlite] Starting with TCL

aInStock} { puts $Tea, $Location }" I would like something like: Brandnetel 2017-11-16 1 Oolong 2017-10-29 2 Goudsbloem 2017-10-22 3 Jasmijn … And probably another complication: one of the columns is called: "Last Used". -- Cecil Westerhof

Re: [sqlite] Starting with TCL

2017-11-16 22:20 GMT+01:00 Richard Hipp <d...@sqlite.org>: > On 11/16/17, Cecil Westerhof <cldwester...@gmail.com> wrote: > > ​Is it possible to get the library version before connecting to a > database? > > puts [sqlite -version] > ​Combining yours and Eric's ve

Re: [sqlite] Starting with TCL

? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How not to let random be calculated again and again and

uot;2458047.5" "2017-10-17""2" "5""2458048.5" "2017-10-20""3""1""2458048.5" Is there a way to generate Randomiser in such a way it is only calculated once pro record? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How not to let random be calculated again and again and

“DB Browser for SQLite” which uses 3.15.2. I am not sure in which programming language the real version will be implemented, but it will probably use a version near that one. For example my Java uses 3.20.0. > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mai

Re: [sqlite] Good resources for TCL/TK

2017-11-19 23:00 GMT+01:00 jungle boogie <jungleboog...@gmail.com>: > Thus said Cecil Westerhof on Sat, 18 Nov 2017 14:43:23 +0100 > >> I found the benefits for TCL/TK. But this is a SQLite mailing list, so not >> the right place to ask questions if it is not connected

Re: [sqlite] Good resources for TCL/TK

aluating {exec {swapon --noheadings --show}} or: exec swapon {--noheadings --show} swapon: unrecognized option '--noheadings --show' ​ On Dec 4, 2017 8:27 AM, "Cecil Westerhof" <cldwester...@gmail.com> wrote: > > > 2017-12-04 15:24 GMT+01:00 Gerry Snyder <mesmerizer...@gma

Re: [sqlite] Good resources for TCL/TK

2017-12-04 15:24 GMT+01:00 Gerry Snyder <mesmerizer...@gmail.com>: > It is always a good idea to put the arguments of [expr] in braces. That way > they are byte-compiled. > ​You mean like: exec {swapon} (--noheadings} {--show} --

[sqlite] sqlite3_analyzer for Debian

I was looking at: Tcl'2017 - SQLite's use of Tcl (Richard Hipp) There is talk about the sqlite3_analyzer. But I do not have this on my Debian system. Is that only for Windows? -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users

[sqlite] How to store as integer

type = 'cpu-temp' AND date = '2017-12-06' I see that the temperature is saved as text. In the past I had a script like this in Python who would save the temperature as real. What do I need to change to let this script save it as real also? -- Cecil Westerhof ___

Re: [sqlite] How to store as integer

ence. ​ On Wed, Dec 6, 2017 at 11:09 AM, Cecil Westerhof <cldwester...@gmail.com> > wrote: > > > I have the following tcl script: > > #!/usr/bin/env tclsh > > > > ### Improvements > > # Get database from conf-file > > > > > >

Re: [sqlite] How to store as integer

2017-12-06 15:46 GMT+01:00 Peter Da Silva <peter.dasi...@flightaware.com>: > I’d recommend expr {double($temp)} so the bytecode compiler can optimize > the expression. > > On 12/6/17, 8:40 AM, "sqlite-users on behalf of Cecil Westerhof" < > sqlite-users-boun...

Re: [sqlite] How to store as integer

2017-12-06 14:58 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > > > On 6 Dec 2017, at 1:19pm, Cecil Westerhof <cldwester...@gmail.com> wrote: > > >message NOT NULL > > Given thqt you want the "message" stored as REAL

[sqlite] Only see unused when there are unused records

,COUNT(*)AS NoUsed FROM quotes WHEREtotalUsed == 'unused' UNION ALL SELECT 'Total' AS Type ,COUNT(*) AS NoUsed FROM quotes ) WHERENoUsed > 0 Is this correct, or is there a better way? -- Cecil Wester

Re: [sqlite] This list is getting spammed again

n my message.​ -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] This list is getting spammed again

2018-05-11 11:12 GMT+02:00 Cecil Westerhof <cldwester...@gmail.com>: > 2018-05-10 1:09 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > >> >> >> On 9 May 2018, at 9:37pm, Cecil Westerhof <cldwester...@gmail.com> wrote: >> >> > ​I am

Re: [sqlite] This list is getting spammed again

2018-05-10 1:09 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > > > On 9 May 2018, at 9:37pm, Cecil Westerhof <cldwester...@gmail.com> wrote: > > > ​I am bitten by it also now. I posted a question and within two minutes I > > got a spam message​ > > I

Re: [sqlite] Check Constraint

2018-06-12 12:38 GMT+02:00 Clemens Ladisch : > Cecil Westerhof wrote: > > I want to create a field that only has values that consist of letters, > > numbers end '-'. So no spaces, quotes or special characters like: '@%$!'. > > What is the best way to write this check con

[sqlite] Check Constraint

I want to create a field that only has values that consist of letters, numbers end '-'. So no spaces, quotes or special characters like: '@%$!'. What is the best way to write this check constraint? -- Cecil Westerhof ___ sqlite-users mailing list

[sqlite] Tee to a table

At the moment I have a script where I send the output of a ffmpeg command to the terminal and a file. Is it possible to send the output to a SQLite table. I like to use tcl for this. -- Cecil Westerhof ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Tee to a table

On 2/1/18, 2:25 PM, "sqlite-users on behalf of Cecil Westerhof" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of > cldwester...@gmail.com> wrote: > > At the moment I have a script where I send the output of a ffmpeg > command > to the terminal

Re: [sqlite] Tee to a table

2018-02-01 21:42 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > On 1 Feb 2018, at 8:25pm, Cecil Westerhof <cldwester...@gmail.com> wrote: > > > At the moment I have a script where I send the output of a ffmpeg command > > to the terminal and a file. Is it possible

<    1   2   3   4   >