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

On 29 Jan 2020, at 22:54, Brian Curley wrote: > The marketing buzzword usage will disappear... long before we’ll have the bike shed painted! /N ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] how to pass -Dxxx compile option

On 9 Jan 2020, at 9:41, Xingwei Lin wrote: > I always use ./configure && make to compile sqlite. > > ./configure can add some compile options, but I don't know how to add -Dxxx > option in this compilation process. I don't know (since I've never needed to build SQLite), but can offer a hint

Re: [sqlite] Question about floating point

advertised as) supported. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible NULL DEREFERENCES and DEAD STORES found by static analysis tools

s: Variants of this question crop up from time to time. Please look in the mailing-list archives for replies from Richard Hipp dated 22 January 2014 and 23 March 2015, sent in response to earlier similar reports. Best regards, Niall O'Reilly signature.asc Description: OpenPGP digit

Re: [sqlite] How to download SQLite for Mac?

cOS (SQLite 3.16.0) is quite a bit behind the current one. I use the Homebrew package manager, and see that it has installed version 3.24.0 for me, and has taken care not to interfere with what Apple has installed. I hope this helps. Niall O'Reilly signature.asc Description: OpenPGP digi

Re: [sqlite] Configuring csv extension to use '; ' as column delimiter instead of ',' ?

has been done already, I think that some wrapping around this might do the job, since the separator is parameterized: https://docs.python.org/3.6/library/csv.html Like Simon, > I'd do it myself but I don't use Windows. 8-) Niall O'Reilly signature.asc Description: OpenPGP digit

Re: [sqlite] Documentation update

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.  :) 8-) /Niall signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list

Re: [sqlite] Documentation update

_ ...". Best regards, Niall O'Reilly signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_column_decltype and max and min

lite/3.21.0/bin/sqlite3 SQLite version 3.21.0 2017-10-24 18:55:49 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> dhcp-162(niall)16: I h

Re: [sqlite] Many ML emails going to GMail's SPAM

Do this: Never send it to Spam Best regards, Niall O'Reilly signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What's the level of B+-Tree ?

ion that this was not the only design optimization I needed. If my use case is actually similar to yours, I'ld suggest you try this too. Best regards, Niall O'Reilly -- Sent from Kaiten Mail. Please excuse my brevity. ___ sqlite-users mailing list sqli

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

On 29 Jun 2017, at 20:19, Peter da Silva wrote: The DECsystem 10 guys also referred to the other subdivisions of their 36 bit words as bytes, sometimes, they could be 6, 7, 8, or 9 bits long. I think they had special instructions for operating on them, but they weren’t directly addressable.

Re: [sqlite] Index list

ording to its estimate of the benefit of doing so. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CREATE TABLE fails

. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] CREATE TABLE fails

nt is to use three columns as a compound primary key) missing parens ['(' ... ')'] around the list of columns after KEY ? I was going to add "missing comma before PRIMARY" as well, but https://www.sqlite.org/lang_createtable.html doesn't seem to indicate that a comma is required between a column-def and a table-constraint. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] creating a table

On 21 Nov 2016, at 21:55, Igor Korot wrote: > You are of course correct. It does depend on an application. > However, I tried to explain the SQLite and its paradigm in terms of > the dBase/FoxPro. You were correct also, Igor, and gave good advice. Best regards, Niall

Re: [sqlite] creating a table

this helps a little. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Select older or not selected records

the 'last used on' date, the first item in each cycle is guaranteed to be the same, and the second, and so on. To do what I think he wants, he'll need an additional selection criterion or two. Best regards, Niall O'Reilly ___ sqlite-use

Re: [sqlite] Autoincrement sequence not updated by UPDATE

e is a bug, and I'ld prefer to see the behaviour reported by the OP as buggy, rather than what is documented. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailma

Re: [sqlite] smartest way to exchange a sqlite3 database with another empty

t. When reading the database, your application will need to identify and open as many files as necessary so as to avoid ignoring relevant data. I hope this helps. Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://ma

Re: [sqlite] a couple of pre-initial questions

it for download and installation. Otherwise, you can open a terminal window and issue the command sudo apt-get install sqlite3 I hope this helps. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Sweet 16

