sqlite3 - any plans to update?

Jeremy Messenger mezz7 at cox.net
Sat Dec 29 11:50:38 PST 2007

On Sat, 29 Dec 2007 13:35:43 -0600, Maxim Khitrov <mkhitrov at gmail.com>  

> On Dec 29, 2007 12:25 PM, Maxim Khitrov <mkhitrov at gmail.com> wrote:
>> On Dec 29, 2007 6:50 AM, Yuri Pankov <yuri.pankov at gmail.com> 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 at . 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

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).


> - Max

mezz7 at cox.net  -  mezz at FreeBSD.org
FreeBSD GNOME Team  -  FreeBSD Multimedia Hat (ports, not src)
http://www.FreeBSD.org/gnome/  -  gnome at FreeBSD.org
http://wiki.freebsd.org/multimedia  -  multimedia at FreeBSD.org

More information about the freebsd-ports mailing list