Re: Duplicate images

[Bill Moseley <moseley hank org>]

On Fri, Sep 21, 2007 at 02:22:05PM -0700, Bill Moseley wrote:
> Version: 0.3.5-0ubuntu2
> 
> 
> I have duplicate images in my collection that point to the same file.
> Is there a way to clean those out of the database?

Ah, I see what happened:

sqlite> select count(*) from (select name, count(name) from photos group by name having count(name) > 1);

count(*)
----------
82

sqlite> select * from photos where name in
    (select name from photos group by name having count(name) > 1) order by name;

id          time        directory_path                   name
----------  ----------  -------------------------------  ------------ 
628         1188138439  /home/moseley/Photos/2007/08/26  P1030541.JPG 
669         1188138439  /home/moseley/photos_bill        P1030541.JPG 

629         1188138462  /home/moseley/Photos/2007/08/26  P1030542.JPG 
670         1188138462  /home/moseley/photos_bill        P1030542.JPG 

630         1188165431  /home/moseley/Photos/2007/08/26  P1030543.JPG
671         1188165431  /home/moseley/photos_bill        P1030543.JPG

Looks like one time I accidentally forgot to uncheck "copy to photos"
so they got imported twice.  It would be nice if that checkbox's
default could be changed.

What does f-spot look at to determine if an image is a duplicate?



BTW -- what's the purpose of the (empty) imports table and the exports
table?  It would be handy to have a images related to an import, as
well as being able to tag them on import.  More than once have I
forgot to tag them on import.

Can f-spot use Postgresql instead?



-- 
Bill Moseley
moseley hank org