Electropedia: EV Database Interface and Catalog Admin

Electropedia is the web interface for a curated electric-vehicle database: a public read-only catalog for users and an authenticated catalog admin for maintaining the underlying EV knowledge base. It exposes the same structured data that powers the EV advisor stack, but in a browsable, QA-friendly, SEO-oriented form.

Production Snapshot

The live catalog at ev1.ru currently exposes 75 brands, 534 models, and 1508 trims. Models can be searched and filtered by brand, powertrain, body type, Russia price, range, recycling-fee eligibility, winter-operation score, production years, and other practical buyer-facing fields.

Public Catalog

The public side behaves like a compact automotive wiki and database browser. Users can search the vehicle catalog, inspect model and trim data, open galleries, compare key facts, read buyer reasons and cautions, and report problems in facts, prices, translations, outdated data, or photos. Model pages are rendered server-side enough to support sitemap/robots output and public indexing.

Admin Panel

Authenticated users can edit selected model and trim fields, upload additional JPEG/PNG/WebP media, choose category hero images, mark bad images as invalid, and preserve revision safety through optimistic locking. Every edit can produce a patch artifact, and SQL-backed deployments can record admin patches while keeping JSON seed snapshots available for review and rollback.

Data Architecture

The system started from manually curated JSON seed files and now uses generated SQLite and PostgreSQL catalog backends behind the same repository contract. This lets the advisor runtime, Chat API, Telegram bot, and catalog admin read consistent vehicle data while the project moves toward SQL as the primary source of truth.

Product Value

Electropedia turns a large internal EV research corpus into an operational interface: buyers get a searchable encyclopedia of models, while maintainers get tooling for fast QA, media cleanup, data correction, and controlled synchronization between production edits and the repository.