How maxim-abuzarov/presight works
People Directory is a searchable, filterable directory with a React client, an Express API, and SQLite as its source of truth. The main workflow is: a person adjusts URL-synced search, filter, or sort state; the client requests paginated people and separately refreshed facet counts; the API validates requests and queries a shared filtered result set in SQLite; results and facets return to the interface. The graph also preserves database setup and data-seeding stages. Some links rely on the SOURCE INDEX or README because those implementation files were not excerpted.
Main entry points: App.tsx Directory view · connection.ts SQLite database · seed.ts Dataset seeding · users.repository.ts User queries
Components 29
Directory client
- Directory view
client/src/App.tsx - Filter state
client/src/hooks/useFilterState.ts - Directory queries
client/src/hooks/useDirectory.ts - API client
client/src/api/client.ts - Search control
client/src/components/SearchField.tsx - Sort controls
client/src/components/SortControls.tsx - Filter panels
client/src/components/FilterSidebar.tsx - Active filters
client/src/components/ActiveFilters.tsx - Virtual user list
client/src/components/UserList.tsx - Icons
client/src/components/Icon.tsx - SpiderWeb view
client/src/components/SpiderWeb.tsx - Loading and errors
client/src/components/States.tsx - Client data types
client/src/api/types.ts
API and domain
- API routes
server/src/users/users.routes.ts - Request handlers
server/src/users/users.controller.ts - User service
server/src/users/users.service.ts - User queries
server/src/users/users.repository.ts - Filter SQL
server/src/users/users.filters.ts - User domain types
server/src/users/users.types.ts - HTTP application
server/src/app.ts - Server startup
server/src/server.ts
SQLite storage
- SQLite database
server/src/db/connection.ts - Runtime configuration
server/src/config.ts
Data initialization
- Schema migrations
server/src/db/migrate.ts - Database schema
server/src/db/schema.ts - Dataset seeding
server/src/db/seed.ts - Seed datasets
server/src/db/datasets.ts - Database sealing
server/src/db/seal.ts
Other components
- Person
Connections 31
- Person → Directory view: uses
- Directory view → Filter state: reads state
client/src/App.tsx - Directory view → Directory queries: loads data
client/src/App.tsx - Directory view → Search control: renders
client/src/App.tsx - Directory view → Sort controls: renders
client/src/App.tsx - Directory view → Filter panels: renders
client/src/App.tsx - Directory view → Active filters: renders
client/src/App.tsx - Directory view → Virtual user list: renders
client/src/App.tsx - Directory view → SpiderWeb view: loads lazily
client/src/App.tsx - Directory view → Loading and errors: renders
client/src/App.tsx - Directory queries → API client: requests data
client/src/hooks/useDirectory.ts - API client → API routes: calls endpoints
- API client → Client data types: uses response types
client/src/api/client.ts - API routes → Request handlers: dispatches
server/src/users/users.routes.ts - Request handlers → User service: calls
server/src/users/users.controller.ts - User service → User queries: delegates queries
server/src/users/users.service.ts - User queries → Filter SQL: builds filtered queries
server/src/users/users.repository.ts - User queries → SQLite database: queries
server/src/users/users.repository.ts - User queries → User domain types: uses domain types
server/src/users/users.repository.ts - HTTP application → API routes: mounts API
server/src/app.ts - Server startup → HTTP application: starts
server/src/server.ts - Server startup → Schema migrations: runs before serving
server/src/server.ts - SQLite database → Runtime configuration: reads settings
server/src/db/connection.ts - Schema migrations → SQLite database: updates schema
server/src/db/migrate.ts - Schema migrations → Database schema: applies
server/src/db/migrate.ts - Dataset seeding → SQLite database: writes records
server/src/db/seed.ts - Dataset seeding → Seed datasets: loads records from
server/src/db/seed.ts - Dataset seeding → Schema migrations: ensures schema
server/src/db/seed.ts - Database sealing → SQLite database: checkpoints and seals
server/src/db/seal.ts - Dataset seeding → Runtime configuration: reads settings
server/src/db/seed.ts - Database sealing → Runtime configuration: reads settings
server/src/db/seal.ts