Configuration

Configure Spry and SQLPage for your project

SQLPage Configuration

Configure SQLPage in sqlpage/sqlpage.json:

{
  "database_url": "sqlite://app.db",
  "port": 8080,
  "site_title": "My Spry Application",
  "site_prefix": "",
  "max_uploaded_file_size": 10485760,
  "environment": "development"
}

Configuration Options

database_url

Connection string for your database (SQLite or PostgreSQL)

"database_url": "postgresql://user:pass@localhost:5432/db"

port

Port number for the SQLPage server (default: 8080)

site_title

Default title for your application pages

site_prefix

URL prefix for all routes (useful for subdirectory deployments)

Environment Variables

Configure Spry using environment variables:

# Database connection
export DATABASE_URL="postgresql://localhost:5432/mydb"

# SQLPage configuration
export SQLPAGE_PORT=8080
export SQLPAGE_SITE_PREFIX=""

# Spry behavior
export SPRY_WATCH_INTERVAL=500
export SPRY_LOG_LEVEL="info"

Tip

💡 Tip Use separate configuration files for development and production environments.

Project Structure

Recommended directory structure for Spry projects:

project/
├── Spryfile.md              # Main executable markdown
├── spry.ts                  # Spry CLI script
├── sqlpage/
│   ├── sqlpage.json         # SQLPage config (dev)
│   ├── sqlpage.prod.json    # Production config
│   └── migrations/          # Database migrations
├── dev-src.auto/            # Generated SQLPage files (dev)
├── dist/                    # Production build output
├── scripts/                 # Additional scripts
└── data/                    # Data files and seeds

Multiple Configurations

Use different configurations for different environments:

Development

./spry.ts spc --fs dev-src.auto --conf sqlpage/sqlpage.json --watch

Production

./spry.ts spc --fs dist --conf sqlpage/sqlpage.prod.json