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-ratings

User and project reputation system - ~100 lines - Bidirectional ratings tied to projects - Immune to volume/value manipulation - Categorical scoring (quality, communication, timeliness) - Full Specification

dbbasic-jobs

Job board with applications and bidding - ~200 lines - Post jobs, receive applications, award contracts - Simple 4-state workflow (open, in_progress, completed, cancelled) - Budget ranges, skill matching, application proposals - Full Specification

dbbasic-groups

Community organization and access control - ~250 lines - Public, private, and secret groups - Membership management (join, approve, ban) - Owner, admin, member roles - Integrates with forum, jobs, follows - Full Specification

dbbasic-events

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

dbbasic-forum

Discussion boards with flat threading - ~200 lines - Categories, threads, flat posts (Stack Overflow style) - Pinned/locked/solved threads, view counting - AI summaries, solution marking - Grep-able TSV storage - 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

dbbasic-examples

Example applications built with DBBasic - GitHub - Blog, microblog, API examples - Module template for new projects - Real-world usage patterns

dbbasic-sound

Synthesized sound effect generator - GitHub - 48+ royalty-free sound effects - Bells, buzzers, notifications, UI sounds - Pure Python, NumPy only

dbbasic-web-native

100+ production-ready UI components in pure HTML/CSS - GitHub - Zero dependencies, no JavaScript required - Copy-paste ready components - Built in 2 days with AI - Replaces Bootstrap (300KB → plain HTML/CSS)

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