[sqlite] Performance comparison between SQLite and SQL Server?

On Mon, Feb 15, 2016 at 9:07 PM, Keith Medcalf wrote: > > On the other hand if you drive either on a road with a speed limit of 30 > miles per hour (and go the speed limit), they both go the same distance in > the same time. > > In other words, inquiring "which gets from one side of town to the

[sqlite] Correlated subquery throwing an error

On Tue, Feb 16, 2016 at 11:44 AM, James K. Lowden wrote: > On Mon, 15 Feb 2016 14:19:12 -0700 > Scott Robison wrote: > > > Each job will take some amount of time to process. The order doesn't > > matter as long as all jobs are eventually processed and you have a >

[sqlite] ASK SQLite algoritm to chose Index

On Sat, Feb 27, 2016 at 10:49 PM, Simon Slavin wrote: > > On 28 Feb 2016, at 5:47am, Keith Medcalf wrote: > > > I do not see a link ... do you see a link? > > I saw no link. > > The OP may not actually be posting to this mailing list. He may be using > a web interface which does the posting

[sqlite] ASK SQLite algoritm to chose Index

And here is a copy of my answer posted at stackoverflow (which assumes the context of the question): A see a few problems here. 1. The first SQL statement (CREATE TABLE ...) is malformed due to an extra comma between the last column and the closing parenthesis. 2. The third SQL

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

ve historical POSIX standards for reference. Does POSIX really *require* an MMU? Certainly Unix like systems were written for 8086 class computers, but given that POSIX was first standardized in 1988 I'm just curious as to whether or not an MMU is a requirement or just really nice to have. -- Scott Robison

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

On Sun, Jan 17, 2016 at 10:09 AM, James K. Lowden wrote: > On Sat, 16 Jan 2016 14:21:26 -0700 > Scott Robison wrote: > > > > Huh. An example of which is the "medium model" of the Intel 8086: > > > 20-bit code pointers and 16-bit data pointers. A machin

[sqlite] POSIX and MMU (was Re: out of the void: xDlSym)

On Sun, Jan 17, 2016 at 1:33 PM, Howard Chu wrote: > Scott Robison wrote: > >> Sorry for the OT diversion, but I'm just curious as I don't have >> historical >> POSIX standards for reference. Does POSIX really *require* an MMU? >> Certainly Unix like systems were wr

[sqlite] Slight problem with sqlite3_compileoption_get

fix on the function name usually means that the function is STDCALL and that the callee will clean up the stack. If for some reason both the caller and callee cleaned up the stack for this function, that would definitely be a problem. -- Scott Robison

[sqlite] sqldiff.c : 2 benign warnings in 64 bits builds

cast. It inlines to a normal cast in cases where there is no danger (non-truncating conversions) and can throw an exception in the case of a truncating or signed conversion that is out of range. Sadly, something like that isn't possible in pure C89. -- Scott Robison

[sqlite] SQLite crashing

being measurable in most cases and I prefer cleaning up explicitly most of time). That being said, delete also invokes destructors which can do far more than just return memory to the C++ free-store. It's not necessarily related to this precise problem, obviously, just a warning flag that popped up in my reading. -- Scott Robison

[sqlite] Wish List for 2016: High Level API for Object Oriented Interactive Languages

e to write crappy code in any language, and it is possible to write elegant / efficient code in most languages. Often the choice is not the language but rather the algorithms implemented. I would never suggest that everyone must use OO, but to suggest it is worthless or never works seems suspect to me. -- Scott Robison

[sqlite] Bug: Successfully committed transaction rolled back after power failure

be a "paranoid" journal mode, where it first zeros out the header ala persist, then truncates the file, then deletes the file. -- Scott Robison

[sqlite] CAST STRING => INTEGER

On Mar 15, 2016 7:33 PM, "Keith Medcalf" wrote: > > > On Tuesday, 15 March, 2016 07:46, James K Lowden wrote > > To my way of thinking, SQLite's handling of giant integers per se > > is an edge case. Because such huge numbers don't normally arise, the > > non-error path (inputs in bounds) almost

[sqlite] Article about pointer abuse in SQLite

written, but not to a later standard (such as ANSI C / C89 / C90 vs C99 or C11 or whatever). It's great to conform to both when reasonable, but it may not always be reasonable (as I can't necessarily conceive of every possibility). -- Scott Robison

