30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable
129 }
130
131 async createDatabase(): Promise<void> {
132 try {
133 const columnDefs = this.columns.map(col =>
182 }
183 } catch (error) {
184 console.error(`Error creating database '${this.dbName}':`, error);
185 throw error;
186 }
227 }
228
229 async deleteDatabase(): Promise<void> {
230 try {
231 // Drop the main table
237 }
238
239 console.log(`Database '${this.dbName}' and its FTS indexes have been deleted.`);
240 } catch (error) {
241 console.error(`Error deleting database '${this.dbName}':`, error);
242 throw error;
243 }
414}
415
416// New standalone function to drop any database
417export async function dropDatabase(dbName: string): Promise<void> {
418 try {
419 await sqlite.execute(`DROP TABLE IF EXISTS ${dbName}`);
420 console.log(`Database '${dbName}' has been deleted.`);
421 } catch (error) {
422 console.error(`Error deleting database '${dbName}':`, error);
423 throw error;
424 }
5/**
6 * Every Val Town account comes with its own private
7 * [SQLite database](https://www.sqlite.org/) that
8 * is accessible from any of your vals.
9 * ([Docs ↗](https://docs.val.town/std/sqlite))
115
116// adapted from
117// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
118function rowFromSql(
119 sqlRow: Array<unknown>,
1# Uptime Checker & Status Page
2
3This is a free, hackable uptime/downtime monitor that sends you an email when the site doesn't return a 200. It also stores historical uptime and latency data in your Val Town SQLite, which is used to power a status page. It supports multiple URLs in the same database and status page.
4
5## Installation
121
122 return new Response(
123 JSON.stringify({ message: `Successfully uploaded ${records.length} records to the database.` }),
124 {
125 headers: { "Content-Type": "application/json" },
1Fork this val and then run, not sure if it will create the table in my database if you run this.
5/**
6 * Every Val Town account comes with its own private
7 * [SQLite database](https://www.sqlite.org/) that
8 * is accessible from any of your vals.
9 * ([Docs ↗](https://docs.val.town/std/sqlite))
115
116// adapted from
117// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
118function rowFromSql(
119 sqlRow: Array<unknown>,
4const ADMIN_PASSWORD = Deno.env.get("ADMIN_PASSWORD") || "defaultpassword"; // Set this in your Val Town environment variables
5
6async function initializeDatabase() {
7 await sqlite.execute(`
8 CREATE TABLE IF NOT EXISTS ${KEY}_emails (
24
25export default async function server(request: Request): Promise<Response> {
26 await initializeDatabase();
27 const url = new URL(request.url);
28
30- [ ] add triggers to sidebar
31- [ ] add upload from SQL, CSV and JSON
32- [ ] add ability to connect to a non-val town Turso database
33- [x] fix wonky sidebar separator height problem (thanks to @stevekrouse)
34- [x] make result tables scrollable