1import { DB } from "https://esm.town/v/@std/sqlite";
2
3// Initialize SQLite database
4const db = new DB();
5db.execute(`
494 const KEY = new URL(import.meta.url).pathname.split("/").at(-1);
495
496 // Initialize database
497 await sqlite.execute(`
498 CREATE TABLE IF NOT EXISTS ${KEY}_project_state_${SCHEMA_VERSION} (
7export const countPath = (app) => {
8 app.get('/count', async (c) => {
9 const connectionString = Deno.env.get('DATABASE_URL')
10 const supabaseUrl = Deno.env.get('SUPABASE_URL')
11 const supabaseKey = Deno.env.get('SUPABASE_ANON_KEY')
15}
16
17async function initializeDatabase() {
18 await sqlite.execute(`
19 CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
27
28export default async function(interval: Interval) {
29 await initializeDatabase();
30
31 for (const url of URLS) {
65
66export async function getAllVersions() {
67 await initializeDatabase();
68 const versions = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`);
69 console.log(versions, TABLE_NAME);
8const openai = new OpenAI();
9
10// Initialize the database
11async function initDB() {
12 await sqlite.execute(`
459 `);
460 } catch (error) {
461 console.error("Database initialization error:", error);
462 return new Response("Database error", { status: 500 });
463 }
464
443 `);
444 } catch (error) {
445 console.error("Database initialization error:", error);
446 return new Response("Database error", { status: 500 });
447 }
448
1import { createClient } from "jsr:@supabase/supabase-js@2";
2
3const connectionString = Deno.env.get('DATABASE_URL')
4const supabaseUrl = Deno.env.get('SUPABASE_URL')
5const supabaseKey = Deno.env.get('SUPABASE_ANON_KEY')
1### Example project with Supabase
2
3This is an example ValTown project that uses Supabase both as a database and an authorization service.
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