Common Workflows

Development Workflow

Follow these steps to set up and run your development environment:

# 1. Initialize project
./spry.ts init

# 2. Start development server with live reload
./spry.ts spc --fs dev-src.auto --destroy-first --conf sqlpage/sqlpage.json --watch --with-sqlpage

# 3. List and execute tasks as needed
./spry.ts task ls
./spry.ts task prepare-db

What this does:

• Initializes the project structure and dependencies
• Launches a development server with automatic file watching and live reload
• Provides task management capabilities for database preparation and other setup tasks

---

Deployment Workflow

Deploy your application to production with these steps:

# 1. Clean development artifacts
rm -rf dev-src.auto

# 2. Package and deploy to database
./spry.ts spc --package --conf sqlpage/sqlpage.json | sqlite3 production.db

# 3. Start SQLPage server
sqlpage

What this does:

• Removes temporary development files
• Packages the application and deploys it to the production database
• Starts the SQLPage server to serve the application

---

Task Management Workflow

Manage and execute tasks efficiently:

# 1. List available tasks
./spry.ts task ls

# 2. Execute specific task
./spry.ts task my-task --verbose rich

# 3. Execute all tasks in order
./spry.ts runbook --summarize

What this does:

• Displays all available tasks in the project
• Runs a specific task with detailed verbose output
• Executes all tasks sequentially with a summary of results