FeaturesTemplatesShowcaseTownie
AI
BlogDocsPricing
Log inSign up
wolf
wolfiClickWolf
Starter template with client-side React & Hono server
Public
Like
iClickWolf
Home
Code
7
.vscode
1
backend
3
frontend
3
.cursorrules
.vtignore
README.md
deno.json
Branches
1
Pull requests
Remixes
History
Environment variables
3
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
Sign up now
Code
/
backend
/
database
/
README.md
Code
/
backend
/
database
/
README.md
Search
4/19/2025
Viewing readonly version of main branch: v158
View latest version
README.md

Database

This directory contains the SQLite database setup for the iClickWolf application.

Files

  • migrations.ts - Contains the database schema and table creation logic
  • queries.ts - Contains typed functions for interacting with the database

Tables

Items (items_v1)

Stores product information for iClickers.

Preorders (preorders_v1)

Stores customer preorder information including payment status.

Schema Versioning

When changing the schema, create a new table with an incremented version number (e.g., items_v2) rather than altering existing tables. This is a best practice for SQLite in Val Town.

Go to top
X (Twitter)
Discord community
GitHub discussions
YouTube channel
Bluesky
Product
FeaturesCLIAI agentsCode intelligenceSlack integrationsGTMPricing
Developers
DocsStatusAPI ExamplesNPM Package Examples
Explore
ShowcaseTemplatesNewest ValsTrending ValsNewsletter
Company
AboutBlogCareersBrandhi@val.town
Terms of usePrivacy policyAbuse contact
© 2025 Val Town, Inc.