Model-config web apps: describe the app in configuration instead of writing code. Built on Polars and DuckDB.
DBBasic Template Marketplace
Overview
This directory contains production-ready application templates that demonstrate DBBasic's full capabilities. Each template showcases complete business applications built entirely through configuration - no code required.
🎯 Why These Templates Matter
These templates prove that DBBasic achieves what Rails, Django, and other frameworks required thousands of lines of code to accomplish - all through simple YAML configuration.
📦 Available Templates
🌐 Blog Platform (/blog/)
Complete content management system with SEO optimization
- Posts Management: Rich content editor, SEO metadata, social sharing
- Category Organization: Hierarchical content structure
- Author Management: Multi-author support with permissions
- Comment System: Real-time engagement with moderation
- Analytics: View tracking, performance metrics
Key Features Demonstrated:
- ✅ Rich content editing with WYSIWYG
- ✅ SEO automation (Open Graph, Twitter Cards)
- ✅ Real-time WebSocket updates
- ✅ File upload with image optimization
- ✅ Search and filtering
- ✅ Social media integration
🛒 E-Commerce Platform (/ecommerce/)
Enterprise-grade online store with full business workflow
- Product Catalog: Variants, inventory, pricing, images
- Order Management: Complex workflow from cart to delivery
- Payment Processing: Multiple gateways, fraud detection
- Inventory Control: Multi-warehouse, real-time sync
- Customer Management: Accounts, wishlists, order history
- Analytics & Reporting: Sales metrics, customer insights
Key Features Demonstrated:
- ✅ Complex state machine workflows (order status)
- ✅ Financial calculations with decimal precision
- ✅ Multi-step form workflows
- ✅ External API integration (payments, shipping)
- ✅ Advanced permission systems
- ✅ Real-time inventory management
- ✅ Business intelligence and analytics
💼 CRM System (/crm/)
Customer relationship management with sales pipeline
- Lead Management: Capture, qualify, nurture prospects
- Contact Database: Companies, people, relationships
- Sales Pipeline: Opportunity tracking, forecasting
- Activity Logging: Calls, emails, meetings, notes
- Reporting: Sales performance, conversion metrics
Key Features Demonstrated:
- ✅ Kanban board interface
- ✅ Relationship mapping
- ✅ Activity timeline
- ✅ Sales automation
- ✅ Custom fields and attributes
📊 Project Management (/project-management/)
Agile project tracking with team collaboration
- Task Management: Kanban boards, sprint planning
- Team Collaboration: Assignment, comments, file sharing
- Time Tracking: Estimates vs actuals, billing
- Project Organization: Milestones, dependencies
- Resource Management: Workload balancing
Key Features Demonstrated:
- ✅ Drag-and-drop Kanban interface
- ✅ Real-time collaboration
- ✅ Time tracking and reporting
- ✅ File attachment system
- ✅ Notification workflows
📱 Social Media Platform (/social-media/)
Community platform with user-generated content
- User Profiles: Personal information, activity feeds
- Content Sharing: Posts, images, videos
- Social Features: Following, likes, comments, shares
- Messaging: Direct messages, group chats
- Moderation: Content filtering, user reporting
Key Features Demonstrated:
- ✅ User-generated content management
- ✅ Real-time feeds and notifications
- ✅ Social graph relationships
- ✅ Content moderation workflows
- ✅ Media upload and processing
🚀 What These Templates Prove
Rails Comparison
Rails Blog: 50+ files, 2000+ lines of Ruby code DBBasic Blog: 3 YAML files, 200 lines of configuration
Django Comparison
Django E-Commerce: 100+ files, 5000+ lines of Python DBBasic E-Commerce: 8 YAML files, 800 lines of configuration
Time to Market
- Traditional Framework: 3-6 months development
- DBBasic Templates: Deploy in 30 minutes
🎨 Bootstrap Integration
All templates showcase DBBasic's Bootstrap Config Mapping:
# Instead of writing HTML/CSS
ui:
theme: bootstrap
variant: ecommerce
components:
list:
variant: table-hover
pagination: true
form:
variant: horizontal
validation: real_time
This generates production-ready interfaces using every Bootstrap component pattern.
⚡ Advanced Features Demonstrated
Model Hooks System
Every template shows configuration-driven business logic:
hooks:
before_create: validate_business_rules
after_create: send_notifications
before_update: check_permissions
after_update: sync_external_systems
Real-time Updates
All templates include WebSocket integration for live updates without additional configuration.
AI Service Integration
Business logic is automatically generated by AI based on hook descriptions - no manual coding required.
Event Sourcing
Complete audit trails and analytics built-in to every template.
🔧 How to Use Templates
1. Copy Template Configuration
cp templates/blog/* ./
2. Start DBBasic Services
python dbbasic_crud_engine.py & # Port 8005
python dbbasic_ai_service_builder.py & # Port 8003
3. Access Your Application
- Admin Interface: http://localhost:8005
- API Documentation: http://localhost:8005/docs
- Real-time Monitor: http://localhost:8004
4. Customize Configuration
Modify YAML files to add fields, change workflows, or adjust UI components. Changes are applied instantly.
📈 Performance Characteristics
Database Performance
- DuckDB: 402M rows/sec query performance
- Automatic indexing: No manual optimization needed
- Real-time analytics: Built-in aggregation queries
Web Performance
- Real-time updates: WebSocket efficiency
- Responsive design: Mobile-first Bootstrap components
- CDN integration: Automatic asset optimization
🎯 Template Architecture
Each template follows DBBasic's Configuration-Driven Architecture:
template/
├── entities/ # Core data models
│ ├── posts_crud.yaml
│ ├── categories_crud.yaml
│ └── users_crud.yaml
├── workflows/ # Business process flows
├── integrations/ # External service configs
└── ui/ # Interface customizations
🔮 Future Template Additions
Coming Soon:
- Learning Management System (LMS)
- Healthcare Practice Management
- Restaurant Point of Sale
- Real Estate Listings
- Event Management Platform
- Subscription Billing System
🎉 The DBBasic Advantage
These templates demonstrate that DBBasic has achieved the original vision of:
- Microsoft FrontPage - Visual web building
- Dreamweaver - WYSIWYG application development
- Ruby on Rails - Convention over configuration
- Django Admin - Automatic admin interfaces
But better - because:
- ✅ No Code Required: Pure configuration
- ✅ Production Ready: Enterprise-grade performance
- ✅ AI Enhanced: Business logic auto-generated
- ✅ Future Proof: Config stays current as runtime improves
🚀 Start Building
Pick a template, copy the configuration, and have a production application running in minutes.
This is the future of web development - where configuration IS the application.