1import { createClient } from "jsr:@supabase/supabase-js@2";
2
3const connectionString = Deno.env.get('DATABASE_URL')
4const supabaseUrl = Deno.env.get('SUPABASE_URL')
5const supabaseKey = Deno.env.get('SUPABASE_ANON_KEY')
1### Example project with Supabase
2
3This is an example ValTown project that uses Supabase both as a database and an authorization service.
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
28
29 const [selectedInstance, setSelectedInstance] = useState(instanceTypes[0]);
30 const [numberOfDatabases, setNumberOfDatabases] = useState(2);
31
32 const calculateParameters = (instance, dbCount) => {
64 value: max_replication_slots,
65 description: 'Maximum number of replication slots',
66 recommendation: 'Should be 2+ more than number of databases'
67 },
68 max_wal_sender: {
87
88 const parameters = useMemo(() =>
89 calculateParameters(selectedInstance, numberOfDatabases),
90 [selectedInstance, numberOfDatabases]
91 );
92
148
149 <div style={{ flex: 1 }}>
150 <label style={{ display: 'block', marginBottom: '5px' }}>Number of Databases</label>
151 <input
152 type="number"
153 value={numberOfDatabases}
154 min="1"
155 max="50"
156 onChange={(e) => setNumberOfDatabases(Number(e.target.value))}
157 style={{
158 width: '100%',
234 </h3>
235 <ul style={{ paddingLeft: '20px' }}>
236 <li>Parameters are dynamically calculated based on instance vCPUs and database count</li>
237 <li>Calculations ensure proper scaling for replication and background processes</li>
238 <li>Always validate these recommendations in your specific environment</li>
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).
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))
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# 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
701 const SCHEMA_VERSION = 2;
702
703 // Set up database tables
704 await sqlite.execute(`
705 CREATE TABLE IF NOT EXISTS ${KEY}_students_${SCHEMA_VERSION} (