Skip to main content
Adobe Photoshop Family

2 Messages

 • 

82 Points

Thu, Jul 11, 2019 3:09 AM

Lightroom Classic: Using external SQLite3 tools against a catalog.

I'm trying to do some automation against my catalog, using external toolsets like python, but I can't use any standard sqlite3 toolset to open a copy of the catalog to query information from it.

Responses

88 Messages

 • 

1.5K Points

a year ago

Maybe encrypted?

2 Messages

 • 

82 Points

Doesn't appear to be.

billn@Hadriel:~$ more 2018.lrcat
SQLite format 3
:.
    id_local INTEGER PRIMARY KEY,
    image INTEGER NOT NULL DEFAULT 0,
    tag INTEGER NOT NULL DEFAULT 0
)A==tableAdobe_imageProofSettingsAdobe_imageProofSettingsCREATE TABLE Adobe_imageProofSettings (
    id_local INTEGER PRIMARY KEY,
    colorProfile,
    image INTEGER,
    renderingIntent
)^]]tableAdobe_libraryImageDevelop3DLUTColorTableAdobe_libraryImageDevelop3DLUTColorTableCREATE TABLE Adobe_libraryImageDevelop3DLUTColorTable (
    id_local INTEGER PRIMARY KEY,
    LUTFullString,
    LUTHash UNIQUE
)p]ABLE Adobe_libraryImageDevelopHistoryStep (
    id_local INTEGER PRIMARY KEY,
    id_global UNIQUE NOT NULL,
    dateCreated,
    digest,
    hasDevelopAdjustments,
    image INTEGER,
    name,
    relValueString,
    text,
    valueString
)g{U

Champion

 • 

5.1K Messages

 • 

93K Points

a year ago

Hmm, "sqlite3" should work. Try passing the catalog file on the command line:

sqlite3 2018.lrcat

Continue the conversation in the Lightroom SDK forum, where other plugin developers hang out.

596 Messages

 • 

11.3K Points

a year ago

Hi,

I'm using SQLite Expert Personal 5 (http://www.sqliteexpert.com/download.html) against the LR catalog. No problem until now.

 

--
Patrick
www.ppphoto.fr
Hamburg ist der wahre Grund warum
Kompassnadeln nach Norden zeigen.

Champion

 • 

5.1K Messages

 • 

93K Points

a year ago