From owner-freebsd-ports@FreeBSD.ORG  Wed Mar 26 13:59:20 2008
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@FreeBSD.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id AB8A41065708
	for <freebsd-ports@FreeBSD.org>; Wed, 26 Mar 2008 13:59:20 +0000 (UTC)
	(envelope-from pav@FreeBSD.org)
Received: from raven.customer.vol.cz (raven.customer.vol.cz [195.250.144.108])
	by mx1.freebsd.org (Postfix) with ESMTP id 3B8548FC25
	for <freebsd-ports@FreeBSD.org>; Wed, 26 Mar 2008 13:59:19 +0000 (UTC)
	(envelope-from pav@FreeBSD.org)
Received: from oook.cz (nobody@localhost [127.0.0.1])
	by raven.customer.vol.cz (8.14.1/8.14.1) with ESMTP id m2QDxGrg090330; 
	Wed, 26 Mar 2008 14:59:16 +0100 (CET) (envelope-from pav@FreeBSD.org)
From: "Pav Lucistnik" <pav@FreeBSD.org>
To: Michel Talon <talon@lpthe.jussieu.fr>, freebsd-ports@FreeBSD.org
Date: Wed, 26 Mar 2008 14:59:16 +0100
Message-Id: <20080326135806.M17639@FreeBSD.org>
In-Reply-To: <20080326131800.GA75243@lpthe.jussieu.fr>
References: <20080326131800.GA75243@lpthe.jussieu.fr>
X-Mailer: OpenWebMail 2.52 20060502
X-OriginatingIP: 195.122.204.152 (cvs@oook.cz)
MIME-Version: 1.0
Content-Type: text/plain;
	charset=iso-8859-2
X-Spam-Score: -4.399 () ALL_TRUSTED,BAYES_00
X-Scanned-By: MIMEDefang 2.63 on 195.250.144.108
Cc: soralx@cydem.org
Subject: Re: ports system woes
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 26 Mar 2008 13:59:20 -0000

On Wed, 26 Mar 2008 14:18:00 +0100, Michel Talon wrote

> In fact last year i wrote a python script which reads all the
> /var/db/pkg/+CONTENTS files, and fixes all the +REQUIRED_BY files,
> assuming they are corrupted. Moreover it follows the MOVED file.

So you basically reimplemented pkgdb -F in python?

> As far as i remember this program 
> runs in a few *seconds* certainly not minutes like it is said here

Mind that the original poster is using a very low-spec notebook with next to
none RAM.
 
> solution is to use sqlite and not some half-assed solution like a
> Berkeley database,

Solution is to use tools that are available in our base system. SQLite is not.

--
Pav Lucistnik <pav@oook.cz>
              <pav@FreeBSD.org>