- Joined
- May 28, 2012
- Messages
- 152
- Location
- Colorado
- Lightroom Experience
- Intermediate
- Lightroom Version
- Lightroom Version Number
- Lightroom Classic version: 10.1.1 [ 202101041610-8c69aa4e ]
- Operating System
- macOS 10.15 Catalina
I've got a rather off the wall question. I'm actually working on an SQLite database design where I have to reference external files. I know Lightroom uses an SQLite database for the catalog and I've looked at how it stores the file path and folder names on a copy of my catalog on the Mac.
My question is for any Windows user comfortable with looking at the catalog directly with a database browser tool (do this on a COPY, not your real catalog) and if you could look at the AgLibraryRootFolder table and tell me whan an entry looks like in the field absolutePath and also take a look at the AgLibraryFolder table and tell me what an entry in the pathFromRoot field looks like. I'm particularly interested in whether the separator charcters follow Unix or Windows conventions.
Related is if anyone knows if you move a LR catalog form one operating system to another, where the file paths use different separator characters, is the database itself modified or converted or is a second set of entries put in? Does this happen each time you move the catalog? Does anyone ever move LR catalogs back and forth across windows and Mac systems regularly?
In my own database I'm trying to decide how best to implement the ability for the same database file to operate the same on Mac, Windows and Linux systems yet I need to store paths or references to external files.
In my case the external files are genomic data, SNPs or DNA sequences in a variety of formats for individual sheep. I don't want to actually include that data in my database but my users will need to know where it is to run their own analyses on it and my database needs to let the user know if a particular sheep has had their DNA analyzed and by what method and where the data are.
I'm the only programmer on the project so I'm trying to look at how other similar applications implement the function.
I realize this is not a LR question but since I don't have a Windows machine with LR to look at the database it’s the only place I could think of to ask.
My question is for any Windows user comfortable with looking at the catalog directly with a database browser tool (do this on a COPY, not your real catalog) and if you could look at the AgLibraryRootFolder table and tell me whan an entry looks like in the field absolutePath and also take a look at the AgLibraryFolder table and tell me what an entry in the pathFromRoot field looks like. I'm particularly interested in whether the separator charcters follow Unix or Windows conventions.
Related is if anyone knows if you move a LR catalog form one operating system to another, where the file paths use different separator characters, is the database itself modified or converted or is a second set of entries put in? Does this happen each time you move the catalog? Does anyone ever move LR catalogs back and forth across windows and Mac systems regularly?
In my own database I'm trying to decide how best to implement the ability for the same database file to operate the same on Mac, Windows and Linux systems yet I need to store paths or references to external files.
In my case the external files are genomic data, SNPs or DNA sequences in a variety of formats for individual sheep. I don't want to actually include that data in my database but my users will need to know where it is to run their own analyses on it and my database needs to let the user know if a particular sheep has had their DNA analyzed and by what method and where the data are.
I'm the only programmer on the project so I'm trying to look at how other similar applications implement the function.
I realize this is not a LR question but since I don't have a Windows machine with LR to look at the database it’s the only place I could think of to ask.