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
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.
47 items: ["GraphQL", "RESTful API", "WebSockets", "gRPC", "Microservices", "Serverless", "Event-driven"],
48 },
49 database: {
50 icon: "💾",
51 items: ["sqlite", "PostgreSQL", "MySQL", "Redis", "Cassandra", "Elasticsearch", "DynamoDB"],
126 "azure-functions",
127 ],
128 database: [
129 "mongoose",
130 "sequelize",
331 "Set up Hono router",
332 "Implement main functionality logic",
333 "Add database integration",
334 "Implement authentication system",
335 "Set up API endpoints",
47 items: ["GraphQL", "RESTful API", "WebSockets", "gRPC", "Microservices", "Serverless", "Event-driven"],
48 },
49 database: {
50 icon: "💾",
51 items: ["sqlite", "PostgreSQL", "MySQL", "Redis", "Cassandra", "Elasticsearch", "DynamoDB"],
126 "azure-functions",
127 ],
128 database: [
129 "mongoose",
130 "sequelize",
331 "Set up Hono router",
332 "Implement main functionality logic",
333 "Add database integration",
334 "Implement authentication system",
335 "Set up API endpoints",
11 "HTTP vals",
12 "Scheduled vals",
13 "SQLite database",
14 "Blob storage",
15 "Email sending",
1# VALL-E-DRAW
2
3LLM code generation for vals, on a canvas! Make apps with a frontend, backend, and database.
4
5* First you need a working version of VALL-E. Follow the steps [here](https://www.val.town/v/janpaul123/VALLE).