Lightroom Classic: Using external SQLite3 tools against a catalog.

  • 1
  • Problem
  • Updated 4 days ago
  • (Edited)
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.

Photo of Bill Nash

Bill Nash

  • 2 Posts
  • 0 Reply Likes

Posted 6 days ago

  • 1
Photo of Jeff

Jeff

  • 60 Posts
  • 19 Reply Likes
Maybe encrypted?

Photo of Bill Nash

Bill Nash

  • 2 Posts
  • 0 Reply Likes
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
Photo of John R. Ellis

John R. Ellis, Champion

  • 4455 Posts
  • 1181 Reply Likes
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.
Photo of Patrick Philippot

Patrick Philippot

  • 481 Posts
  • 142 Reply Likes
Hi,

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

Photo of John R. Ellis

John R. Ellis, Champion

  • 4455 Posts
  • 1181 Reply Likes