Re: [sqlite] Bug report: USBAN failure

On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote: > > Do you have a standard that allows NULL? The one I quoted does not. Note: I'll have to double check my copy of the C90 standard document, but my re-reading of the C99 quote leads me to the conclusion that NULL is a valid pointer by definition

Re: [sqlite] Bug report: USBAN failure

On Dec 3, 2014 12:57 AM, "Clemens Ladisch" wrote: > > James K. Lowden wrote: > > /* Copy N bytes of SRC to DEST. */ > > extern void *memcpy (void *__restrict __dest, > > __const void *__restrict __src, size_t __n) > > __THROW __nonnull ((1, 2)); > > > > IIUC the declarat

Re: [sqlite] Locking errors on network

urse, it would no longer be a zero configuration completely embedded system, but it would be a fairly minimal shim. Of course, it would itself require debugging, so it's not like it would be a magical solution. Still, if the SQLite "service" just exposed a virtual block device with accur

Re: [sqlite] Locking errors on network

and best wishes, > > Justin Clift > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fw: Database is locked exceptions

't know enough about how it works. Perhaps somebody > else has a suggestion. Or perhaps you can contact the authors of that web > page and ask them. > > > Simon. > _______ > sqlite-users mailing list > sqlite-users@sqlite.org > http:

Re: [sqlite] Division accuracy

ble hi = 2.0; int count = 0; while (lo != hi) { double mid = (lo + hi) / 2.0; printf("%d %f\n", ++count, mid); lo = mid; } return 0; } -- Scott Robison ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] How preserve the string metric in an extension.

the original poster said "I don't understand why this doesn't work", and I think the obvious reason to that is inexperience (at the very least inexperience with SQLite). Then the statement "I don't understand why you expected nonsense to work", which I think i

Re: [sqlite] How preserve the string metric in an extension.

rry for opening such a can of worms. You'll note I haven't made these types of comments with regard to people asking questions that seem obviously to be for homework problems or for deep explanations of the innards of exactly how VDBE works. In this case I didn't think the quest

Re: [sqlite] How preserve the string metric in an extension.

eant, not someone trying to get free homework "assistance" or software consulting. -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] presentation about ordering and atomicity of filesystems

On Sat, Sep 13, 2014 at 2:53 PM, Howard Chu wrote: > Scott Robison wrote: > >> On Sat, Sep 13, 2014 at 2:24 PM, Howard Chu wrote: >> >> Scott Robison wrote: >>> >>> A couple of academic thoughts. >>>> >>>> >>&

Re: [sqlite] presentation about ordering and atomicity of filesystems

On Sat, Sep 13, 2014 at 2:24 PM, Howard Chu wrote: > Scott Robison wrote: > >> A couple of academic thoughts. >> > >> 1. If one wanted to embed the journal within the database, would it be >> adequate to reserve a specific page as the "root" page of the

Re: [sqlite] presentation about ordering and atomicity of filesystems

true just of big expensive business class machines. At the very least (and I suspect more) Commodore 8-bit DOS (which was embedded within a smart drive with its very own dedicated CPU & RAM) supported (essentially) sequential byte stream files (no random seeking for these!) and random access

Re: [sqlite] presentation about ordering and atomicity of filesystems

o accomplish this? Seek to "really big constant offset" and do all journaling operations at that point, allowing the operating system to manage actual disk allocation? If this were possible, deleting the journal would be a "fast" truncate operation. A custom VFS might be able to prov

Re: [sqlite] presentation about ordering and atomicity of filesystems

s as keys and their contents as values. I seem to recall him later regretting this choice (in part, anyway) but I always thought there was a certain elegance to that solution. It's not perfect, but what is? -- Scott Robison ___ sqlite-users mailing list

Re: [sqlite] presentation about ordering and atomicity of filesystems

bility? If you agree can you state what it was (a specific flaw or a documented limitation as he mentioned was the case for the atomicity vulnerability for postgresql)? Just curious since he didn't go into great detail given the amount of ground he had to cover. -- Scott Robison __

Re: [sqlite] fts5

s, and we were indexing millions of documents. -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] papercut wish list : a PRAGMA encoding='UTF-8-SIG'

soon. Both approaches have pros and cons, though I would maintain that external metadata that unambiguously identifies the text encoding is by far the best option, far preferable to guessing, no matter how high the confidence factor is that the guess is correct. -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] papercut wish list : a PRAGMA encoding='UTF-8-SIG'

On Wed, Sep 3, 2014 at 2:03 PM, big stone wrote: > ... unless I'm fooled by the sqlite.exe dos output and it's working already > as I hope. > > (Oups) > The pragma encoding only controls the storage format of text strings, I don't believe it has any impact on impo