On 29 May 2016, at 18:28, Richard Hipp wrote: > The first check-in of SQLite code occurred 16 years ago today. > https://www.sqlite.org/src/timeline?c=2000-05-29 Congratulations! Keep up the great work. Niall O'Reilly ___ sqlite-users m

[sqlite] Multiple line command pasted to shell is split in history

UP/UP/RETURN. Best regards, Niall O'Reilly

[sqlite] How to order by absolute value ?

On 5 Apr 2016, at 10:59, R Smith wrote: > > The documentation is correct and the fault is not that the ORDER BY > did not only apply to the last select - the problem is more that the > ORDER BY abs(num) did not know that "num" is a valid column name in > the compound select - which seems

[sqlite] How to order by absolute value ?

w.sqlite.org/lang_select.html seems to suggest that ORDER BY covers the entire compound SELECT. I wonder whether this is a documentation bug or just me. Best regards, Niall O'Reilly

[sqlite] website documentation wording

On Fri, 04 Dec 2015 18:46:27 +, Keith Medcalf wrote: > > Intel's Management has decided -- for the imperfect tense. > Intel's Managemant have decided -- for the past perfect tense. Eh? These examples show the same tense. Niall O'Reilly

[sqlite] [AGAIN] SQLite on network share

consequences may cost in your case. People on this mailing list can't do your risk assessment or impact analysis for you. Best regards, Niall O'Reilly

[sqlite] version 3.9.0 doc errors

On Thu, 08 Oct 2015 21:12:51 +0100, R.Smith wrote: > > > *** Correction *** It's not, but you don't want to get me started. 8-) > On 2015-10-08 10:03 PM, R.Smith wrote: > > > > To clarify, when used as an adverb to modify a verb, you may well > > add the s - such as saying "I'm moving

