1# VALL-E
2
3LLM code generation for vals! Make apps with a frontend, backend, and database.
4
5It's a bit of work to get this running, but it's worth it.
2 * This application helps users write detailed reviews of coffee shops. It fetches coffee shop data
3 * from the OpenStreetMap Nominatim API, allows users to add custom details, and stores the augmented
4 * information in a SQLite database. The app provides a user interface to view, add, and edit coffee shop reviews.
5 *
6 * It uses React for the frontend, the Nominatim API for initial coffee shop data,
10 frontend: ["React", "Vue", "Angular", "Svelte"],
11 backend: ["Node.js", "Python", "Ruby", "Java"],
12 database: ["PostgreSQL", "MongoDB", "MySQL", "SQLite"],
13 hosting: ["AWS", "Google Cloud", "Heroku", "DigitalOcean"],
14};
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
64 });
65
66 // Database Inspection
67 console.log('\nDatabase Inspection:');
68 const tablesResult = await valTownUser.executeSqlite("SELECT name FROM sqlite_master WHERE type='table'");
69 console.log("Tables in the database:");
70 tablesResult.rows.forEach(row => console.log(row[0]));
71
87
88 } catch (error) {
89 console.error('Error fetching user data or inspecting database:', error);
90 }
91}
40### getId()
41Retrieves the user's ID.
42- Use case: Using the user ID for database queries or API calls.
43```ts
44import { valTownUser } from "https://esm.town/v/iamseeley/valTownUser";
265- Use case: Allowing users to remove their vals through your interface.
266
267## SQLite Database Operations
268
269### executeSqlite(statement)
270Executes a SQLite statement.
271- Use case: Running custom queries on the user's database.
272
273### listTables()
274Lists all tables in the user's SQLite database.
275- Use case: Displaying the structure of a user's database.
276
277### getTableSchema(tableName)
1# VALL-E
2
3LLM code generation for vals! Make apps with a frontend, backend, and database.
4
5It's a bit of work to get this running, but it's worth it.
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
1# VALL-E
2
3LLM code generation for vals! Make apps with a frontend, backend, and database.
4
5It's a bit of work to get this running, but it's worth it.
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