Re: [sqlite] Not SQLite related, but, SQLite Mailing List related

On Tue, Aug 12, 2014 at 8:16 PM, jose isaias cabrera < jic...@cinops.xerox.com> wrote: > "Stephen Chrzanowski" wrote... > > *thinks back to IE1 and Netscape* >> >> Its just starting?? >> > > True. (WebCrawler anyone?) > I'm pretty sure vi vs emacs was the first browser war. Or IBM vs MAC. Or

Re: [sqlite] SQLite version 3.8.6 coming soon

cts straight. > While it is debatable as to whether Texas is part of the south, I too used backwards until an old retired school teacher, who was substituting one day, scared me out of using it anymore. -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL Join question

gt; > True. That's what my footnote number 1 was about. You can also have a > SELECT return fewer rows than are in a table using clauses like WHERE. It > was a simplified explanation. Because it's easier to understand those. > Not sur

Re: [sqlite] SQL Join question

On Mon, Jul 28, 2014 at 4:20 PM, Simon Slavin wrote: > First and most important, a "FROM" clause is required for every "SELECT" > command [1]. So the statement, whatever it's meant to do, definitely needs > to be "FROM" something. There's only two tables used in the example, so it > would have

Re: [sqlite] Send parameter from batch file to sqlite

On Wed, Jul 23, 2014 at 4:28 AM, shweta gk wrote: > Hi SQlite Support Team, > > I have queries to generate csv file written in a export.sql file. I'm > calling export.sql from a batch file. > > One of the queries in export.sql has where clause , to which i have to > send a value from batch file.

Re: [sqlite] Hexadecimal integer literals

uot;Markus Schaber" wrote: > Hi, > > Von: Scott Robison > > > On Wed, Jul 23, 2014 at 9:46 PM, J Decker wrote: > > > > > Seems like adding hex interpreting is just adding code for the sake of > > > adding code. > > > Unless the data is coming

Re: [sqlite] Hexadecimal integer literals

using the C syntax. I like being able to prefix a decimal integer with 0 and not having it change the meaning (which can't be done in C). -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Importing a cvs file

ly the EBCDIC codes for IFS IGS IRS IUS are the same as the ASCI > FS GS RS US respectively. Depends on the species of dinosaur in your pen :) > > >Simon. > > > > > > ___ &

Re: [sqlite] capturing and testing a hot journal

ing to say to you, because > you > >>>>>>>>>>> already made your judgement without giving a right of answer, > so be it. > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> On Tue, Jul 15, 2014 at 4:18 PM, RSmith > >>>>>>>>>>> wrote: > >>>>>

Re: [sqlite] SQLite legacy licenses

On Mon, Jun 16, 2014 at 5:44 PM, Richard Hipp wrote: > On Mon, Jun 16, 2014 at 7:01 PM, Scott Robison > wrote: > > > In a discussion with my manager today, he inquired if SQLite has always > > been public domain. I said I thought at least all SQLite 3 releases have >

[sqlite] SQLite legacy licenses

before contributions to the official project are accepted. So my questions are: 1. Just how long has SQLite been public domain? 2. Not that I intend to use it, but are legacy source code tarballs available? It might be interesting to look at some of the early history for fun. -- Scott Robison

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On May 28, 2014 12:36 PM, "Drago, William @ MWG - NARDAEAST" > Don't modern compilers consider what effects the speed optimizations will have on the pipeline and the cache and optimize accordingly? I think they might try to in a broad way, but we live in a world with multiple models of CPUs from m

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Wed, May 28, 2014 at 12:26 PM, Warren Young wrote: > On 5/28/2014 11:20, jose isaias cabrera wrote: > >> >> I would rather have the speed >> then the size. >> > > Many years ago, I read an article written by a Microsoft employee where > they said they built Windows' own binaries optimized for

Re: [sqlite] Simple Select from IN - from a newbie.

nly clueless, but had no interest in learning how things work, they just wanted other people to do their work for them. Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Two equivalent queries with very different perf

On Sun, May 25, 2014 at 4:22 PM, Andrew Arnott wrote: > It isn't clear why the slow one would be so much slower. In my naïve > opinion the query analyze in SQLite should recognize and treat these two as > the same but obviously the execution strategy is vastly different. Is there > an opportunity

Re: [sqlite] Order Statistic Trees

On Sat, May 17, 2014 at 9:41 PM, Scott Robison wrote: > On May 17, 2014 8:40 PM, "Simon Slavin" wrote: > > Just want to check: this is what it sounds like, right ? Your user has > a window open where they are scrolling through the table, ordered by > SomeColumn. You

Re: [sqlite] SQLite Database Browser officially moved to GitHub

