walter
/
camera-database
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
4 Commits 1 Branch 0 Tags 39 MiB
Commit Graph

4 Commits

Author SHA1 Message Date
Walter Jekat d6f483349c COMPLETE: Imported all 74,020 Goergens cameras 
FINAL STATISTICS:
- 74,020 cameras successfully imported (100%)
- 45 duplicates skipped (as expected)
- 2,516 manufacturers
- 28,667 camera models
- 36,080 housing variants
- 6,606 unique lenses
- 1,135 unique shutters

30+ years of Harald Goergens' camera classification work
now preserved in PostgreSQL database.

Import challenges overcome:
- VARCHAR sizes adjusted (viewfinder_type, body_type, combo_number)
- NULL constraints relaxed (body_type, format_code)
- Transaction management per-row to prevent cascade failures
- ID verification to prevent cache poisoning
- 12 malformed IDs handled gracefully
- 46 duplicate IDs documented for later review
 2025-11-17 23:54:23 +01:00
Walter Jekat 10f7d7c8a4 Complete database schema v1.0 
- 26 tables for Goergens hierarchy + content + auth
- Multi-level linking for images/documents/articles
- Rights management (verified/uncertain/restricted)
- Denormalized fields for performance
- 3 materialized views for dashboard/search
- Audit trail with history tables
- Multilingual terminology system
- PostgreSQL 16 features (JSONB, ranges, GIN/GIST indexes)

Ready for Goergens data import (74,000+ cameras)
 2025-11-17 20:37:15 +01:00
Walter Jekat b52d3347e1 PostgreSQL 16 setup complete on /mnt/data 
- Created camera_db database
- Configured for development (1.5GB shared_buffers)
- Running on port 5433 alongside PostgreSQL 14
- Data directory: /mnt/data/postgresql/16/camera
 2025-11-17 19:17:32 +01:00
Walter Jekat cc01712fa6 Initial project structure 2025-11-17 18:32:58 +01:00