4import OpenAI from "https://esm.sh/openai";
5
6// Plant Database
7const PLANT_DATABASE = {
8 'Rosa damascena': {
9 scientificName: 'Rosa damascena',
166 : plantDescription;
167
168 const matchedPlant = Object.values(PLANT_DATABASE).find(
169 plant =>
170 plant.scientificName.toLowerCase() === scientificName.toLowerCase() ||
3import { createRoot } from "https://esm.sh/react-dom/client";
4
5// Expanded plant database with more comprehensive entries
6const PLANT_DATABASE = {
7 'Rosa damascena': {
8 scientificName: 'Rosa damascena',
94 if (bestMatch[1] > 0.6) { // Confidence threshold
95 resolve({
96 plant: PLANT_DATABASE[bestMatch[0]],
97 confidence: Math.round(bestMatch[1] * 100)
98 });
40 <li>We extract email domains from your user list</li>
41 <li>
42 We match these domains against our database of YC companies (sourced{" "}
43 <a href="https://docs.google.com/spreadsheets/d/181GQmXflgMCCI9awLbzK4Zf0uneQBKoh51wBjNTc8Us/edit?gid=0#gid=0">
44 here
45 </a>
46 , cached <a href="https://www.val.town/v/stevekrouse/yc_database">here</a>)
47 </li>
48 <li>You get a detailed report of matches, enriched with YC company data</li>
226
227export default async function server(request: Request): Promise<Response> {
228 const companies = await fetch("https://stevekrouse-yc_database.web.val.run").then(res => res.json());
229 const url = new URL(request.url);
230 if (url.pathname === "/companies.json") {
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
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
70 -d '{
71 "subject": "Critical Java Error",
72 "userDescription": "Database connection failed unexpectedly",
73 "errorStacktrace": "java.sql.SQLException: Connection refused\\n\\tat com.example.DatabaseManager.connect(DatabaseManager.java:42)",
74 "secretKey": "your-secret-key-here"
75 }'</pre>
77 <h3>Example JSON Structure:</h3>
78 <pre>{
79 "subject": "Database Connection Error",
80 "userDescription": "Failed to connect to production database during user login",
81 "errorStacktrace": "Full Java/language-specific error stacktrace goes here",
82 "secretKey": "your-secret-key-here"
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.
5/**
6 * Every Val Town account comes with its own private
7 * [SQLite database](https://www.sqlite.org/) that
8 * is accessible from any of your vals.
9 * ([Docs ↗](https://docs.val.town/std/sqlite))
115
116// adapted from
117// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
118function rowFromSql(
119 sqlRow: Array<unknown>,
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