# Astro + EmDash libSQL + R2 Starter

> A production starter for self-hosting an Astro SSR site with EmDash on Dokploy, using libSQL and Cloudflare R2.

Source: https://emdashcmseverything.com/templates/astro-emdash-libsql-r2-starter/

- Format: Community theme
- Status: available
- Version: 0.1.0
- Price: Free
- Stack: Astro 7 + EmDash CMS 0.38 + Node.js + libSQL + Cloudflare R2
- License: MIT
- Repository: https://github.com/milzamsz/astro-emdash-libsql-r2-starter
- Published: 2026-11-07

## Overview

This starter deploys an Astro SSR site with EmDash as two independent services on Dokploy: a stateless application and a native libSQL primary database. Media goes to Cloudflare R2, and it comes from the same author as the SQLite and R2 starter.

## Included

- Node standalone adapter, local development on node:sqlite, and a libSQL dialect resolved at runtime so credentials never end up in the build.
- EmDash core migrations run automatically at runtime, with direct browser-to-R2 media uploads.
- Includes a Dockerfile, Dokploy environment examples, a backup policy, and tests for the libSQL and parity paths.

## Create a project

```sh
git clone https://github.com/milzamsz/astro-emdash-libsql-r2-starter.git
cd astro-emdash-libsql-r2-starter
pnpm install
pnpm dev
```

## Compatibility and source

Documented stack: Astro 7 + EmDash CMS 0.38 + Node.js + libSQL + Cloudflare R2. License: MIT. It pins EmDash 0.38.0, so check compatibility before upgrading to EmDash 1.x. Verified against upstream sources on 2026-11-11. Review before adopting: [repository](https://github.com/milzamsz/astro-emdash-libsql-r2-starter).
