Skip to content
Docs

Quick Start

This guide will walk you through creating and deploying your first SQLPage application using Spry.

Development Workflow

Section titled “Development Workflow”

Follow these steps to generate SQLPage assets and start the development server:

SQLite Setup

Section titled “SQLite Setup”

  1. Generate SQLPage Source Files

    Section titled “Generate SQLPage Source Files”

    Generate the SQLPage source files from your Spryfile.md:

    Terminal window
    ./spry.ts spc --fs dev-src.auto --destroy-first --conf sqlpage/sqlpage.json

  2. Start Development Server

    Section titled “Start Development Server”

    Run Spry in watch mode for live reloading:

    Terminal window
    ./spry.ts spc --fs dev-src.auto --destroy-first --conf sqlpage/sqlpage.json --watch

  3. Deploy to Database

    Section titled “Deploy to Database”

    Deploy SQLPage components to your SQLite database:

    Terminal window
    ./spry.ts task deploy

  4. Start SQLPage Server

    Section titled “Start SQLPage Server”

    Launch the SQLPage server:

    Terminal window
    SQLPAGE_SITE_PREFIX="" sqlpage

    Your application will be available at http://localhost:8080

Your First Spryfile

Section titled “Your First Spryfile”

The Spryfile.md is where you define your application. Here’s a simple example:

# My First Spry App


## Database Setup


```bash prepare-db --descr "Initialize database"
sqlite3 app.db < schema.sql
```


## Home Page


```sql index.sql
SELECT 'text' AS component,
       'Welcome to Spry!' AS title,
       'This is my first SQLPage app' AS contents;
```

Understanding the Workflow

Section titled “Understanding the Workflow”

1. Write in Markdown

Define your application logic, routes, and tasks in Spryfile.md

2. Generate Assets

Spry converts your Markdown into SQLPage-compatible files

3. Deploy

Run tasks and deploy your application to the database

4. Serve

SQLPage serves your application directly from the database