Set up PostgreSQL with required extensions and initial models

[darth-veitcher]

Set up core database infrastructure for GeoLens.

Tasks:

• [ ] Create database initialization script
• [ ] Install and configure PostGIS extension
• [ ] Install and configure pgVector extension
• [ ] Install and configure AGE extension
• [ ] Implement SQLAlchemy models for:
  • [ ] locations
  • [ ] architectural_features
  • [ ] historical_events
  • [ ] relationships
• [ ] Add database migration system
• [ ] Create basic data seeding script

Technical Notes:

• Use asyncpg for async database operations
• Ensure spatial index creation
• Add vector similarity search capabilities

[darth-veitcher]

Progress Update: ✅ Created PostgreSQL cluster with replication ✅ Installed required extensions ✅ Created initial schema with tables and indexes ✅ Set up application user and permissions ✅ Added automated timestamp management

Next steps:

• [ ] Implement SQLAlchemy models
• [ ] Create database migration system
• [ ] Add basic data seeding script