# Python
__pycache__/
*.py[cod]
*$py.class
*.so
.Python
build/
develop-eggs/
dist/
downloads/
eggs/
.eggs/
lib/
lib64/
parts/
sdist/
var/
wheels/
*.egg-info/

# Internal planning (optional - if you want to keep private)
docs/internal/

.installed.cfg
*.egg

# Virtual Environment
.venv/
venv/
ENV/
env/

# Testing
.pytest_cache/
.coverage
.coverage.*
htmlcov/
.tox/
.hypothesis/
pytest_debug.log

# IDE
.vscode/
!/.vscode/extensions.json
!/.vscode/settings.json.example
.idea/
*.swp
*.swo
*~
.project
.pydevproject

# Generated files (IMPORTANT)
generated/
!generated/.gitkeep
!generated/README.md
*.generated.sql
*.generated.py
db/schema/**/*.sql
!db/schema/**/README.md

# OS
.DS_Store
.DS_Store?
._*
.Spotlight-V100
.Trashes
ehthumbs.db
Thumbs.db

# Environment files
.env
.env.local
.env.*.local

# Logs
*.log
logs/
pip-log.txt

# Temporary files
tmp/
temp/
*.tmp

# Test outputs and temporary directories
test_*/
tmp_*/
*_output/
*.db
*.db-journal
*.db-wal
*.sqlite
*.sqlite3

# Coverage reports
.coverage
coverage.xml
*.cover

# Cache directories
.mypy_cache/
.ruff_cache/
.pytest_cache/
.hypothesis/

# Documentation builds
site/
docs/_build/
docs/.doctrees/

# Development scripts (now in scripts/dev/)
/compare_with_original.py
/generate_sql.py

# Editor directories
.vscode/
.idea/

# macOS
.DS_Store

# Database files (keep in migrations/)
/*.db
/*.sql

# Private/confidential
INVESTOR_EVALUATION.md
*_EVALUATION.md
*_CONFIDENTIAL.md
*_PRIVATE.md

# Security files
secrets/
credentials/
*.key
*.pem
*.p12
*.pfx

# Large files (add specific patterns as needed)
*.mp4
*.mov
*.avi
*.zip
*.tar.gz
*.rar
pgvector/

# Rust build artifacts
rust/target/

# Internal planning and archives (not for public repo)
backup_internal/
