Log inSign up
sqlite
sqlitedb
Public
Like
db
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.
Sign up now
Code
/
Search
main.tsx
README.md

Query All Public Vals

Example: val town leaderboard

Create val
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

HTTP
Code