Pages

Showing posts with label sqlite3. Show all posts
Showing posts with label sqlite3. Show all posts

Thursday, November 25, 2010

Fun with F-Spot 0.8.0 and sqlite3

Today I focused on the F-Spot version 0.8.0.
I knew that contains a database that keeps information about the pictures.
I found the database and tried a few commands:
$ cd .config/
$ cd f-spot/
$ ls
addin-db-001  photos.db
Once I found the database, I started SQLite3. See the example below:
$ sqlite3  photos.db 
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
exports         meta            photo_versions  rolls         
jobs            photo_tags      photos          tags          
sqlite> .schema photos
CREATE TABLE photos (
 id   INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
 time   INTEGER NOT NULL, 
 base_uri  STRING NOT NULL, 
 filename  STRING NOT NULL, 
 description  TEXT NOT NULL, 
 roll_id   INTEGER NOT NULL, 
 default_version_id INTEGER NOT NULL, 
 rating   INTEGER NULL 
);
CREATE INDEX idx_photos_roll_id ON photos(roll_id);
sqlite> select * from photos;
1|1279913277|file:///home/mythcat/Photos/2010/07/23|IMG_2970.JPG||1|1|0
It is easy to use and implemented various python scripts.