DBBasic

Tiny Python Web Framework

DBBasic


πŸ†• Free Office Suite for macOS

DBBasic Suite v1.0 - Complete office productivity apps. Free forever.

Download Writer | Download Spreadsheet | Download Slides

Why DBBasic Suite? - βœ… Free Forever - No subscription, no registration, no credit card - βœ… Portable Files - HTML-based documents work everywhere - βœ… No Lock-In - Your data is yours, readable in any browser - βœ… Privacy-First - Local storage, no cloud required, no tracking - βœ… Lightweight - 20MB per app vs 3GB+ for Office

What's Included: - DBBasic Writer - Word processor with templates, formatting, find/replace - DBBasic Spreadsheet - Formulas (SUM, AVERAGE), calculations, cell editing - DBBasic Slides - Presentations with edit/present modes, PDF export

macOS 10.15+ | 60MB total download | Full details & installation β†’ | License Terms


DBBasic Framework

DBBasic is a radically simple Python web framework that proves modern web development doesn't need 300,000 lines of codeβ€”it delivers file-based routing, TSV database storage with ACID transactions, stateless authentication, async job queues, video processing, and deployment tools in under 8,000 total lines by rejecting ORM complexity, embracing plain-text data that you can grep and version with git, and treating Unix philosophy as a feature not a limitation, achieving 5,000+ requests/second on $5 VPS hardware while Django struggles at 50 req/s because sometimes the best way forward is remembering what CGI-bin got right: one file per endpoint, transparent data, three-second deployments via rsync, and the radical idea that you should be able to cat your database and actually understand what you're looking at.

A collection of lightweight Python web framework components. Each module is under 500 lines and uses TSV files for storage.


Core Foundation

dbbasic-tsv βœ…

Honey Badger

TSV database with transactions - PyPI | Source - Tab-separated value storage - ACID transactions - SQL-like queries

dbbasic-pipe βœ…

Beaver

Unix pipes for data processing - PyPI | Source - Stream processing - Pipeline composition - Memory efficient

dbbasic-web βœ…

Coyote

Lightweight web framework - PyPI | Source - Routing and controllers - Template rendering - Request/response handling

dbbasic-content βœ…

Packrat

Content management and publishing - PyPI | Source - Markdown content management - Static site generation - Content versioning

dbbasic-video βœ…

Dragonfly

Video processing and streaming - PyPI | Source - Video upload and encoding - Streaming support - Thumbnail generation

dbbasic-sessions βœ…

Gecko

User session management for authentication - PyPI | Source - Signed cookies, no storage - Stateless authentication - Full Specification

dbbasic-queue βœ…

Ant

TSV-based job queue for async tasks - PyPI | Source - Retry logic with exponential backoff - Cron-based workers - Full Specification

dbbasic-logs βœ…

Squirrel

Structured logging with rotation - PyPI | Source - TSV format, auto-compression - Searchable with grep/Python API - Full Specification

dbbasic-accounts βœ…

Meerkat

Unix-style user management for web apps - PyPI | Source - Mirrors /etc/passwd, /etc/shadow, /etc/group - Dual API (Unix + web-friendly) - Full Specification

dbbasic-email βœ…

Pigeon

Unix mail + SMTP delivery - PyPI | Source - Local mail (mbox format) - SMTP queue integration - Full Specification

dbbasic-admin βœ…

Octopus

Auto-discovery admin interface - PyPI | Source - Zero-config module discovery - Auto-generated CRUD for TSV tables - Full Specification

dbbasic-rss βœ…

Pelican

Simple RSS feed generation - PyPI | Source - Framework-agnostic (Flask, Django, FastAPI) - Works with TSV, CSV, JSON, directories - Standards-compliant RSS 2.0

dbbasic-follows βœ…

Starling

Social graph and follow system - PyPI | Source - One-directional follow relationships - Automatic friend detection (mutual follows) - Smart follow/friend suggestions - Built-in admin interface

dbbasic-forms βœ…

Spider

Git-native form builder with TSV storage - PyPI | Source - Visual drag-drop form builder - TSV storage for forms and responses - Auto-discovered admin interface - CSV export and analytics - Full Specification


Tools & CLI

dbbasic-cli βœ…

Carpenter Bee

Command-line tool for creating and managing apps - PyPI | Source - Standard directory structure - Module command auto-discovery - Full Specification

dbbasic-deploy βœ…

Salmon

SSH deployment tool for Ubuntu servers - PyPI | Source - Nginx + Let's Encrypt SSL - systemd service management - Zero-downtime deployments

dbbasic-compiler βœ…

Owl

AI compiler that understands English - PyPI | Source - Natural language to code - Powered by Claude Sonnet 4.5 - Zero syntax errors

