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
18}
19
20async function initializeDatabase() {
21 await sqlite.execute(`
22 CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (
255
256export default async function(req: Request): Promise<Response> {
257 await initializeDatabase();
258
259 const url = new URL(req.url);
8const DEFAULT_IMAGE_URL = "https://res.cloudinary.com/dzkwltgyd/image/upload/v1733165766/image-input-block-production/apjbm5nfc6yoevwnisxh.jpg";
9
10// Inventory Database Initialization
11async function initializeInventoryDatabase() {
12 await sqlite.execute(`
13 CREATE TABLE IF NOT EXISTS ${INVENTORY_TABLE} (
225// Main Handler
226export default async function(req: Request): Promise<Response> {
227 await initializeInventoryDatabase();
228
229 const url = new URL(req.url);
42 <p>Our comprehensive resource center is dedicated to helping you navigate the exciting world of Cricut crafting. We'll guide you through finding the best free SVG files, understanding their potential, and mastering your Cricut machine to bring your most imaginative designs to life.</p>
43
44 <p>For those looking to dive deep into the world of free SVG resources, we recommend exploring sites like <a href="https://crafty-crafter.club" target="_blank" rel="noopener noreferrer">Crafty Crafter Club</a>, which offers an extensive collection of community-driven designs. Additionally, <a href="https://svgfiles.info/" target="_blank" rel="noopener noreferrer">SVG Files Info</a> provides a comprehensive database of high-quality vector graphics that can elevate your crafting projects.</p>
45 </section>
46 </div>
68 <li>
69 <strong>SVG Files Info</strong>
70 <p>The ultimate comprehensive SVG database for digital crafters. <a href="https://svgfiles.info/" target="_blank" rel="noopener noreferrer">SVG Files Info</a> offers an unparalleled collection of vector graphics that cater to every imaginable crafting project.</p>
71 </li>
72 </ul>
4Specifically, this will support the full [@libsql/client interface](https://docs.turso.tech/sdk/ts/reference#simple-query)._
5
6[SQLite](https://www.sqlite.org/) is a lightweight, standard database. Every Val Town account comes with its own private SQLite database that is accessible from any of your vals via [`std/sqlite`](https://www.val.town/v/std/sqlite).
7
8Val Town SQLite is powered by [Turso](https://turso.tech/).
12* [ORMs](https://docs.val.town/std/sqlite/orms)
13
14We recommend these admin data viewers for managing your database – viewing or editing data or your database table schema:
15
16* [Outerbase Studio](https://libsqlstudio.com/) **(recommended)** - formely known as LibSQL Studio – see instructions [here](https://libsqlstudio.com/docs/connect-valtown)
20 <h1>notUber -- Its kinda like Lyft</h1>
21 <p>I built this as part of a larger project, as well a demo.</p>
22 <p>The stack consists of <a href="https://www.clerk.com">Clerk</a> for Auth, <a href="https://www.instantdb.com">InstantDB</a> for my database, and the <a href="https://developers.google.com/maps">Google maps api</a> for maps and routing etc.</p>
23 <p>All the vals are located <a href="https://vawogbemi-notuberfolder.web.val.run">here</a>.</p>
24 <h3>Getting Started</h3>
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
3I built this as part of a larger project, as well a demo.
4
5The stack consists of [Clerk](https://www.clerk.com) for Auth, [InstantDB](https://www.instantdb.com) for my database, and the [Google maps api](https://developers.google.com/maps) for maps and routing etc.
6
7All the vals are located [here](https://vawogbemi-notuberfolder.web.val.run).
2import { DB } from 'https://esm.town/v/@std/sqlite';
3
4// Initialize SQLite database
5const db = new DB();
6db.execute(`
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>,