ditto

ditto

🔄 A powerful CLI tool for database synchronization between PostgreSQL and MySQL

✨ Features

• Schema Comparison - Compare table structures, columns, indexes, and constraints
• Data Synchronization - Sync data with full or incremental strategies
• Data Export - Export tables to JSON, CSV, or SQL format
• Cross-Database Support - PostgreSQL ↔ MySQL/MariaDB
• Beautiful CLI - Rich terminal output with colors, progress bars, and tables
• Configuration File Support - YAML config for complex setups

🚀 Installation

Using Go Install

go install github.com/anuryadi/ditto@latest

From Source

git clone https://github.com/anuryadi/ditto.git
cd ditto
make build

Binary Releases

Download pre-built binaries from the Releases page.

📖 Quick Start

Compare Database Schemas

# Compare PostgreSQL to MySQL
ditto compare \
  --source "postgres://user:pass@localhost:5432/source_db" \
  --target "mysql://user:pass@localhost:3306/target_db"

# Output to JSON
ditto compare \
  --source "postgres://user:pass@localhost/db1" \
  --target "mysql://user:pass@localhost/db2" \
  --format json \
  --output diff.json

Sync Data Between Databases

# Full sync
ditto sync \
  --source "postgres://user:pass@localhost/source" \
  --target "mysql://user:pass@localhost/target" \
  --tables users,orders,products

# Dry run (preview without changes)
ditto sync \
  --source "postgres://..." \
  --target "mysql://..." \
  --dry-run

Export Table Data

# Export to JSON
ditto export \
  --source "postgres://user:pass@localhost/db" \
  --table users \
  --format json \
  --output users.json

# Export to CSV
ditto export \
  --source "mysql://user:pass@localhost/db" \
  --table orders \
  --format csv \
  --output orders.csv

⚙️ Configuration

Create a .ditto.yaml file in your home directory or use --config flag:

source:
  driver: postgres
  host: localhost
  port: 5432
  database: source_db
  user: postgres
  password: ${DB_PASSWORD}  # Environment variable

target:
  driver: mysql
  host: localhost
  port: 3306
  database: target_db
  user: root
  password: ${DB_PASSWORD}

sync:
  strategy: full  # full, incremental
  batch_size: 1000
  tables:
    - name: users
      primary_key: id
      timestamp_column: updated_at
    - name: orders
      primary_key: id

logging:
  level: info
  format: console

🔧 Commands

Global Flags

🏗️ Architecture

ditto/
├── cmd/                    # CLI commands (Cobra)
├── internal/
│   ├── config/            # Configuration management (Viper)
│   ├── database/          # Database drivers (PostgreSQL, MySQL)
│   ├── schema/            # Schema comparison logic
│   ├── sync/              # Data synchronization engine
│   ├── export/            # Export handlers (JSON, CSV, SQL)
│   └── ui/                # Terminal UI components (pterm)
└── pkg/
    └── logger/            # Structured logging (zerolog)

🧪 Development

# Install dependencies
go mod download

# Run tests
make test

# Run with coverage
make coverage

# Lint code
make lint

# Build for all platforms
make build-all

📝 Roadmap

• SQLite support
• Oracle Database support
• Scheduled sync with cron
• Web dashboard for monitoring
• CDC (Change Data Capture) support

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

1. Fork the repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🙏 Acknowledgments

• Cobra - CLI framework
• Viper - Configuration management
• zerolog - Structured logging
• pterm - Terminal UI

Made with ❤️ by Ari Nuryadi