[sqlite] Article about pointer abuse in SQLite

On Mar 18, 2016 11:12 PM, "James K. Lowden" wrote: > > On Fri, 18 Mar 2016 16:33:56 -0600 > Scott Robison wrote: > > > I'd rather have code that might use some "undefined behavior" and > > generates the right answer than code that always conformed to d

[sqlite] Article about pointer abuse in SQLite

On Mar 19, 2016 1:19 PM, "James K. Lowden" wrote: > > On Sat, 19 Mar 2016 02:04:35 -0600 > Scott Robison wrote: > > > As he says, there's not real choice between fast and > > > correct > > > > Except that testing can verify something is correct

[sqlite] Article about pointer abuse in SQLite

On Mar 21, 2016 2:48 PM, "Scott Perry" wrote: > > On Mar 21, 2016, at 3:17 AM, Klaas Van B. wrote: > > > >>> On 3/19/16, James K. Lowden wrote: > > > >>> ... If the correctness of the code is > >>> subject to change by the compiler's interpretation of the language, how > >>> is the programmer

[sqlite] Article about pointer abuse in SQLite

Forgive top posting, on my phone. But two points. 1. There is a flag if you want zero initialized memory from HeapAlloc. 2. These types of heaps are private to the process and must be created first. The heap creation process reserves virtual address space and allocates memory on demand from a

[sqlite] SQLite vs GPLed software

I don't have an answer, but given that each linux distro of dozens or hundreds of independently sourced packages has many separate instances of the GPL, that would begin to eat into SQLITE'S lead. But probably not enough to win. On May 2, 2016 5:42 PM, "Richard Hipp" wrote: > There is a

[sqlite] SQLite vs GPLed software

On Mon, May 2, 2016 at 6:10 PM, Richard Hipp wrote: > On 5/2/16, Scott Robison wrote: > > I don't have an answer, but given that each linux distro of dozens or > > hundreds of independently sourced packages has many separate instances of > > the GPL, that would begin to e

[sqlite] Fastest way to backup/copy database?

> > This is going to become a bigger problem for us as the database will > > only get bigger so any advice welcomed. Perhaps, rather than backing up the live data, you create an append only log of each and every query you send to the database. Should you need to restore, you replay the log of

[sqlite] Fastest way to backup/copy database?

t; > > Rob > > > On 4 May 2016, at 16:51, Scott Robison wrote: > > This is going to become a bigger problem for us as the database will >>>> only get bigger so any advice welcomed. >>>> >>> >> Perhaps, rather than backing up the live data,

[sqlite] Fastest way to backup/copy database?

On Wed, May 4, 2016 at 12:38 PM, Dominique Devienne wrote: > On Wed, May 4, 2016 at 5:51 PM, Scott Robison > wrote: > > > > > This is going to become a bigger problem for us as the database will > > > > only get bigger so any advice welcomed. > > >

[sqlite] SELECT DISTINCT question

from s group by city order by x asc); But I'm not a SQL master. Distinct used with group by seems redundant, but again, I might just not understand how they are useful together. -- Scott Robison

[sqlite] SELECT DISTINCT question

> > > > -Original Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > > bounces at mailinglists.sqlite.org] On Behalf Of Scott Robison > > Sent: Monday, 9 May 2016 4:13 PM > > To: SQLite mailing list > > Subje

[sqlite] SELECT DISTINCT question

s.] > > Regards > David M Bennett FACS > > Andl - A New Database Language - andl.org > > > > > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] 64bit DLL vs 32bit

On May 10, 2016 8:48 AM, "Jeremy Nicoll" wrote: > > On Tue, 10 May 2016, at 14:45, J Decker wrote: > > On Tue, May 10, 2016 at 2:23 AM, Jeremy Nicoll > > > > I was under the impression that I'm using the 64-bit DLL on a W8.1 > > > 64-bit system, with the 32-bit tools. Does that mean that there's

[sqlite] 64bit DLL vs 32bit

On Tue, May 10, 2016 at 9:56 AM, Jeremy Nicoll < jn.ml.sqlu.725 at letterboxes.org> wrote: > On Tue, 10 May 2016, at 16:26, Scott Robison wrote: > > > I believe the tools provided by the site statically like SQLite so no DLL > > is required. The DLL is provided as a

[sqlite] How to get 1 row with no null columns

