sqlite

An interactive, runnable TypeScript val by gio

Forked from stevekrouse/sqlite_upgraded_tests

* This request collector val saves information about incoming requests * and displays summary statistics on the home page. It uses SQLite for * persistence and server-side React for rendering the UI. Users can click * on a request ID to view full details of that request.

* This tool fetches real-time data from various free APIs to create a JSON object * representing the current state of the world from different perspectives. * Data is cached for 30 minutes using Val Town's SQLite database to reduce API calls and improve performance.

Forked from kaz/marineMoccasinLizard

* This program creates a text storage and management application. * It uses Val Town's SQLite for persistence and React for the UI. * The app allows users to add, view, edit, and delete text entries with titles, tags, and categories. * It includes a header with navigation, search bar, filters, a tabbed template page with 100 templates, * a categories section, and a new history tab that logs all edits.

* This credit card payoff calculator app allows users to: * 1. Add and remove multiple credit cards with their balances and interest rates * 2. Calculate monthly payments based on desired payoff time * 3. View individual card payoff information * 4. See a combined view of all cards * 5. Visualize payoff data with different types of charts * * It uses React for the UI, SQLite for data persistence, and Chart.js for visualization. * The app is now optimized for mobile devices with responsive design.

Forked from ejfox/cavemanBezierApp

// This approach creates a minimalist, full-screen website that tracks the total number of clicks made anywhere on the page.

* This app implements a "Would You Rather" game with a ranking system for answers and a progress bar. * It uses React for the frontend and SQLite for persistent storage on the backend. * The ranking system updates based on user choices and displays in the Answers tab. * A progress bar is added to show completion of 20 questions.

// This app will create a virtual pet simulation game where users can adopt, care for, and interact with a digital creature.

// This mood tracker will use a GitHub-like contribution table to visualize mood entries.

Newsly inspired by https://kill-the-newsletter.com/ copy your email into a newsletter like substack read the newsletter here / store them into valtown you can set it so you can chat with it or send you alerts or whatever idk

// This app creates a community bulletin board where users can post messages with titles and view all posts.

example output { columns: [ "id", "content", "time" ], columnTypes: [ "INTEGER", "TEXT", "TIMESTAMP" ], rows: [ { id: 1, content: "asdfasdf", time: "2024-05-24 19:11:52" } ], rowsAffected: 0, lastInsertRowid: null }

Simple SQLite dashboard made by townie in this video: https://x.com/stevekrouse/status/1833577807093371325