---
# System prepended metadata

title: 系統架構
tags: [log]

---

# 系統架構
## 前端
* Some UI like Perplexity
* https://github.com/mckaywrigley/clarity-ai

## Database design
* PostreSQL
* Schema Design: Design a schema that includes at least the following fields:
    * Photo ID: A unique identifier for each photo.
    * GPS Coordinates: Latitude and longitude.
    * Photo URL or Path: If storing photos externally (e.g., in cloud storage), store the URL or path to the photo.
    * Description: A field for the textual description of the location.
* Indexing: Implement indexing on the GPS coordinates to optimize queries based on location.