lite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Sqlite incompatibility with Postgres

is often asked "what does PostgreSQL do?" Sadly, the backward compatibility requirements prohibit SQLite from being a 100% feature / implementation match. -- Scott Robison

[sqlite] Sqlite incompatibility with Postgres

t; > > > _______ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On May 15, 2016 6:30 AM, "Tim Streater" wrote: > > What's all this about licences. AIUI, SQLite is explicitly in the public domain. Meaning the question of licence doesn't arise. The question of license arises when comparing two pieces of software. While PD isn't a license per se, it is

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

On May 15, 2016 8:06 AM, "Tony Papadimitriou" wrote: >>> > (Many open source projects have bugs waiting for months or years for someone to be bothered to fix, often driving people away!) > > To sum it up, a big thanks to Richard and his team! True. Last December I received a notice that a patch

[sqlite] Time & between, midnight wrap around

Off the top of my head: Select case when t1 < t2 then t3 between t1 and t2 when t1 > t2 then t3 >= t1 or t3 <= t2 end You might need to tweak it to handle the case when t1 = t2 if needed. Could mean one minute or could mean 24 hours depending on your pov. Hello, BETWEEN doesn't give the result I

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

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

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

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

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

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 >

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] 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",

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

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

On Jun 22, 2016 9:25 PM, "mon siong" wrote: > > > PHP use 3.7.7.1 and my c program use 3.8.4.3 . Different version of sqlite is fine ? > I tried WAL and Delete Journal Mode , both type cause the db to corrupt . > > Under which scenario, two different global variables will be

Re: [sqlite] Referencing a column alias (subquery) as function parameter

sted it with real data because, well, I don't have real data with which to test. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

e is also corrupt . > > > > >On Thursday, June 23, 2016 12:48 PM, Scott Robison < > sc...@casaderobison.com> wrote: > > > On Jun 22, 2016 9:25 PM, "mon siong" <monsi...@yahoo.com> wrote: > > > > > > PHP use 3.7.7.1

Re: [sqlite] Conversion failure

input to UTF-8. If I am mistaken on that point, I apologize. If the two alt-code byte sequences create data your C++ code can then process (because it's valid UTF-8), you'll know for certain that the SQLite shell on Windows does not process UTF-8 for console IO, just internally to the database

Re: [sqlite] Conversion failure

On Fri, Jun 24, 2016 at 12:03 PM, Scott Robison <sc...@casaderobison.com> wrote: > On Windows, when you get a string of characters, you either get an ANSI > string using some code page, or you get a wide character string. > > When you get an ANSI string, it is just a sequence o

Re: [sqlite] SQlite database corrupt , PHP and multithread C program accessing same database

again (1 & 2) or if the db does corrupt how can i analyse which code is > causing the db corrupt It's hard to suggest what to do to prevent corruption when it seems you're already doing those things. > . > > > > > On Friday, June 24, 2016 1:27 AM, Scott Robison <

Re: [sqlite] Conversion failure

t you are trying, as it would involve knowing what code page was in use at the time of object creation. This would be even worse if multiple machines created objects over time. But I'm driving across country and can't check source to confirm this. > > It is not UTF-8 and it is not UTF-16

Re: [sqlite] Conversion failure

le messages ago. However, I am sleep deprived and anxiously awaiting a vacation to begin in a few hours so it may not have been clear. :) In fact, I may just bug out early. It's largely a ghost town around here at the moment anyway. -- Scott Robison ___ sql

Re: [sqlite] Conversion failure

On Fri, Jun 24, 2016 at 12:54 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > > On Friday, 24 June, 2016 12:17 -0600, Scott Robison said: > > > Okay, rather than guessing, I just did a test from a Windows 10 command > > prompt. I am getting appropriate UTF-8 se

Re: [sqlite] Bug: SQLite's include guards are reserved identifiers

On Jul 12, 2016 10:32 PM, "Cory Nelson" wrote: > > While uncommon, it is not unheard of for apps to use include guards to > check for a library's existence. While it is indeed not in compliance, > in practice fixing this may affect existing SQLite users. Good point, though

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

On Jul 13, 2016 9:55 AM, "Simon Slavin" wrote: > > > On 13 Jul 2016, at 4:09pm, S.Ajina wrote: > > > Doing the same with the current version of sqlite3.exe (version 3.13.0) corrupts the database records when there are extended characters > > I would