[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

seems to me that it would be useful to include them, flagged as "commercial only". Best regards Niall O'Reilly

[sqlite] Regarding testing

On Mon, 27 Apr 2015 17:51:43 +0100, Drago, William @ CSG - NARDA-MITEQ wrote: > > Never saw this before. LMAO. Will put it too good use... +1 Ossum!

Re: [sqlite] Should .dump preserve foreign_keys pragma?

es theory and > practice are combined: nothing works and no one knows why. I've been appreciating that sig for a while, and am glad to have a real message as an opportunity for saying so! Best regards, Niall O'Reilly ___ sqlite-users mailing list

Re: [sqlite] Should .dump preserve foreign_keys pragma?

At Thu, 8 Jan 2015 13:46:37 +, Simon Slavin wrote: > > > On 8 Jan 2015, at 1:38pm, Niall O'Reilly <niall.orei...@ucd.ie> wrote: > > > I'ld have expected the foreign_keys pragma setting to have been > > preserved. > > That makes sense in terms of how

[sqlite] Should .dump preserve foreign_keys pragma?

rsion shown is currently bundled with Apple's OSX Yosemite. I've checked subsequent release history for changes and not found any of relevance. Thanks in anticipation for any enlightenment. Best regards, Niall O'Reilly ___ sqlite-users mailing l

Re: [sqlite] Is there a way to load a blob from the shell?

has it, just checked. But I'd never heard of it either. Solaris too, even since before SunOS was re-branded "Solaris". ATB Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow select from database

I expect you need an index on whatever TIMESTAMP is. If you choose to use a compound key for the index, you'll need to take care to make TIMESTAMP the first component of this key. I hope this helps. Best regards, Niall O'Reilly ___ sqlite-users ma

Re: [sqlite] SQLite 2013 retrospective

ut 2014 and beyond. Congratulations on a busy and productive year! > Happy New Year to all. The same to you, and to everyone on the list ... Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

[sqlite] Trouble with sqlite3 shell on OSX Mavericks

Hello. The demonstration script for a loadable extension I’m working on uses the sqlite3 command-line shell, and works as expected on Ubuntu. I’m at the stage of checking portability by building and demonstrating it on OSX. The shell bundled with OSX 10.9.1 (Mavericks) seems to be a custom

Re: [sqlite] sqlite does not order greek characters correctly

ms (if I'm reading correctly) to occupy the Unicode code-point just before non-final sigma (so: ... ρ ς σ τ ..., ignoring upper case). I guess that's what you would want? Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Select with dates

On 16 Sep 2013, at 18:43, Petite Abeille wrote: > What about simply using not overlapping intervals and call it a day? Sure! WFM. I thought that was what I was suggesting. 8-) /Niall ___ sqlite-users mailing list

Re: [sqlite] Select with dates

On 14 Sep 2013, at 18:09, Petite Abeille wrote: > Yeah... not sure why people are doing that to themselves though :D Consecutive closed intervals overlap. Depending on the application, this may be a problem; it can be avoided by using half-open ones. /N

Re: [sqlite] Update field from standard input with sqlite3 command line utility

e, I might use a Perl script based on the DBI module (see, for example and without endorsement, http://zetcode.com/db/sqliteperltutorial/). I hope this helps Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.

Re: [sqlite] BETWEEN and explicit collation assignment

ds of BETWEEN; one should rather be able to rely on the collation declared for the first one. The observed behaviour indicates that precisely the opposite is true in practice. AFAICS, either the code or the documentation is broken, and either one needs to be corrected. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Threading makes SQLite 3x slower??

atency. Have you a way of looking at the activity queue for your disk subsystem? If so, what does it tell you? Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m

Re: [sqlite] Using in-memory DBs of the form: "file:memdb1?mode=memory=shared" (via Perl, DBD::SQLite & DBI)

On 19 Jul 2013, at 09:36, sqlite.20.browse...@xoxy.net wrote: > Anyone here using SQLite via Perl & DBI & DBD::SQLite? Yes, but not with an in-memory database. Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] sqlite3: .import command handles quotation incorrectly

ryone; I may be in a minority of one, but I can't help thinking that it would be "really easy and really simple" for anyone who routinely encounters a particular "troublesome" CSV format to write a bespoke normalizer addressing their particul

Re: [sqlite] Performance with journal_mode = off

On 28 Mar 2013, at 12:09, Jeff Archer wrote: > But my most basic question remains. Why is single transaction faster > than PRAGMA journal_mode = off? > > Seems to me that with no journal there should only be single set of > writes to the actual db and that journaling would double the number of

Re: [sqlite] SOLVED: Custom collation method works for comparison, not for ORDER BY

On 06/12/12 14:32, Niall O'Reilly wrote: > On 6 Dec 2012, at 14:14, Igor Tandetnik wrote: > > > Your code assumes, in several places, that strings passed to collation > > function are NUL-terminated. They don't have to be - that's why lengths are > > also passed. I t

Re: [sqlite] Custom collation method works for comparison, not for ORDER BY

On 6 Dec 2012, at 14:14, Igor Tandetnik wrote: > Your code assumes, in several places, that strings passed to collation > function are NUL-terminated. They don't have to be - that's why lengths are > also passed. I think this may be causing the problem you are seeing: when the > string comes

Re: [sqlite] Custom collation method works for comparison, not for ORDER BY

On 6 Dec 2012, at 05:21, Dan Kennedy wrote: > It still seems likely that the collation returns the wrong result > some circumstances. Posting the code for it is probably the right > thing to do. Thanks for the encouragement! I've used conditionally compiled sections so that the

Re: [sqlite] Custom collation method works for comparison, not for ORDER BY

On 05/12/12 21:12, Clemens Ladisch wrote: > Do these queries give the correct result? > > select '100A' collate ipaddress < '127.0.0.1'; > select '100A' collate ipaddress < ' ABCD'; > > I.e., does the collation function actually work? Thanks for the helpful suggestions.

[sqlite] Custom collation method works for comparison, not for ORDER BY

3.7.14 tarball and build an up-to-date library before anything else? I feel that sending my code at this stage would be to presume too much on people's interest. Thanks in advance. Niall O'Reilly ___

Re: [sqlite] IP address support (was: Consequences of lexicographic sorting of keys in SQLite4?)

On 11 Jul 2012, at 18:36, Valentin Davydov wrote: > This is for IPv4 at least. No. This is for IPv4 ONLY. That doesn't meet my needs. /Niall ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

On 2 Jul 2012, at 18:20, Jay A. Kreibich wrote: > The idea of using a plugin system to expand database functionality > seems to fit well with the SQLite way of getting things done. > Functions, collations, and virtual tables are already done in a > similar way. Extending that to types seems

Re: [sqlite] IP address support (was: Consequences of lexicographic sorting of keys in SQLite4?)

On 2 Jul 2012, at 17:52, Nico Williams wrote: > So an IPv4 CIDR block like 10.2.93.128/25 would encode as x'0A025D81' > and 10.2.93.128/26 as x'0A025D82', and so on, with 10.2.93.128/32 > encoded as x'0A025D8000' (that's 5 bytes). That is, IPv4 addresses > would require one more byte than

[sqlite] IP address support (was: Consequences of lexicographic sorting of keys in SQLite4?)

On 2 Jul 2012, at 16:13, Nico Williams wrote: > That reminds me: it'd be nice to have a bit string type, since the > correct way to sort IPv4 CIDR blocks is as bit strings. Nice, definitely! > This is also > a proper way to sort IPv6 blocks. Alternatively, it'd be nice to have >

[sqlite] Blobs and ordering [was: Consequences of lexicographic sorting of keys in SQLite4?]

t think the analogy applies. Images belong to a different specialization of the same base class. Thanks again, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

On 2 Jul 2012, at 10:51, Dan Kennedy wrote: > That would be a reasonable use. But the blob in this case will be what, > eight bytes (or 10 in its encoded form)? 10, 18, 34, or 66, depending on which of six classes [*] of object is involved, using the encoding I have in mind at

Re: [sqlite] Consequences of lexicographic sorting of keys in SQLite4?

On 29 Jun 2012, at 23:58, Richard Hipp wrote: > But you know: How often do people use BLOBs as keys? What other SQL > engines other than SQLite even allow BLOBs as keys? Are we trying to > optimize something that is never actually used? For an IPAM application I have on my back

Re: [sqlite] sqlite4: type decl/def discrepancy (w/ fix)

? May make sense. Please don't forget to let us mere users have a trickle of news about v4. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] EXT :Re: Can't create empty database

On 25 Jun 2012, at 13:24, Black, Michael (IS) wrote: > Does the shell compile differently for Mac? Sorry. I've no idea whether it does. SQLite comes bundled with OSX and I haven't had a need to build it from source. Besides, I haven't needed either to upgrade (?) to

Re: [sqlite] Can't create empty database

On 25 Jun 2012, at 12:48, Black, Michael (IS) wrote: > Well...it doesnt' any more on Windows and Linux at least as of 3.7.9 > > The file doesn't get created until you execute at least one command relevant > to it. > > So do a .schema or .dump or such and it creates the empty file. > > Or

Re: [sqlite] Can't create empty database

On 25 Jun 2012, at 11:06, L Anderson wrote: > So then on page 'http://www.sqlite.org/quickstart.html' > under 'Create A New Database', the first bullet: > > 'At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new > database named "test.db". (You can use a different name if

Re: [sqlite] Parameterized SQL

shells can do likewise, but bash is the one I'm familiar with. So, yes and no ... 8-) Good luck! Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Parameterized SQL

On 14 Jun 2012, at 22:16, Udi Karni wrote: > Is there a way to run SQL scripts in the Shell with parameters? > > Something like this? > > set = 2010 > > SELECT COUNT (*) FROM TABLE WHERE YEAR = ; > > ??? I use bash and sqlite3, as in the fragment below. #!/bin/bash #

Re: [sqlite] CSV to SQLite to web page display

would need to pass the data through a database. If I'm not mistaken, Perl has at least one module for reading CSV data; no doubt so have other scripting languages. Sounds like a nice exercise! Best regards, Niall O'

Re: [sqlite] about The open-source Fossil version control system

it for you is not just inappropriate, but simply rude. I'ld prefer not to have to be so brutaly candid; however, I've noticed that other list members have tried to express this more politely, but you seem not to be minded to heed their message.

Re: [sqlite] IPv{4,6} addressing extension

I very much want to unify: it's not common to both IP versions, and it leaves the representation of prefixes mainly to the application. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users

[sqlite] IPv{4,6} addressing extension

by a prefix (perhaps only for IPv4, as a 64-bit integer isn't adequate for doing this with IPv6). I expect to take inspiration from the extensions cited above, as well as from the CPAN Net::IP module. If I'm about to re-invent the wheel, I'ld appreciate a warning. Best regards, Niall O'Reilly

[sqlite] Introduction

well-known IPAM system. Best regards, Niall O'Reilly ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users