From owner-freebsd-ports@FreeBSD.ORG Sat Dec 29 19:50:38 2007 Return-Path: Delivered-To: ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 139ED16A417; Sat, 29 Dec 2007 19:50:38 +0000 (UTC) (envelope-from mezz7@cox.net) Received: from eastrmmtao106.cox.net (eastrmmtao106.cox.net [68.230.240.48]) by mx1.freebsd.org (Postfix) with ESMTP id 8D14B13C461; Sat, 29 Dec 2007 19:50:37 +0000 (UTC) (envelope-from mezz7@cox.net) Received: from eastrmimpo01.cox.net ([68.1.16.119]) by eastrmmtao106.cox.net (InterMail vM.7.08.02.01 201-2186-121-102-20070209) with ESMTP id <20071229195037.WAOL476.eastrmmtao106.cox.net@eastrmimpo01.cox.net>; Sat, 29 Dec 2007 14:50:37 -0500 Received: from mezz.mezzweb.com ([24.255.149.218]) by eastrmimpo01.cox.net with bizsmtp id Wjpj1Y0094iy4EG0000000; Sat, 29 Dec 2007 14:49:44 -0500 Date: Sat, 29 Dec 2007 13:51:06 -0600 To: "Maxim Khitrov" From: "Jeremy Messenger" Content-Type: text/plain; format=flowed; delsp=yes; charset=us-ascii MIME-Version: 1.0 References: <20071229115014.GH57401@darklight.org.ru> <26ddd1750712290925h7c5b698dn46cab08684be0337@mail.gmail.com> <26ddd1750712291135v22b015ct7a24279cd98583f4@mail.gmail.com> Content-Transfer-Encoding: Quoted-Printable Message-ID: In-Reply-To: <26ddd1750712291135v22b015ct7a24279cd98583f4@mail.gmail.com> User-Agent: Opera Mail/9.25 (Linux) Cc: Marcus Alves Grando , ports@freebsd.org, Yuri Pankov Subject: Re: sqlite3 - any plans to update? X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 29 Dec 2007 19:50:38 -0000 On Sat, 29 Dec 2007 13:35:43 -0600, Maxim Khitrov = wrote: > On Dec 29, 2007 12:25 PM, Maxim Khitrov wrote: >> On Dec 29, 2007 6:50 AM, Yuri Pankov wrote: >> > Hi, >> > >> > First of all - why this is a question and not PR with patch to upda= te = >> - >> > there are too many dependant ports which I have no way to test and >> > current stable version is 3.5.4, which isn't minor modification (I >> > think). And I'm getting spammed by bogofilter trying to convince me= to >> > update sqlite to at least version 3.4.2. >> > >> > So, are there some showstoppers or is it just ETIME & EHOLIDAYS? :-= ) >> > >> > >> > TIA, >> > Yuri >> >> I e-mailed the maintainer as well as portmgr@. No response from >> maintainer, but Pav Lucistnik suggested that I prepare the update the= n >> wait 2 weeks to allow anyone other than the maintainer (assuming that= >> he is MIA) to commit. I even started looking at it, but I have about >> 10 other things I need to be working on. I'll see if it's a simple >> case of updating the makefile and distinfo. If not, it would probably= >> be best if someone more familiar with sqlite (and ports) internals >> handle the update. >> >> - Max > > I was able to build the new version, and it seems to be working. > However, there were some major changes made (to sqlite and the port > itself) and I wouldn't recommend using my version in a production > environment. I had to get rid of the FTS options because those patches= > didn't work anymore. In any case, the port has to be updated for FTS > 3. I don't have the time right now to come up with something new. > Also, it seems that this version now requires TCL 8.4 even when > building without TCLWRAPPER. Not sure why it does this, the > --disable-tcl switch is passed to configure but compilation still > fails without tcl installed. > > Anyway, download the new port from the url below and extract it in > /usr/ports/databases. It will create sqlite35 and sqlite35-threads > directories. Other than the removal of FTS and new dependency on TCL > 8.4, everything else should be the same as for sqlite3 port. Test it > out, see if it works for you. If no one has any problems with it then > maybe it can be added to the ports tree, but someone else will need to= > maintain it. I don't have much time these days, unfortunately. > > URL: http://mxwerx.com/sqlite35.tar.gz http://www.sqlite.org/34to35.html =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 6.0 Summary The transition from SQLite version 3.4.2 to 3.5.0 is a major change. Eve= ry = source code file in the SQLite core had to be modified, some extensively= . = And the change introduced some minor incompatibilities in the C interfac= e. = But we feel that the benefits of the transition from 3.4.2 to 3.5.0 far = = outweigh the pain of porting. The new VFS layer is now well-defined and = = stable and should simplify future customizations. The VFS layer, and the= = separable memory allocator and mutex subsystems allow a standard SQLite = = source code amalgamation to be used in an embedded project without chang= e, = greatly simplifying configuration management. And the resulting system i= s = much more tolerant of highly threaded designs. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Someone might need to create sqlite35 instead of update to 3.5.x in = sqlite3. If it can be done to update 3.5.x in sqlite3, then I would hold= = on until ports tree is complete unfreeze (still thaw). Cheers, Mezz > - Max -- = mezz7@cox.net - mezz@FreeBSD.org FreeBSD GNOME Team - FreeBSD Multimedia Hat (ports, not src) http://www.FreeBSD.org/gnome/ - gnome@FreeBSD.org http://wiki.freebsd.org/multimedia - multimedia@FreeBSD.org