Re: [sqlite] [Windows] 3.13.0 recreate db from .dump file corrupts records with extended characters

On Jul 13, 2016 11:14 AM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > > On 13 Jul 2016, at 5:22pm, Scott Robison <sc...@casaderobison.com> wrote: > > > His program is not involved. Just the SQLite shell. > > He's feeding the shell with a pre-p

Re: [sqlite] 64-bit SQLite3.exe

compatible way. So could a 32 bit build of SQLite access more than 4 GiB with appropriate hardware & OS support? Sure. Should a 32 bit build of SQLite stretch to support managing the address space itself as might be required? I don't think so. -- Scott Robison

Re: [sqlite] 64-bit SQLite3.exe

On Thu, Aug 11, 2016 at 6:37 PM, Warren Young <w...@etr-usa.com> wrote: > On Aug 11, 2016, at 3:19 PM, Scott Robison <sc...@casaderobison.com> > wrote: > > > > I think you guys are just talking past each other. > > Well, at least one of us isn’t communicatin

Re: [sqlite] 64-bit SQLite3.exe

On Fri, Aug 12, 2016 at 12:02 PM, Warren Young <w...@etr-usa.com> wrote: > On Aug 11, 2016, at 7:50 PM, Scott Robison <sc...@casaderobison.com> > wrote: > > > >> It’d be a lot of work just to avoid rebuilding for 64-bit, but maybe it > >> would be

Re: [sqlite] Bug: SQLite's include guards are reserved identifiers

CS > > Andl - A New Database Language - andl.org > > > > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How restrict access to SQLite database?

ld be enough, right? > > -- > --- > inum: 883510009027723 > sip: jungleboo...@sip2sip.info > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-user

Re: [sqlite] page checksums (was Re: Bad db feature request)

On Jun 29, 2016 5:08 PM, "Darren Duncan" wrote: > I notice that the ticket rejection didn't include any rationale or explanation, or I didn't find any when I looked. What was the rationale for rejecting that ticket? > > I believe that SQLite having page checksums would

Re: [sqlite] page checksums (was Re: Bad db feature request)

On Jun 29, 2016 10:14 PM, "Roger Binns" <rog...@rogerbinns.com> wrote: > > On 29/06/16 19:13, Scott Robison wrote: > > Given the nature of VFS, it is trivial* for anyone to create a module to > > provide this very functionality. So you can write it you

Re: [sqlite] page_size on ATTACH-ed databases

< MAIN DB PAGE SIZE OK > >> sqlite> > >> sqlite> pragma rd.page_size=4096; <- SET ATTACHED DB PAGE > SIZE TO 4K > >> sqlite> pragma rd.cache_size=32; > >> sqlite> pragma rd.mmap_size=0; > >&g

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

function before the first "executable" statement. I > believe that was a C language restriction back in the early 70's. > The declaration of variables have to be at the top of a scope as per ANSI C. C99 relaxed that. -- Scott Robison ___ sqlite-

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Jan 31, 2017 6:25 PM, "James K. Lowden" wrote: On Tue, 31 Jan 2017 15:50:08 -0800 Nathan Bossett wrote: > Since this is the sqlite users list and not the dev's list, can I ask > what your use case is that writing a thin wrapper around SQLITE >

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Tue, Jan 31, 2017 at 9:48 AM, James K. Lowden <jklow...@schemamania.org> wrote: > On Mon, 30 Jan 2017 13:32:46 -0700 > Scott Robison <sc...@casaderobison.com> wrote: > > > Basing source on "ANSI C" (as much as possible) just gives you the > > bi

Re: [sqlite] Bitten by lack of isolation between SELECT and UPDATE on the same connection

On Tue, Jan 31, 2017 at 12:15 PM, Jens Alfke wrote: > > > On Jan 31, 2017, at 9:39 AM, James K. Lowden > wrote: > > > > According the SQL standard, every SQL statement is atomic. SELECT has > > no beginning and no end: the results it returns

Re: [sqlite] How to circumvent UNIQUE constraint

This might be helpful. Maybe not. It's not an answer to the exact question, but ... What if you were to set all the IDs to their negative, then update them as desired? UPDATE TABLEA SET ID = -ID; UPDATE TABLEA SET ID = -ID + 1; Or something like that. It is not as efficient as would be

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