dbbasic-manx

Owl

BBS/ANSI-style manual page viewer - Source - Zero dependencies (Python stdlib only) - 256-color ANSI output with syntax highlighting - Works with less/pager for keyboard navigation - Full Specification


Desktop Tools

dbbasic-copypaste βœ…

Magpie

Clipboard manager with history for macOS - PyPI | Source - Real-time clipboard monitoring - Text and image support - Browse up to 100 previous items - PyQt5 interface

dbbasic-screenshot βœ…

Chameleon

Fast screenshot annotation tool for macOS - PyPI | Source - Capture partial screen areas - Draw lines, arrows, rectangles, text - Multiple colors and line widths - Save to file or copy to clipboard


Phase 1: Production Essentials

dbbasic-events

Event sourcing and event bus - ~80 lines - Append-only event log, replay state - Full Specification


Phase 2: Common Features

dbbasic-api

REST API helpers - ~100 lines - Pagination, filtering, sorting - DRY conveniences

dbbasic-upload

File upload handling - ~200 lines - Storage management - Upload validation


Phase 3: Advanced Features

dbbasic-ai

AI integration (Claude, OpenAI) - ~300 lines - Summarization, moderation - Response caching

dbbasic-channels

WebSocket and SSE support - ~300 lines - Real-time updates - Broadcasting

dbbasic-background

Job orchestration and scheduling - ~200 lines - Scheduled tasks - Retry logic

dbbasic-workflow

State machine workflows - ~400 lines - Multi-step processes - State transitions


Utility Modules

dbbasic-exports

Data export functionality - ~100 lines - CSV, JSON, XML export - Bulk downloads

dbbasic-imports

Data import and ETL - ~150 lines - CSV, JSON parsing - Data validation

dbbasic-backups

Automated backups - ~100 lines - Scheduled backups - Restore functionality

dbbasic-stats

Analytics and metrics - ~100 lines - Usage tracking - Reports

dbbasic-filters

Query helpers and filters - ~50 lines - Common query patterns - SQL shortcuts


Enterprise Features

dbbasic-enterprise

SSO and compliance - Authentication integrations - Audit logging - GDPR tools

dbbasic-subdomains

Multi-tenant support - Subdomain routing - Tenant isolation - Data partitioning

dbbasic-accounting

Financial ledger - Double-entry bookkeeping - Transaction tracking - Reports


Specialized Modules

dbbasic-video

Video processing - Upload and encoding - Streaming support - Thumbnail generation

dbbasic-editor

Rich text editing - WYSIWYG interface - Markdown support - Media embedding

dbbasic-apps

Plugin system - Extension architecture - Plugin management - Hooks and filters

dbbasic-reports

Report generation - Scheduled reports - PDF/Excel output - Dashboards

dbbasic-notifications

Multi-channel notifications - Email, SMS, push - Notification queue - User preferences

dbbasic-personalization

User customization - Themes and preferences - A/B testing - Feature flags

dbbasic-streams

Stream processing - Real-time data streams - Event processing - Aggregations

dbbasic-actors

Actor model concurrency - Message passing - Isolated state - Supervision

dbbasic-scaling

Load balancing and scaling - Request distribution - Session affinity - Auto-scaling

dbbasic-schema_ui

Database schema browser - Visual schema explorer - Relationship viewer - Query builder

dbbasic-public

Static site generation - Markdown to HTML - Asset pipeline - Fast static sites


Design Philosophy

Tiny: Each module under 500 lines Simple: TSV files, no complex dependencies Composable: Mix and match what you need Readable: Code you can understand and modify

Total Framework Size: ~8,000 lines (compare to Django: 300K, Rails: 200K)


Status

Currently in active development. Core modules (tsv, pipe, web) are complete.

Building in order of real-world need, not feature completeness.


Installation

pip install dbbasic_tsv
pip install dbbasic_web
# ... add modules as needed

Or install a bundle:

pip install dbbasic  # Core essentials
pip install dbbasic[full]  # Everything

Contributing

Each module is independently versioned and maintained.

Looking for contributors who value simplicity over features.


Related Projects

PyStructUI

Transform data structures into beautiful UIs for any Python web framework - GitHub - Data-driven UI rendering - Works with Flask, Django, FastAPI - Separates logic from presentation

AskRobots CommitGen

AI-powered git commit message generation - GitHub - Analyzes git diffs with GPT - Auto-commit with generated messages - AI-powered file modifications

AskRobots Discord

Scalable AI-powered Discord bot - GitHub - GPT-3.5-Turbo and GPT-4 integration - Plugin-oriented architecture - Docker deployment support


Last Updated: October 2025