gt; We know... no other OS would report CPU usage as 400%... :) > > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Rob

Re: [sqlite] Order Statistic Trees

Sorry for the incomplete post, stupid phone. On May 17, 2014 8:40 PM, "Simon Slavin" wrote: > Just want to check: this is what it sounds like, right ? Your user has a window open where they are scrolling through the table, ordered by SomeColumn. You need to know whether the window needs to chan

Re: [sqlite] Order Statistic Trees

Sorry, I typoed the second query. Should have been <=. On May 17, 2014 8:40 PM, "Simon Slavin" wrote: > > On 18 May 2014, at 3:19am, Scott Robison wrote: > > > It is easy enough to read the source data and insert it into a table. It > is > > easy enough to

[sqlite] Order Statistic Trees

mn = value ORDER BY SomeColumn As I understand it, both of these have to execute the full query and calculate the result set in order to do return a result. I need something that gives me log N access (or better) to elements by key and numeric index. Again, my apologies for the length of this. I c

Re: [sqlite] FTS3/4 merge function behaviour when deleting rows

that consists of only the "live active" records in a "leaky" database so as to compare what the size could/should be if the "current data set" had been created with zero deletions of data along the way? -- Scott Robison __

Re: [sqlite] select 1 where 1 - 1;

On Mon, May 5, 2014 at 9:07 PM, Jay Kreibich wrote: > > On May 5, 2014, at 6:16 PM, Scott Robison wrote: > > > On Mon, May 5, 2014 at 4:15 PM, Jay Kreibich wrote: > > > >> So far this whole discussion seems to boiled down to the fact that > SQLite > &

Re: [sqlite] select 1 where 1 - 1;

On Mon, May 5, 2014 at 4:15 PM, Jay Kreibich wrote: > So far this whole discussion seems to boiled down to the fact that SQLite > doesn’t have a native Boolean type. That’s it. No, it doesn’t. Once we > accept that, everything else makes perfect sense based off existing > computer languages an

Re: [sqlite] select 1 where 1 - 1;

On May 5, 2014 11:36 AM, "Stephan Beal" wrote: > > I mean ‘where 1’, or ‘where ‘1 - 1’, or ‘where null’, or ‘where 0 / 0’, or > > any of this nonsense. There is nothing to compare. It’s nonsensical. > > Oh, but there is: 1-1 is an expression, the result of which is integer 0 > (as opposed to strin

Re: [sqlite] how can i omit the number/0 in the result in sqlite?

t;> 0 ORDER BY NUM1/NUM2 ASC; Off the top of my head, I think that should do it. -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] if possible point another table

I would think this would make an excellent virtual table extension. On Apr 3, 2014 11:03 PM, "Darren Duncan" wrote: > On 2014-04-03, 7:19 PM, Andy Goth wrote: > >> I don't believe this can be done in pure SQL since table names are not >> values. That doesn't mean it can't be done, though you wil

Re: [sqlite] Primary key used in compound index

the following snippets: ::= " ::= Since it is not the standard, it could be wrong, but my experience indicates that double quotes are never "officially" a string delimiter, only an identifier delimiter. Implementations vary, of course. In any case, I agree with you abo

Re: [sqlite] Primary key used in compound index