find a compiler for your PPC machine, and I bet if need be we can > port pcc to whatever you're running. (ISTM enlisting pcc would add to > SQLite's portability, btw.) > > --jkl > > > _______ > sqlite-users mailing list > sqlite-

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Jan 29, 2017 5:49 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: On 30 Jan 2017, at 12:06am, Scott Robison <sc...@casaderobison.com> wrote: > I'm not sure how big the market is, but there are older computers in use in > areas that might be running older OS b

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

I'm not sure how big the market is, but there are older computers in use in areas that might be running older OS because anything newer is too bloated. If maintaining ANSI C compatibility truly becomes a burden, sure. If it isn't then why not? On Jan 29, 2017 4:36 PM, "James K. Lowden"

Re: [sqlite] thousand separator for printing large numbers

On Feb 11, 2017 7:15 PM, "James K. Lowden" wrote: On Fri, 10 Feb 2017 10:46:24 +0100 Dominique Devienne wrote: > PS: In this context, I don't want to use a host-program provided UDF. > This is data meant to be viewed with any SQLite client, so

Re: [sqlite] sqlite importing csv

On Aug 24, 2016 10:25 PM, "Alan" wrote: > > forgot to reply to one of the questions. > > I am using version 3.13.0.0 and it is 64 bit > > I am running Windows 10 Pro > > computer is intel I3 3.5Ghz with 8Gb RAM. > > As my friend has no problem loading the same csv file with

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

Lamding page looks fine on my Galaxy Note 4 phone and cheap Amazon Fire tablet, both landscape and portrait. Documents by category doesn't like portrait mode on my tablet (at least). On Sep 6, 2016 8:38 AM, "Eric Kestler" wrote: > Looks quite good and is very readable on my

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

I saw no page content below "Documents By Category". If I rotated it to landscape the content was there, but it didn't render. I'll be able to go more in depth later, not at home with the tablet at the moment. On Sep 6, 2016 12:37 PM, "Richard Hipp" <d...@sqlite.org>

Re: [sqlite] schema_version and Vacuum or Backup API

On Sep 8, 2016 8:16 AM, "Richard Hipp" wrote: > > On 9/8/16, Stephen Chrzanowski wrote: > > > > However, the rabbit I was hoping to pull out of the hat was that the change > > in version numbers be done automatically when I make a change in the 3rd > > party

Re: [sqlite] client app crashes frequently and points sqlite DLL

Specifically, what version / distribution of Python 2 is in use? Python's own release, ActiveState, other? On Sep 1, 2016 8:27 AM, "Frantz FISCHER" wrote: > Hello Richard, > > > Thank you for your answer! > > Could you please tell me which details you would require? > > I

Re: [sqlite] client app crashes frequently and points sqlite DLL

; > > Thanks, > > Frantz. > > > On 01/09/2016 17:00, Scott Robison wrote: > >> Specifically, what version / distribution of Python 2 is in use? Python's >> own release, ActiveState, other? >> >> On Sep 1, 2016 8:27 AM, "Frantz FISCHER" <ffi

Re: [sqlite] client app crashes frequently and points sqlite DLL

In looking at the changelog for 2.7.12, I see multiple SQLite related Python fixes that addressed coredump bugs. On Sep 1, 2016 9:22 AM, "Scott Robison" <sc...@casaderobison.com> wrote: > It appears 2.7.12 is available. Perhaps it is worth trying. > > On Sep 1, 2016

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

On Aug 31, 2016 5:29 AM, "sanhua.zh" wrote: > > BTW, what do you think if I mapseparatly instead of the whole db file, ... I suspect that it wouldn't really help you much, if any. One, there is overhead in making that many system calls to map a bunch of 4 MiB buffers.

Re: [sqlite] schema_version and Vacuum or Backup API

Darn. Oh well. On Sep 8, 2016 9:34 AM, "Stephen Chrzanowski" wrote: > Apparently, no. Error is "cannot create trigger on system table". > > On Thu, Sep 8, 2016 at 11:19 AM, Stephen Chrzanowski > wrote: > > > Interesting idea. I'll try that on a

Re: [sqlite] Problem with rename table

On Sep 10, 2016 2:54 AM, "John McMahon" wrote: > > On 08/09/2016 10:09, Bob McFarlane wrote: >> >> Please reply if you sent this. Thanks. >> > > Hmm, looks like a fishing exercise to me. Same message in several threads. > > This reply only to mailing list. It's an

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

