Picasa database format, export capability question

958 views
Skip to first unread message

ktenney

unread,
Aug 2, 2009, 3:22:42 PM8/2/09
to Google-Labs-Picasa-for-Linux
Howdy,

I'm starting to use Picasa 3 for Linux.

Before I invest lots of time into tagging and captioning, I'd like to
know
that information is accessible from outside Picasa.

Is there a programming API for Picasa?
Is the database format documented?
Is it possible to export to some kind of text format: xml or csv?

Thanks,
Kent

leiz

unread,
Aug 13, 2009, 2:59:40 PM8/13/09
to Google-Labs-Picasa-for-Linux
Picasa stores comments and tags inside JPEG files as IPTC data. For
instance, I took foo.jpg and added "test_comment" along with the tags
"testtag1" and "testtag2" When I examine the file with exiv2 [1] as
follows:

exiv2 -pi print foo.jpg

I get:

Iptc.Application2.Caption String 12
test_caption
Iptc.Application2.Keywords String 8 testtag1
Iptc.Application2.Keywords String 8 testtag2

[1] http://www.exiv2.org/

Kent Tenney

unread,
Aug 13, 2009, 3:16:50 PM8/13/09
to Google-Labs-Pi...@googlegroups.com
leiz,

So Picasa changes the image file on disk when
a tag or comment is applied?

I consider that presumptious, I would prefer my original files
not be changed.

It would be great if the format of the Picasa database were
documented.

If Picasa developers follow this list I'd be interested in any
comments on the db format, and the wisdom of altering the
image files. Is this something that can be turned off?

Thanks,
Kent

leiz

unread,
Aug 13, 2009, 4:03:28 PM8/13/09
to Google-Labs-Picasa-for-Linux
I think tags/comments and red-eye (for whatever reason) are the only
operations that change your photos directly. I don't think it can be
turned off. Keep in mind this only changes the JPEG metadata, and
doesn't modify the image portion of the JPEG file.

The IPTC fields are standard fields that many photo apps understand.
Would you rather have Picasa store tags in some format that's less
exchangeable with other apps?

Kent Tenney

unread,
Aug 13, 2009, 5:33:27 PM8/13/09
to Google-Labs-Pi...@googlegroups.com
On Thu, Aug 13, 2009 at 3:03 PM, leiz<zhan...@gmail.com> wrote:
>
> I think tags/comments and red-eye (for whatever reason) are the only
> operations that change your photos directly. I don't think it can be
> turned off. Keep in mind this only changes the JPEG metadata, and
> doesn't modify the image portion of the JPEG file.

Right, not the 'image portion' of the file, but the file is being changed,
the date changes, the checksum changes, the size changes.

There are benefits of writing metadata to the image file, however
I prefer original images to be immutable.

>
> The IPTC fields are standard fields that many photo apps understand.
> Would you rather have Picasa store tags in some format that's less
> exchangeable with other apps?

If Picasa is going to write to my files, IPTC is probably fine,
though XMP seems to be the preferred currently.

Thanks,
Kent

Janno Pugi

unread,
Aug 14, 2009, 1:54:45 AM8/14/09
to Google-Labs-Pi...@googlegroups.com
There is no questions, tags must be saved to jpeg metadata, it's standard!

J.

2009/8/14 Kent Tenney <kte...@gmail.com>

axxi

unread,
May 1, 2013, 3:31:39 PM5/1/13
to google-labs-pi...@googlegroups.com, Google-Labs-Picasa-for-Linux, kte...@gmail.com
Try to use exportpicasa utility (http://sourceforge.net/projects/exportpicasa/). It's beta now. And for win32 only. But I don't see nothing impossible to make it portable.
Reply all
Reply to author
Forward
0 new messages