On Wed, Mar 26, 2014 at 6:12 PM, RSmith wrote: > > Also, why all the Double-quotes around your column names in the create > statement? I'm sure it will work but it isn't the right SQL compatible > method, either use SQL backquotes or no quotes. Single and double quotes > (preferably single quotes

Re: [sqlite] SQL quine using with

Here is one (sorta with inventive rule interpretation): sqlite3 /dev/null 'Error: near "Error": syntax error' Generates the command as output (at least with 3.8.2 from ports on FreeBSD): Error: near "Error": syntax errors Thank you! [takes bow] On Mar 8, 2014 12:16 PM, "Zsbán Ambrus" wrote: >

Re: [sqlite] HTML Tokenizer

My current project needed to tokenize the text in HTML without the tags. The easy solution for us was to license a library from Chilkat that supported text extraction then tokenize that. I'm on my phone at the moment but could supply more details later if desired. SDR On Feb 13, 2014 1:02 PM, "Dav

Re: [sqlite] Fine tuning table indexes

ld be interesting to see > when and where that single index comes into play when multiple indexes are > defined. > > > On Fri, Jan 31, 2014 at 11:01 PM, Scott Robison >wrote: > > > On Fri, Jan 31, 2014 at 8:49 PM, Stephen Chrzanowski < > pontia...@gmail.com> > >

Re: [sqlite] Fine tuning table indexes

ound parameters *and* information that led to creation of ideal indexes (indices?). You might consider something similar (and I'm really hoping such functionality doesn't already exist in SQLite as shipped, because I'll feel foolish for reinventing the wheel). -- Scott Robison

Re: [sqlite] Order of rows in a VALUES select expression

> sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] windows 8.1 cerification - APTCA Check failed

On Wed, Jan 29, 2014 at 1:21 AM, Uwe Seibt wrote: > > Dear sirs, > > how is it possible to pass the APTCA Check test? Our Application is using .NET Framework 2.0 and .NET Framework 3.5 I doubt you'll get a lot of feedback on this, as this is the "SQLite mailing list" not the "Windows .NET Applica

Re: [sqlite] Recursive query?

> That's great news! This will be a serious step up in feature set for SQLite, both in ease of use and power, I look forward to it. -- Darren Duncan It will be available in the SQLite Gold edition for $10,000. {jk} ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Concrete example of corruption

at 12:00am, Scott Robison wrote: > > > Might there be a way to implement a custom VFS for Mac to deal with this? > > One problem is that to be able to call fsevents you have to link in a huge > amount of the standard Mac support some of which isn't accessible from some >

Re: [sqlite] Concrete example of corruption

Might there be a way to implement a custom VFS for Mac to deal with this? On Thu, Dec 5, 2013 at 3:55 PM, William Garrison <1billgarri...@gmail.com>wrote: > On Thursday, December 5, 2013, L. Wood wrote: > > > A fact of reality: Documents can be moved by the program's users. > > > > The database

Re: [sqlite] Using pragma user_version when doing updates

Could be an interesting virtual table module... On Tue, Sep 17, 2013 at 6:24 PM, Darren Duncan wrote: > On 2013.09.17 4:28 PM, Richard Hipp wrote: > >> On Tue, Sep 17, 2013 at 7:13 PM, Amit wrote: >> >> Hello, >>> >>> I would like to run the following update statement >>> if pragma user_versio

Re: [sqlite] Hints for the query planner

I think I prefer something along the lines of "unlikely" or "likely". The problem with a term like "selective" (at least in my brain) is that it doesn't imply (for the single argument version) in what way it is being selective. If a negative form of the magic function is used ("unlikely", "seldom"

Re: [sqlite] Query preperation time does not scale linearly with growth of no. of tables

Two things: 1. The longer the table names, the longer it will take to compute the hash of each table name. 2. Because the entire schema must be reprocessed after each change, all the table names will be rehashed after each table has been created. Creating 10,000 tables will result in re-reading

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

On Sun, Jul 7, 2013 at 3:31 PM, Alex Bowden wrote: > > State why you don't > > like it and move on. Don't contribute any code that might address the > idea. > > The rest? It is not useful. > > It is useful. It help stops people who don't understand the concept of > relational, screwing up the sys

Re: [sqlite] Is there a way to return the row number? (NOT the rowid)

On Sun, Jul 7, 2013 at 11:34 AM, Keith Medcalf wrote: > > Despite the long diatribes you have not indicated a single case in which > the set ordinal of the row would be of any use whatsoever. > > For 40 years we have gotten on without it, so yes, it is only for you > newbies that somehow think th

Re: [sqlite] Performance regression since 3.7.15

He said using the NGQP snapshot the query indeed runs fast. I think you mentally inserted some negation in that statement, DRH. On Fri, Jun 28, 2013 at 8:47 AM, Richard Hipp wrote: > On Thu, Jun 27, 2013 at 6:50 PM, Elan Feingold wrote: > > > >> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28

Re: [sqlite] Slowness with FTS Queries and non-FTS tables

On Tue, May 7, 2013 at 1:53 PM, Dan Kennedy wrote: > > Another way to go is to use the 'merge=X,Y' and 'automerge=0' commands: > > > http://www.sqlite.org/fts3.**html#mergecmd > > I tried a few variations on merging and automerging, and they did help t

Re: [sqlite] Slowness with FTS Queries and non-FTS tables

On Tue, 30 Apr 2013 23:56:35 -0700 (PDT) Paul Vercellotti wrote: > We've got some trouble with FTS4 queries taking too long in which > we're looking for a subset of matching records in the FTS table, as > narrowed by a non-FTS table. > {details snipped} I've recently had to work through a simila

Re: [sqlite] 64bit compatibility warnings

On 4/8/2013 5:41 AM, Richard Hipp wrote: Line 6766 u.bc.r.flags = (u16)(UNPACKED_INCRKEY * (1 & (u.bc.oc - OP_SeekLt))); WARNING: conversion from 'u16' to 'u8', possible loss of data Line 71133 iBuf = p->iReadOff % p->nBuffer; WARNING: conversion from 'i64' to 'int', possible l

<    1   2   3   4