On Aug 24, 2016 5:35 AM, "Simon Slavin" wrote: > > > On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ wrote: > > > This is also the list for System.Data.SQLite. System.Data.SQLite supports design time components for VS2015, so this

Re: [sqlite] deprecated windows OS calls

catch is that it will (apparently) forever report it is an older version of the OS than it really is. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A small technical question about SQLite

> > Thank you, > Liat > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison _

Re: [sqlite] A small technical question about SQLite

s. > > —Jens > > > On Oct 24, 2016, at 7:20 PM, Scott Robison <sc...@casaderobison.com> > wrote: > > > > Don't everyone dial at once! > > > > On Mon, Oct 24, 2016 at 2:36 PM, LIAT SEAGAL-DERY < > liat.seagald...@gmail.com > >> wrote: > &

Re: [sqlite] Changing ID's to UUID

dom number generator for non cryptographic purposes. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] core using sqlite 3.17.0 on solaris

On Thu, Mar 30, 2017 at 11:22 AM, Richard Hipp <d...@sqlite.org> wrote: > On 3/30/17, Scott Robison <sc...@casaderobison.com> wrote: >>> >> Also, isn't the new code potentially allocating a smaller buffer in >> zSpace? If sizeof(yyParser) is 15, the removed

Re: [sqlite] core using sqlite 3.17.0 on solaris

code potentially allocating a smaller buffer in zSpace? If sizeof(yyParser) is 15, the removed line would allocate a 15 element array of unsigned char objects for a total of 15 bytes. The added line would allocate a 15/8 = 1 element array of sqlite3_uint64 objects for a total of 8 bytes. -- Scott Robison

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 11:05 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/23/2017 11:46 PM, Scott Robison wrote: >> >> Note: I'm on Windows 10 and reproduced this with the amalgamation >> downloaded today from >> http://sqlite.com/2017/sqlite-amalgamatio

[sqlite] Possibly pointless assert

and that is a useful assertion, I'd like to understand the reason why. Otherwise, the if statement at 2232 does everything the assert at 2230 does, making the assert fire when the code is working correctly. -- Scott Robison ___ sqlite-users mailing list

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/23/2017 04:45 AM, Scott Robison wrote: >> >> Take a look at >> http://www.sqlite.org/cgi/src/artifact/3ed64afc49c0a222?ln=2214,2233 >> (especially the assert within). >>

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 10:17 AM, Scott Robison <sc...@casaderobison.com> wrote: > On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy <danielk1...@gmail.com> wrote: >> How did you trip the assert()? i.e. what is the database schema and query >> that cause it to fail? > &g

Re: [sqlite] Incompatibility into configure.ac

On Apr 5, 2017 7:28 AM, "Bob Friesenhahn" wrote: On Wed, 5 Apr 2017, Richard Hipp wrote: > > The deeper issue is that I do not have access to a machine that lacks > bash on which to test the modifications > Specify the shell that configure will use like

Re: [sqlite] [BUG REPORT] Open blob is invalidated by the update to unrelated fields in the same row

s the separate blob table (which I think I read you've already tried). -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3.dll for x64

files. > As you've already discovered (based on the posted answer), you just needed an extra command line option passed to the lib tool. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/c

Re: [sqlite] Incompatibility into configure.ac

gt; sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Scott Robison ___ 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 ?

My understanding is that SQLite doesn't use the traditional definition of b-tree because it doesn't use fixed size records/keys. It will cram as few or as many as possible. I'm not in a position to confirm that, but it was something I read a few years ago I think. On Aug 11, 2017 9:16 AM, "james

Re: [sqlite] VALUES clause quirk or bug?

ming the columns. So, should SQLite be pickier in the syntax it supports? Probably. Can it be changed retroactively and break a bunch of existing code? Probably not (though it's not my position to say one way or the other). Are there other syntactic constructs that give you the ability to

Re: [sqlite] 3.18.0 SELECT..WHERE x & ? != 0; doesn't use an index

ing". The bitwise and operator is asking the question "where at least one bit from a set is not zero". Let's say you have 100 rows with different values of y. If you ask for rows "where y & 2 != 0", you should get all the even numbers. The only way to get that

<    1   2   3   4   >