Replace sidebar with a fixed bottom nav bar on mobile (<768px) with
icon links for Home, Species, Cultivars, Companions, Search plus
a language toggle. CSS already updated in previous commit with:
- sidebar hidden on mobile, bottom-nav shown
- tables/calendars horizontally scrollable
- filter bars stacked vertically
- detail pages single-column
- stats grid 2-column on mobile
Backend: Use ts_rank_cd with A/D weights so name matches rank above description
matches. Switch to 'simple' text search config with :* prefix suffix for partial
word matching (e.g. "toma" finds "Tomate"). Include bilingual DE/EN fields in
search vectors. Cultivar search JOINs species so "tomato" finds tomato cultivars.
Return extra metadata: plant_layer, food_uses, species_name, is_organic, snippet.
Frontend: Show colored entity type badges (Familie/Art/Sorte). Display localized
common names, plant layer tags, food uses for species, species link + organic
badge for cultivars, and truncated description snippets. Add DE/EN i18n keys for
search result type labels.
Species detail now shows a "Companion Plants" card (left column, after
Ecology) with beneficial/antagonistic sub-lists. Each entry links to
the companion species and shows the mechanism.
Home page gains stats cards, quick-filter buttons, and a hero section.
Species list supports URL query params for quick-filter links.
New /api/v1/stats endpoint provides database counts.
i18n keys added for DE/EN: card.companion_plants, companions.beneficial_for,
companions.antagonistic_for, stat.*, filter.*, home.*.
Backend: new GET /api/v1/companions endpoint returning all companion
relationships with joined species names, slugs and images. Adds
CompanionWithNames model and list_all DB query.
Frontend: new /companions route with search bar, beneficial (green)
and antagonistic (red) sections, species thumbnails, mechanism text,
source links, and species detail links. Full DE/EN i18n support.
Migration 011 adds native_range_de, native_range_en, wildlife_value_de,
wildlife_value_en columns. Backend INSERT/UPDATE queries updated ($64→$68).
Frontend species and cultivar detail pages use pick_desc() for language selection.
Add t() translation function to i18n.rs with ~200 key/value pairs
covering navigation, card headers, field labels, buttons, filters,
planting calendar rows, and general UI text in both German and English.
Updated all 11 source files to use t(&lang, "key") instead of
hardcoded English strings: app.rs (sidebar nav), all 7 page files
(species, cultivars, families, suppliers, home, search, sources),
and all 3 component files (planting_calendar, table_controls,
plant_card). Boolean values (Yes/No/Annual) are also translated.
Backend: add 6 new columns to Species and CreateSpecies structs, update
INSERT/UPDATE queries, add migration 010.
Frontend: add fields to Species type, use pick_desc() for language-aware
display in species detail and cultivar species-info card.
When cultivar fields are empty, show species-level data as fallback with
italic styling and a "~ species" indicator. Applied to: frost tolerance
(from USDA zone), light requirement (inferred from plant layer), and
climate card (drought tolerance, USDA hardiness zone). Includes a footer
note explaining estimated values.
- S3 image proxy at /img/{path} with cache headers
- Species images displayed on species + cultivar detail pages
- Full CC attribution below each image: author, license, Wikimedia Commons link
- Image struct updated with source_url and license fields
Add indoor_sowing_weeks, direct_sowing_weeks, transplanting_weeks,
glasshouse_weeks, harvesting_weeks (integer[]) to backend Cultivar and
CreateCultivar structs with INSERT/UPDATE SQL bindings.
Frontend PlantingCalendar component rewritten as a compact 52-column
Gantt-style grid grouped by month headers. Prefers week data when
available, falls back to expanding month data into week ranges.
Calendar displayed full-width on cultivar detail page with color legend.
- Language switcher in sidebar (DE/EN buttons, persists to localStorage)
- i18n module with pick_desc/pick_name helpers for language-aware fallback
- All detail/list pages use language context for names and descriptions
- Species/Cultivar types updated with description_de/description_en
- Common Name column added to species/families lists
- Cultivar/species detail pages rewritten with two-column card layout, attribute tables, em-dash placeholders
- Column toggle + per-page selector on all list pages (families, species, cultivars, suppliers)
- Species list: table/card view toggle with family, layer, N-fixer, uses columns
- Cultivar detail: supplier links with SKU/price/product URL, species info section
- Data sources page (/sources) with attribution for all 10 data sources
- Fixed Cultivar/Species structs with #[serde(default)] for API compatibility
- Added table_controls component (reusable column toggle + per-page selector)
- Removed max-width constraint on content area for full-width tables
- Fixed route conflicts: merged {slug}/{id} into single {ref} routes
- Removed PostgreSQL enum types (plant_layer, drought_tolerance, etc.) in favor of TEXT
- Fixed API per_page parameter support across all list endpoints
florian.berthold