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# 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).
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).
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.
3
4export let turso = createClient({
5 url: process.env.TURSO_DATABASE_URL,
6 authToken: process.env.TURSO_AUTH_TOKEN,
7});
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.
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# processTracksBlobsJob
2
3Periodically fetch all Spotify tracks from Blob storage and update the `tracks` database with a subset of display information.
4
5Keys take the format: `spotify_track_id:4tVhBXOhSlqYCL2IjyoUNu`.
105 {
106 name: "Use Val Town SQLite to store data",
107 prompt: "Write a val that uses an SQLite database",
108 code: `import { sqlite } from "https://esm.town/v/std/sqlite?v=4";
109
8import { ValTownBlobNotFoundError } from "https://esm.town/v/std/ValTownBlobNotFoundError";
9
10// Initialize the database
11await sqlite.execute(`
12 CREATE TABLE IF NOT EXISTS blobs (