Val Town Code SearchReturn to Val Town

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>,

1# SQLite - [Docs ↗](https://docs.val.town/std/sqlite)
2
3[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).
4
5Val Town SQLite is powered by [Turso](https://turso.tech/).
9* [ORMs](https://docs.val.town/std/sqlite/orms)
10
11We recommend these admin data viewers for managing your database – viewing or editing data or your database table schema:
12
13* [Outerbase Studio](https://libsqlstudio.com/) **(recommended)** - formely known as LibSQL Studio – see instructions [here](https://libsqlstudio.com/docs/connect-valtown)

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))

7It's currently super limited (no pagination, editing data, data-type specific viewers), and is just a couple dozens lines of code over a couple different vals. Forks encouraged! Just comment on the val if you add any features that you want to share.
8
9To use it on your own Val Town SQLite database, [fork it](https://www.val.town/v/stevekrouse/sqlite_admin/fork) to your account.
10
11It uses [basic authentication](https://www.val.town/v/pomdtr/basicAuth) with your [Val Town API Token](https://www.val.town/settings/api) as the password (leave the username field blank).

44  // 2. Check password strength
45  // 3. Hash password
46  // 4. Store in database
47
48  return {

2
3/**
4 * Initialize database tables for authentication system
5 * Includes users, login attempts, and verification tokens
6 */
7export async function initializeDatabase() {
8  // Use the val's unique identifier as a prefix for tables
9  const KEY = "sqLiteDatabase";
10  const SCHEMA_VERSION = 3; // Increment when schema changes
11
54    `);
55
56    console.log(`Database tables initialized for authentication system (Schema v${SCHEMA_VERSION})`);
57    return { success: true, message: 'Database setup complete' };
58  } catch (error) {
59    console.error('Database initialization error:', error);
60    return { 
61      success: false, 
62      message: 'Failed to initialize database',
63      error: error.message 
64    };
67
68/**
69 * Utility function to reset or clean up database
70 * Use with caution in production
71 */
72export async function resetDatabase() {
73  const KEY = "sqLiteDatabase";
74  const SCHEMA_VERSION = 3;
75
79    await sqlite.execute(`DROP TABLE IF EXISTS ${KEY}_verification_tokens_${SCHEMA_VERSION}`);
80    
81    await initializeDatabase();
82    
83    console.log('Database reset completed successfully');
84    return { success: true, message: 'Database reset complete' };
85  } catch (error) {
86    console.error('Database reset error:', error);
87    return { 
88      success: false, 
89      message: 'Failed to reset database',
90      error: error.message 
91    };
94
95/**
96 * Utility function to perform database migrations
97 * Call this when schema changes are needed
98 */
99export async function migrateDatabase() {
100  const KEY = "sqLiteDatabase";
101  const SCHEMA_VERSION = 3;
102
108    `);
109
110    console.log('Database migration completed successfully');
111    return { success: true, message: 'Database migration complete' };
112  } catch (error) {
113    console.error('Database migration error:', error);
114    return { 
115      success: false, 
116      message: 'Failed to migrate database',
117      error: error.message 
118    };
120}
121
122// Initialize database on module import
123initializeDatabase();
124
125export default {
126  initializeDatabase,
127  resetDatabase,
128  migrateDatabase
129};