From owner-freebsd-ports@FreeBSD.ORG Mon Mar 24 15:20:22 2008 Return-Path: Delivered-To: ports@freebsd.org Received: from sup-afu.wrk.terra.com.br (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by hub.freebsd.org (Postfix) with ESMTP id D3186106564A; Mon, 24 Mar 2008 15:20:21 +0000 (UTC) (envelope-from mnag@FreeBSD.org) Message-ID: <47E7C6B5.5070600@FreeBSD.org> Date: Mon, 24 Mar 2008 12:20:21 -0300 From: Marcus Alves Grando Organization: FreeBSD.org User-Agent: Thunderbird 2.0.0.12 (X11/20080313) MIME-Version: 1.0 To: Jeremy Messenger References: <20071229115014.GH57401@darklight.org.ru> <26ddd1750712290925h7c5b698dn46cab08684be0337@mail.gmail.com> <26ddd1750712291135v22b015ct7a24279cd98583f4@mail.gmail.com> <47784BF6.5010601@FreeBSD.org> In-Reply-To: <47784BF6.5010601@FreeBSD.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: ports@freebsd.org, Maxim Khitrov , Yuri Pankov Subject: CFT: Update database/sqlite3 to 3.5.6 (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: Mon, 24 Mar 2008 15:20:23 -0000 People, I created one patch to update sqlite3 to 3.5.6 [1]. I already tested some ports, but if someone can help to test I appreciate. Any problems can contact me directly. [1] http://people.freebsd.org/~mnag/sqlite.patch Regards Marcus Alves Grando wrote: > Jeremy Messenger escreveu: >> 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 >>>> update - >>>> > 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 then >>>> 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 >> =========================================== >> 6.0 Summary >> >> The transition from SQLite version 3.4.2 to 3.5.0 is a major change. >> Every source code file in the SQLite core had to be modified, some >> extensively. And the change introduced some minor incompatibilities in >> the C interface. 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 change, greatly simplifying configuration >> management. And the resulting system is much more tolerant of highly >> threaded designs. >> =========================================== >> >> 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 > > I'll create a sqlite34 and sqlite35 port for update of 3.4 and new 3.5 > port, but because of many changes in sqlite i can't do that now, i'll > wait ports slush. > > Wait a few more days, i don't forget of sqlite. > > Regards > >> >>> - Max >> >> > -- Marcus Alves Grando marcus(at)sbh.eng.br | Personal mnag(at)FreeBSD.org | FreeBSD.org