Platform features

Comprehensive overview of Concordia’s capabilities for community building and social repair.

Platform features

Concordia provides a comprehensive suite of features designed to strengthen communities, facilitate collaboration, and enable social repair.

Multi-language support

Concordia is built with internationalization at its core, supporting four languages with full translation coverage.

Supported languages

• French (fr) - Default language
• English (en)
• Arabic (ar) - Full right-to-left (RTL) support
• Spanish (es)

All content, UI elements, and routes are fully localized. Arabic language includes complete RTL layout support with proper dir attribute handling.

Translation files are located in src/i18n/ with complete coverage across all locales validated by automated tests.

Authentication and user roles

Powered by Better Auth with comprehensive security features.

Security features

• Email and OAuth authentication
• Session management with automatic expiration
• Rate limiting (5 failed attempts trigger temporary lockout)
• Email verification with secure one-time tokens
• Password reset with expiring tokens
• Audit logging for all security events
• Protection against timing attacks, homograph attacks, and SQL injection
• RBAC (Role-Based Access Control) and ABAC (Attribute-Based Access Control)

User roles:

• Citizen (default) - Base authenticated user
• Owner - Manages places and establishments
• Author - Creates blog content
• Mediator - Facilitates conflict resolution
• Educator - Manages educational modules
• Moderator - Moderates community content
• Admin - Full platform administration

Users can have multiple roles simultaneously (e.g., citizen + author + mediator).

Blog CMS

Full-featured content management system for community storytelling and information sharing.

Blog capabilities

• Rich content editor with markdown support
• Article categories and translations
• Author management with profiles and avatars
• Featured articles and organization blogs
• Media library for images and attachments
• Comment system with nested replies
• Rating and review functionality
• Publication workflow (draft → pending review → published)
• SEO optimization with meta tags and structured data
• Related posts and recommendations

Database tables: blog_posts, blog_authors, blog_categories, blog_translations, blog_media, blog_comments, blog_organization

The blog system is already implemented with 8 dedicated database tables. See src/database/schemas/blog_*.schema.ts for details.

Services marketplace

Connect community members with local services, products, and mutual aid opportunities.

Marketplace features

• Local services directory with provider profiles
• Classified ads (buy/sell/trade/free)
• Service availability and booking management
• Pricing tiers and negotiable rates
• Location-based search and filtering
• Category organization
• Review and rating system
• Commission tracking for platform sustainability

Supports various service types:

• Hourly services (e.g., plumbing, tutoring)
• Fixed-price services (e.g., furniture assembly)
• Free community services (skill sharing)
• Mobile services (provider travels to client)

Places directory

Comprehensive directory of local establishments, points of interest, and community spaces.

Directory features

• Owner submission and management workflow
• Multi-category classification (accommodation, gastronomy, activities, commerce)
• Dynamic attributes system (customizable per category)
• Multilingual support for place descriptions
• Geolocation with map integration (Leaflet)
• Opening hours and contact information
• Image galleries
• Accessibility information
• Price range indicators
• Review and rating aggregation
• Publication status (pending → published → archived)

Specialized place types:

• Accommodation (hotels, camping, gîtes) with capacity and amenities
• Gastronomy (restaurants, cafes) with cuisine type and dietary options
• Activities with duration, age range, and seasonal availability
• Trails and hiking routes with GPX tracks and difficulty ratings

Organizations

Manage community organizations, associations, and collaborative groups.

Organization features

• Organization profiles with branding
• Member management with roles and permissions
• Invitation system
• Organization-specific blogs
• Service and event management
• Team directory
• Metadata and custom attributes

Database tables: organization, member, invitation (Better Auth integration)

Bookings system

Schedule and manage service appointments, event registrations, and resource reservations.

Booking capabilities

• Service availability management
• Calendar-based booking interface
• Booking confirmation and notifications
• Cancellation policies with time limits
• Payment integration with commission tracking
• Advance booking requirements
• Capacity management for group services

Supports bookings for:

• Local services (1-on-1 or group)
• Events and workshops
• Accommodation reservations
• Resource rental (future scope)

Reviews and ratings

Comprehensive feedback system with moderation capabilities.

Review features

• Overall rating (0.5 to 5.0 stars)
• Sub-ratings for specific criteria (service, cleanliness, value, location, ambiance)
• Written review with title and content
• Owner response capability
• Moderation workflow
• Aggregate rating calculation
• Review count tracking
• Status management (published, moderated, deleted)

Implemented for: Places, services, events, and products

Protection: One review per user per place, owner can respond once

Community forums

Thematic discussion spaces for community engagement and knowledge sharing.

Forum features

• Hierarchical category structure (up to 3 levels)
• Thread creation and management
• Nested post replies
• Pinned and locked threads
• Post count tracking
• Last post timestamp for sorting
• Moderation tools
• Status management (published, closed, moderated)

Forums support discussions on:

• Civic repair and community projects
• Local services and recommendations
• Environmental initiatives
• Educational topics
• General community chat

Messaging system

Private real-time communication between community members.

Messaging features

• One-on-one and group conversations
• Participant management
• Message threading
• Read status tracking
• Notification integration

Events and volunteer projects

Organize community gatherings, workshops, and collaborative initiatives.

Event features

• Event creation with date, time, and location
• Registration management with capacity limits
• Public and private events
• Event categories
• Integration with places directory
• Image galleries
• Comments and discussion

Volunteer project features

• Project creation and management
• Task breakdown and assignment
• Volunteer participation tracking
• Skills matching
• Progress reporting
• Impact metrics

Notifications

Keep users informed about relevant platform activity.

Notification types

• New messages
• Booking confirmations
• Review responses
• Event reminders
• Forum replies
• System announcements
• Moderation updates

Database: notification table with type, status, target tracking, and read status

Digital wallet

Manage transactions, commissions, and community currency.

Wallet features

• User balance tracking
• Transaction history
• Commission calculation for platform sustainability
• Payment integration
• Donation support for campaigns

Audit and transparency

Comprehensive logging and reporting for accountability.

Audit features

• Audit log for all critical actions
• User action tracking (login, logout, profile changes)
• Content moderation history
• Transaction records
• Impact metrics dashboard
• Transparency reports
• IP and user agent logging

Database: audit_log table with action, user, target, IP, user agent, and metadata

Administration panel

Comprehensive tools for platform management and moderation.

Admin capabilities

• User management (roles, permissions, banning)
• Content moderation (blog, comments, reviews, forum, classifieds)
• Organization management
• Category and taxonomy administration
• Attribute definition system
• Audit log review
• Site configuration
• Analytics and reporting

Admin routes: /admin, /admin/users, /admin/blog, /admin/moderation, /admin/audit, /admin/config

Technical features

Developer features

• Astro 5.x SSR for optimal performance
• Drizzle ORM for type-safe database queries
• Better Auth with OAuth and session management
• PostgreSQL with comprehensive migrations
• CSS design tokens with 4 theme variants (initial, modern, retro, futuristic)
• Comprehensive test suite (unit, integration, e2e, security)
• i18n routing with slug mapping
• Component library (30+ UI components)
• Leaflet integration for maps
• Markdown editor (EasyMDE)

All features include comprehensive test coverage. See tests/ for examples including auth flow, RBAC/ABAC, i18n routing, SSR rendering, and security validation.

Next steps

Database schema

Explore the complete database structure and relationships.

API reference

Learn how to interact with Concordia’s APIs.