As the Adobe engineer who did much of the work to embed SQLite into
Lightroom, I do want to express a couple of cautions about directly
manipulating your Lightroom library.
(1) If you change data in the database, this is unsupported; make
backups as it's certainly possible to create a DB that would be
unusable by Lightroom.
(2) It's likely that there will be significant changes to the schema
in future versions to help us implement new features or improve
performance.
That said, we'll be very interested to see what happens out there.
-Eric
On 22 Feb 2007, at 05:07, Daniel Önnerby wrote:
This is great!
I can imagine that there will be several opensource galleries
taking advantage of this in the future.
[EMAIL PROTECTED] wrote:
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
Though it's only a matter of curiosity, I wonder if anyone
here knows how/where Adobe employed SQLite in the Lightroom product?
Adobe stores just about all of your Lightroom state in an SQLite
database. Find the database (on your Mac) at
~/Pictures/Lightroom/Lightroom\ Database.lrdb
You won't be able to view the database with the version of SQLite
that comes on your Mac (3.1.3) because Lightroom uses version 3.3.4
and thus creates database files with the descending-index feature
and the more efficient boolean format - databases that version 3.1.3
cannot read. So if you want to peruse the data, download the
SQLite 3.3.14 and use it.
If you are using the windows version of Lightroom, I don't know
where you might find the database, but one can imagine that it
probably has a similar or identical name.
--
D. Richard Hipp <[EMAIL PROTECTED]>
---------------------------------------------------------------------
--------
To unsubscribe, send email to [EMAIL PROTECTED]
---------------------------------------------------------------------
--------
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
