Val Town Code SearchReturn to Val Town

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

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

116        {
117          name: "Use Val Town SQLite to store data",
118          prompt: "Write a val that uses an SQLite database",
119          code: `import { sqlite } from "https://esm.town/v/std/sqlite?v=4";
120  

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

6import pg from "npm:pg";
7
8type DatabaseType = "postgres" | "mysql" | "duckdb";
9
10interface QueryRequest {
11  databaseType: DatabaseType;
12  url?: string;
13  query?: string;
33  }
34
35  const { databaseType, url, query, introspect, gzip = false } = requestBody;
36  console.log(`Database type: ${databaseType}`);
37  console.log(`Query: ${query}`);
38  console.log(`Introspect: ${introspect}`);
39  console.log(`Gzip: ${gzip}`);
40
41  if (!databaseType) {
42    console.error("Missing database type");
43    return new Response("databaseType is required", { status: 400 });
44  }
45
49  }
50
51  if (databaseType !== "duckdb" && !url) {
52    console.error("Missing URL for non-DuckDB query");
53    return new Response("URL is required for postgres and mysql", { status: 400 });
57  try {
58    if (introspect) {
59      console.log(`Introspecting ${databaseType} schema`);
60      if (databaseType === "postgres") {
61        results = await introspectPostgresSchema(url!);
62      } else if (databaseType === "mysql") {
63        results = await introspectMysqlSchema(url!);
64      } else {
65        console.error(`Introspection not supported for ${databaseType}`);
66        return new Response(`Introspection not supported for ${databaseType}`, { status: 400 });
67      }
68    } else {
69      console.log(`Executing ${databaseType} query`);
70      if (databaseType === "postgres") {
71        results = await executePostgresQuery(url!, query!);
72      } else if (databaseType === "mysql") {
73        results = await executeMysqlQuery(url!, query!);
74      } else if (databaseType === "duckdb") {
75        console.log("DuckDB is not supported");
76        return new Response("DuckDB is not supported", { status: 400 });
77      } else {
78        console.error(`Invalid database type: ${databaseType}`);
79        return new Response("Invalid databaseType", { status: 400 });
80      }
81    }
118    if (error.code === "ETIMEDOUT") {
119      throw new Error(
120        "Connection to PostgreSQL timed out. Please check your database URL and ensure the database is accessible.",
121      );
122    }

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

38      todo("Inserting and Querying Data"),
39      todo("Running Migrations"),
40      todo("SQLite as a KV Database"),
41      todo("Drizzle in Val Town"),
42    ],

38      todo("Inserting and Querying Data"),
39      todo("Running Migrations"),
40      todo("SQLite as a KV Database"),
41      todo("Drizzle in Val Town"),
42    ],

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