To avoid fiddling with local SQLite databases and synchronization, a single feature/model replica database is used. It is located at cloud01 and is a simple PostgreSQL server:

postgresql://picalike:picalike@cloud01.picalike.corpex-kunden.de:5401/features

The following data is located there

• features: DeiT net features with 384 dim (blob)
• colors: V3 color features (float array)
• models: pickled models of category pairs A vs. B
• missing: a list of image URL that neeeds to be enriched

By default no indexes are created. The 'id' field is always the primary key.

Keywords: pgsql cloud01 features models replica color kat doc mapping

Useful SQL queries:

select pg_size_pretty(pg_relation_size('models'));

To vacuum and or analyze for index statistics:

[vacuum] analyze missing;