sqlite

db

Public

Edit with AI

1 Branch

Val Town is a collaborative website to build and scale JavaScript apps.

Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.

main.tsx

README.md

Query All Public Vals

Example: val town leaderboard


import { zip } from "https://esm.town/v/pomdtr/sql";
import { db } from "https://esm.town/v/sqlite/db";

const res = await db.execute("SELECT author_username, COUNT(*) AS val_count FROM vals GROUP BY author_username ORDER BY 2 DESC LIMIT 10");
console.table(zip(res));

87766bc40d912e65680d7452ef6946c03b95369fedac5c1fa4cf2f941252b4c7.png

Code