Livoa LogoLivoa
Custom JSON-Schema Content System Architecture
Client-Side (Browser)
Schema Builder UI


• Drag & Drop Palette

• Tree View Editor

• Property Inspector

• Live JSON Preview

• Import/Export

Libraries: Tangram JSON Schema Editor
React Components

Content Builder UI


• Dynamic Form Generation

• Schema-based Validation

• Real-time Preview

• Content Instance CRUD

• Media Upload Support

Libraries: react-jsonschema-form
AJV for client validation

Client-Side Processing


• Real-time form rendering from JSON Schema

• Basic client-side validation (required fields, types)

• Instant preview of schema changes and content layout

API Communication Layer


RESTful APIs • Authentication/Authorization • Error Handling • Response Caching

Server-Side (Backend)
REST API Endpoints


Schema Operations:

POST /api/schemas - Create

GET /api/schemas - List all

GET /api/schemas/{id} - Get one

PUT /api/schemas/{id} - Update

DELETE /api/schemas/{id} - Delete

Content Operations:

GET/POST /api/schemas/{id}/content

GET/PUT/DELETE /api/content/{cid}

GET /api/schemas/check-duplicates

Business Logic Layer


Schema Processing:

• JSON Schema validation (AJV)

• Duplicate detection algorithms

• Schema normalization

• Version management

Content Processing:

• Content validation against schema

• CRUD operations

• Media handling

• Preview generation

Data Storage Layer
PostgreSQL Database
schemas Table


id SERIAL PRIMARY KEY

name TEXT NOT NULL UNIQUE

version INT NOT NULL

schema_json JSONB NOT NULL

is_predefined BOOLEAN

created_at TIMESTAMP

updated_at TIMESTAMP

content_items Table


id SERIAL PRIMARY KEY

schema_id INT REFERENCES

content_data JSONB

title TEXT

status TEXT

created_at TIMESTAMP

updated_at TIMESTAMP

Database Optimizations


• GIN Index on schema_json JSONB column for fast JSON queries

• Composite unique constraints on (name, version)

• JSONB optimized storage and querying for schema and content data

Key System Features
Duplicate Detection


• JSON normalization

• Exact match detection

• Similarity scoring (80% threshold)

• Property overlap analysis

Schema Management


• Predefined schemas (product, profile)

• Custom schema creation

• Version control

• Schema validation

Dynamic Content Forms


• Auto-generated forms

• Schema-driven validation

• Real-time preview

• Media upload support

Security & Performance


• Authentication/Authorization

• Input validation & sanitization

• JSONB indexing optimization

• API rate limiting

Deployment & Monitoring


• Container deployment (Docker)

• API logging and monitoring

• Error tracking

• Performance metrics

custom content-type

by chirag

0
0 uses