Re: [sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

On 24/08/2017 13:02, Richard Hipp wrote: The problem, if my analysis is correct, should be obscure and require a very specific query to hit. Thanks, your patch works. I believe our use case is as obscure as you can think ;-( Jörg. ___

Re: [sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

On 8/24/17, Jörg Knobloch wrote: > On 24/08/2017 11:40, Clemens Ladisch wrote: >> Jörg Knobloch wrote: >>> Mozilla have upgraded to SQLite 3.20.0 and that has caused the >>> Thunderbird test suite some test failures [1] as follows: >>> >>> Assertion failed: (p->flags &

Re: [sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

On 24/08/2017 11:40, Clemens Ladisch wrote: Jörg Knobloch wrote: Mozilla have upgraded to SQLite 3.20.0 and that has caused the Thunderbird test suite some test failures [1] as follows: Assertion failed: (p->flags & MEM_Dyn)==0 || p->szMalloc==0, file sqlite3.c, line 70285 Hmm, is there a

Re: [sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

Jörg Knobloch wrote: > Mozilla have upgraded to SQLite 3.20.0 and that has caused the > Thunderbird test suite some test failures [1] as follows: > > Assertion failed: (p->flags & MEM_Dyn)==0 || p->szMalloc==0, file sqlite3.c, > line 70285 Hmm, is there a custom memory allocator somewhere? And

[sqlite] Upgrade to SQLite 3.20.0 im Mozilla - Consequences for Mozilla Thunderbird

Dear SQLite developer, Mozilla have upgraded to SQLite 3.20.0 and that has caused the Thunderbird test suite some test failures [1] as follows: Assertion failed: (p->flags & MEM_Dyn)==0 || p->szMalloc==0, file sqlite3.c, line 70285 One of the Mozilla developers was of the opinion that the

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/06/13 17:55, Simon Slavin wrote: >> Here’s a nice Python wrapper: >> >> > > Woops. That’s Windows, you’re Ubuntu. Don’t you have the sqlite3 > Python module APSW is not Windows. It is provided as source for

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > Sent: Sunday, 16 June, 2013 18:56 > To: General Discussion of SQLite Database > Su

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

On 17 Jun 2013, at 1:50am, Simon Slavin wrote: > > On 17 Jun 2013, at 1:44am, Merton Lister wrote: > >> My application is Python-based, and I'm using py-sqlite module to connect >> to sqlite. Where should I put the .c and .h files? > > Here’s a nice

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

On 17 Jun 2013, at 1:44am, Merton Lister wrote: > My use case falls to the third case, i.e. writing an application which > talks to a sqlite db. You suggested that I should include the .c and .h > files from the amalgamation in my app. Specifically, how should I do that? >

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

Hi Simon, Thank you for the excellent explanation! My use case falls to the third case, i.e. writing an application which talks to a sqlite db. You suggested that I should include the .c and .h files from the amalgamation in my app. Specifically, how should I do that? My application is

Re: [sqlite] Upgrade/Install sqlite3 on Ubuntu server

On 17 Jun 2013, at 12:01am, Merton Lister wrote: > What is the best way for upgrading sqlite3 on an Ubuntu server (12.04 or > 10.04)? SQLite3 does not exist as a server application. It’s not a pre-compiled library or a daemon which runs in the background. Instead it

[sqlite] Upgrade/Install sqlite3 on Ubuntu server

Hi, What is the best way for upgrading sqlite3 on an Ubuntu server (12.04 or 10.04)? The official package maintained by Ubuntu is way behind the latest version offered on sqlite.org. I would like to know a way to upgrade sqlite3 as its new versions get released. Is there a PPA available? Or do

Re: [sqlite] change after sqlite upgrade with python

On Mon, Sep 19, 2011 at 10:22 PM, Jamie Winquist wrote: > In my environment, we are connecting to the sqlite file using > pysqlite2.dbapi2. After upgrading from sqlite 3.5.4 to 3.7.7.1, iterating > over the results of a cursor.execute() are yielding different keys than they >

Re: [sqlite] change after sqlite upgrade with python

On 20 Sep 2011, at 3:22am, Jamie Winquist wrote: > After upgrading from sqlite 3.5.4 to 3.7.7.1, iterating over the results of a > cursor.execute() are yielding different keys than they did pre-upgrade. My > query is of the form: > > SELECT table.column1, table.column2 FROM table; Read the

Re: [sqlite] change after sqlite upgrade with python

On Tue, Sep 20, 2011 at 4:22 AM, Jamie Winquist wrote: > With sqlite 3.5.4, when iterating over the cursor, the keys in each result > row were named "table.column1" and "table.column2" as specified in the > query. After the upgrade to sqlite 3.7.7.1, the keys in each result

[sqlite] change after sqlite upgrade with python

In my environment, we are connecting to the sqlite file using pysqlite2.dbapi2. After upgrading from sqlite 3.5.4 to 3.7.7.1, iterating over the results of a cursor.execute() are yielding different keys than they did pre-upgrade. My query is of the form: SELECT table.column1, table.column2

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

: Sunday, February 20, 2011 7:48 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 02:48 PM, Todd Shutts wrote: > However; memory usage is growing like crazy. It is a very fr

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

On 21 Feb 2011, at 5:56am, Dan Kennedy wrote: > WAL file growth has (apparently) been a problem for people with > really busy systems. But so far it has been the actual size of > the file on disk that bothers them, not the memory mapped bit. If that's what you think is raising concern then

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

On 02/21/2011 09:38 AM, Simon Slavin wrote: > > On 21 Feb 2011, at 1:47am, Roger Binns wrote: > >> On 02/20/2011 02:48 PM, Todd Shutts wrote: >>> The application >>> never used more than 10MB and it is currently using 57+MB and continues >>> to climb. >> >> The single most likely explanation is

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

On 21 Feb 2011, at 1:47am, Roger Binns wrote: > On 02/20/2011 02:48 PM, Todd Shutts wrote: >> The application >> never used more than 10MB and it is currently using 57+MB and continues >> to climb. > > The single most likely explanation is this is WAL in action, the memory is > from a memory

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 02:48 PM, Todd Shutts wrote: > However; memory usage is growing like crazy. It is a very frequent occurrence that what people think is being measured is not what is actually being measured. Make sure you understand exactly what the

[sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

I inherited an application which used SQLite 3.5.8 running on Windows 2000. I upgrade to version 3.7.5 of the dll and added pragma statement to use WAL. There was an immediate and significant performance increase. However; memory usage is growing like crazy. The application never used more

Re: [sqlite] UPGRADE to 3.6.20 and python

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Cooper, Andrew wrote: > This has probably been asked a lot of times before but I couldn't find > an answer in the archives. You should ask on the python sqlite list :-) It is jointly maintained by the authors of the two Python to SQLite bindings:

[sqlite] UPGRADE to 3.6.20 and python

This has probably been asked a lot of times before but I couldn't find an answer in the archives. I want to upgrade the version of sqlite in python 2.5 to use 3.6.20(the latest) What steps do I need to do to achieve this ? Does pysqlite need to be installed and if so does this support the

Re: [sqlite] Upgrade from 3.5.9 to 3.6.11

On Mar 13, 2009, at 9:22 PM, Kees Nuyt wrote: > On Fri, 13 Mar 2009 08:57:35 -0700 (PDT), Joanne Pham > wrote: > >> Hi All, >> We have a application using SQLite 3.5.9 now >> and we will be releasing this product in June. >> I am think about upgrading SQLite from 3.5.9

Re: [sqlite] Upgrade from 3.5.9 to 3.6.11

On Fri, 13 Mar 2009 08:57:35 -0700 (PDT), Joanne Pham wrote: > Hi All, > We have a application using SQLite 3.5.9 now > and we will be releasing this product in June. > I am think about upgrading SQLite from 3.5.9 to > SQLite 3.6.11 but I don't know what are the > impact

[sqlite] Upgrade from 3.5.9 to 3.6.11

Hi All, We have a application using SQLite 3.5.9 now and we will be releasing this product in June.  I am think about upgrading SQLite from 3.5.9 to SQLite 3.6.11 but I don't know what are the impact for the application and is it worth to upgrade SQLite to newest one before the product is

Re: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

Thanks for your helpful information! On Wed, Jan 14, 2009 at 12:48 AM, Griggs, Donald <donald.gri...@allscripts.com> wrote: > Subject: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7 > > Hi, > > I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is > any cha

Re: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

Subject: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7 Hi, I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is any change (or problem) of file format. === Upgrading from version 2 to version 3 (understandably) required a dump and restore

[sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

Hi, I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is any change (or problem) of file format. -- Best Regards, Edward J. Yoon @ NHN, corp. edwardy...@apache.org http://blog.udanax.org ___ sqlite-users mailing list

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

D. Richard Hipp wrote: > On Jun 13, 2008, at 12:22 AM, Jeff Godfrey wrote: > >> Thanks for the quick solution. I've adjusted my code accordingly. >> So, >> do you consider this a buglet or more just the closing of a gap that >> shouldn't have existed in the first place? > The column naming

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

On Jun 13, 2008, at 12:22 AM, Jeff Godfrey wrote: >> > Thanks for the quick solution. I've adjusted my code accordingly. > So, > do you consider this a buglet or more just the closing of a gap that > shouldn't have existed in the first place? It's interesting that the > original code works

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

D. Richard Hipp wrote: > On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote: > >> dbMem eval {select distinct(owner) from lockinfo order by owner} { >> >> } >> >> That works correctly in my original app using 3.4.2, but complains >> that >> there is no such variable "owner" when using 3.5.9.

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote: > > dbMem eval {select distinct(owner) from lockinfo order by owner} { > > } > > That works correctly in my original app using 3.4.2, but complains > that > there is no such variable "owner" when using 3.5.9. Solution 1: dbMem eval

[sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

Hm... I sent this message last night as a non-list member. I received a notification that it would need to be approved by a moderator before being made public. About 15 hours later, I received a "Post was rejected... No reason given" message. Why's that? So now I'm subscribed again.

[sqlite] upgrade sqlite

I have just instaleld apache 2.2 and php 5.2.5 on a windows xp machine. I would also like the current version of sqlite. running sqlite3.exe gives me a verion of 3.3.15. Is this the version of sqlite3.exe or of the dqlite database engine? If this is the engine version how do I upgrade it? I do

[sqlite] upgrade from sqlite 2.8.11 to sqlite3?

Hi everyone. I am thinking about upgrading sqlite version, and I found lots of things changed in sqlite3, for example, sqliteBtreeUpdateMeta(Btree *pBt, int *aMeta) changed to sqlite3BtreeUpdateMeta(Btree *p, int idx, u32 iMeta), What should I put in idx and iMeta? and old code require call

[sqlite] upgrade from 2 to 3

I've just upgraded my program from using v2.8.16 of sqlite to using v3.2.1 of sqlite. So I've change the wrapper class that I was using to use the new prepare() instead of compile() etc. The problem I have is that my program is now running slower - a lot slower, as in one fiftieth of its previous

Re: [sqlite] upgrade?

Hi Michael, Michael Hunley wrote: Hi, I am currently using SQLite v 2.8.13 for a commercial product for Palm Handhelds. I am noticing some performance issues; most notably when I do a database validate() to verify my integrity at app open and close. I see that version 3.0.8 has some code

[sqlite] upgrade?

Hi, I am currently using SQLite v 2.8.13 for a commercial product for Palm Handhelds. I am noticing some performance issues; most notably when I do a database validate() to verify my integrity at app open and close. I see that version 3.0.8 has some code optimizations, but am unsure if