Everything you need to build a Svelte project, powered by create-svelte.

Once you've created a project and installed dependencies with npm install (or pnpm install or yarn), start a development server:

npm run dev

# or start the server and open the app in a new browser tab
npm run dev -- --open

We're using SQLite with better-sqlite3 and a custom migrator function that allows us to declare our schema in plain ol' SQL (thank you David Rõthlisberger and William Manley).

We're using the SQLFluff CLI to lint our SQL.

Optionally, create a virtual environment. Then install SQLFluff with pip:

pip install sqlfluff

Lint!

# Ignore some rules we don't care about. The options are here: https://docs.sqlfluff.com/en/stable/cli.html#sqlfluff-lint
sqlfluff lint schema.sql --dialect sqlite -e RF06,LT02,LT05,LT12

To create a production version of your app:

npm run build

You can preview the production build with npm run preview.

To deploy your app, you may need to install an adapter for your target environment.