gallery

Custom SQL query

Tables

dirs

dir_path, dir_url, title, image_blob, num_images, description, dir_update_time, thumbnail, cover, cover_path, meta

62 rows

dirs_no_blob

dir_path, dir_url, title, num_images, description, dir_update_time, thumbnail, cover, cover_path, meta

62 rows

embeddings

hash, embedding

886 rows

hashes

path, hash

886 rows

images

path, stem, url, image_blob

896 rows

images_no_blob

path, stem, url

1,203 rows

resnet50

path, classification

844 rows

dirs_fts (hidden)

dir_path, dir_url, title, image_blob, num_images, description, dir_update_time, thumbnail, cover, cover_path, meta, dirs_fts, rank

62 rows

dirs_fts_config (hidden)

k, v

1 row

dirs_fts_data (hidden)

id, block

83 rows

dirs_fts_docsize (hidden)

id, sz

62 rows

dirs_fts_idx (hidden)

segid, term, pgno

81 rows

dirs_no_blob_fts (hidden)

dir_path, dir_url, title, num_images, description, dir_update_time, thumbnail, cover, cover_path, meta, dirs_no_blob_fts, rank

62 rows

dirs_no_blob_fts_config (hidden)

k, v

1 row

dirs_no_blob_fts_data (hidden)

id, block

7 rows

dirs_no_blob_fts_docsize (hidden)

id, sz

62 rows

dirs_no_blob_fts_idx (hidden)

segid, term, pgno

5 rows

embeddings_fts (hidden)

hash, embedding, embeddings_fts, rank

886 rows

embeddings_fts_config (hidden)

k, v

1 row

embeddings_fts_data (hidden)

id, block

2,610 rows

embeddings_fts_docsize (hidden)

id, sz

886 rows

embeddings_fts_idx (hidden)

segid, term, pgno

2,687 rows

hashes_fts (hidden)

path, hash, hashes_fts, rank

886 rows

hashes_fts_config (hidden)

k, v

1 row

hashes_fts_data (hidden)

id, block

24 rows

hashes_fts_docsize (hidden)

id, sz

886 rows

hashes_fts_idx (hidden)

segid, term, pgno

22 rows

images_fts (hidden)

path, stem, url, image_blob, images_fts, rank

896 rows

images_fts_config (hidden)

k, v

1 row

images_fts_data (hidden)

id, block

1,052 rows

images_fts_docsize (hidden)

id, sz

896 rows

images_fts_idx (hidden)

segid, term, pgno

1,003 rows

images_no_blob_fts (hidden)

path, stem, url, images_no_blob_fts, rank

1,203 rows

images_no_blob_fts_config (hidden)

k, v

1 row

images_no_blob_fts_data (hidden)

id, block

23 rows

images_no_blob_fts_docsize (hidden)

id, sz

1,203 rows

images_no_blob_fts_idx (hidden)

segid, term, pgno

18 rows

resnet50_fts (hidden)

path, classification, resnet50_fts, rank

844 rows

resnet50_fts_config (hidden)

k, v

1 row

resnet50_fts_data (hidden)

id, block

45 rows

resnet50_fts_docsize (hidden)

id, sz

844 rows

resnet50_fts_idx (hidden)

segid, term, pgno

41 rows

Views

Download SQLite DB: gallery.db 33.6 MB