MS
MinerSheets by Diofis
Sign In

Access Required

Sign in to access MinerSheets revolutionary features

Sign In Now
Dark Mode
Toggle theme

Access Required

Sign in to access MinerSheets revolutionary features

Sign In Now
Dark Mode
Toggle theme

Access Required

Sign in to access MinerSheets revolutionary features

Sign In Now
Dark Mode
Toggle theme

Access Required

Sign in to access MinerSheets revolutionary features

Sign In Now
Dark Mode
Toggle theme
↑↓ Navigate ↵ Select ESC Close
Powered by Fuse.js

Welcome to MinerSheets

The backbone of operational excellence

Home / Documentation / Architecture

🏗️ System Architecture

Understanding MinerSheets revolutionary design and technical foundation

📐 Architecture Overview

MinerSheets is built on a Dynamic Model Factory architecture that combines the best of Google AppSheet's visual approach with Django's robustness and Laravel's elegant relationships.

🎨

Frontend Layer

Tailwind CSS + Alpine.js for modern, reactive UI with zero build step

⚙️

Backend Layer

Django 4.2 with dynamic model registration and runtime schema management

🗄️

Data Layer

PostgreSQL 15 with dynamic schema synchronization and automatic migrations

🛠️ Technology Stack

Backend Framework

Django 4.2.7 with Python 3.11+

ORM, admin interface, authentication, and dynamic model support

Database

PostgreSQL 15

Advanced data types, JSON support, and runtime schema modifications

Frontend Technologies

Tailwind CSS 3.x + Alpine.js 3.x

Utility-first CSS framework and lightweight reactive components

API Framework

Django REST Framework + Token Authentication

RESTful API endpoints with comprehensive validation

Development Tools

Docker, Pre-commit Hooks, Comprehensive Testing

Quality enforcement and dual environment methodology

🧩 Core Components

1. Dynamic Model Factory

The heart of MinerSheets - allows runtime model creation without code or migrations.

Key Features:

  • Runtime Django model registration
  • Automatic database schema synchronization
  • Google AppSheet-style display field selection
  • Laravel-style custom field relations
  • Advanced admin integration

2. Schema Builder Module

Core module handling all dynamic model operations and database management.

Responsibilities:

  • CustomModel and CustomField management
  • Database schema synchronization (database.py)
  • Admin interface customization (admin.py)
  • Frontend views and templates (views.py)
  • RESTful API endpoints (api_views.py)

3. Three-Section Admin Interface

Organized admin interface for logical separation of concerns.

Model Factory

Create and configure new models

Generated Models

Manage dynamically created models

System Admin

Django core administration

🗄️ Database Schema

Core Tables

schema_builder_custommodel

Stores model definitions (name, table, display field)

schema_builder_customfield

Stores field configurations (type, options, relations)

schema_builder_<model_name>

Dynamically created tables for user-defined models

💡 Smart Design: Tables are created and modified at runtime without migrations, while maintaining full Django ORM compatibility and referential integrity.

🔄 Request Flow Architecture

1

User Request

Browser sends request to Django (via Nginx in production)

2

URL Routing

Django URLs route to appropriate view function

3

View Processing

View retrieves dynamic model from registry, queries database

4

Template Rendering

Django template engine renders HTML with context data

5

Response Delivery

Alpine.js enhances interactivity on client side

🚀 Dual Environment Methodology

⚡ Native Development (Port 9319)

  • ✓ Instant hot reload for rapid iteration
  • ✓ Full IDE debugging support
  • ✓ Direct access to Python environment
  • ✓ Perfect for daily development

🐳 Docker Production (Port 9320)

  • ✓ Production-like environment testing
  • ✓ Container isolation and consistency
  • ✓ Infrastructure validation
  • ✓ Deployment confidence before push

🎯 Best Practice: Both environments share the same PostgreSQL database (port 5434), ensuring zero data inconsistency while providing different testing contexts.

🔒 Security Architecture

Authentication & Authorization

  • • Django session-based authentication
  • • Token authentication for API access
  • • @login_required decorators for protected views
  • • Permission-based access control

Data Protection

  • • CSRF protection on all forms
  • • SQL injection prevention via ORM
  • • XSS protection with template escaping
  • • Secure password hashing (PBKDF2)

📚 Related Documentation

🚀
Getting Started
5-minute quick start
⚙️
Installation
Full setup guide
🚀
Deployment
Production guide
🔌
API Reference
RESTful endpoints
MS
MinerSheets

Revolutionary Data Management platform by Diofis Enterprise. Phenomenal artwork in technology that transforms how companies manage data.

Made with ❤️ in Bitung, North Sulawesi, Indonesia by Hendrik Mamarodia.

Quick Links

  • Dashboard
  • All Models
  • Model Factory

Support

  • User Guide
  • API Reference
  • Help Center
  • About Us
  • Site Map
  • Privacy Policy
  • Terms of Service

© 2025 MinerSheets by Diofis Enterprise (Data Infra Ekselen). All rights reserved.

LinkedIn Company Developer Bitung, Indonesia