Search
sqliteExplorerApp
@vawogbemi
SQLite Explorer View and interact with your Val Town SQLite data. It's based off Steve's excellent SQLite Admin val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by LibSQL Studio by invisal . This is now more an SPA, with tables, queries and results showing up on the same page. Install Install the latest stable version (v86) by forking this val: Authentication Login to your SQLite Explorer with password authentication with your Val Town API Token as the password. Todos / Plans [ ] improve error handling [ ] improve table formatting [ ] sticky table headers [x] add codemirror [ ] add loading indication to the run button (initial version shipped) [ ] add ability to favorite queries [ ] add saving of last query run for a table (started) [ ] add visible output for non-query statements [ ] add schema viewing [ ] add refresh to table list sidebar after CREATE/DROP/ALTER statements [ ] add automatic execution of initial select query on double click [x] add views to the sidebar [ ] add triggers to sidebar [ ] add upload from SQL, CSV and JSON [ ] add ability to connect to a non-val town Turso database [x] fix wonky sidebar separator height problem (thanks to @stevekrouse) [x] make result tables scrollable [x] add export to CSV, and JSON (CSV and JSON helper functions written in this val . Thanks to @pomdtr for merging the initial version!) [x] add listener for cmd+enter to submit query
HTTP (deprecated)
# SQLite Explorer
View and interact with your Val Town SQLite data. It's based off Steve's excellent [SQLite Admin](https://www.val.town/v/stevekrouse/sqlite_admin?v=46) val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by [LibSQL Studio](https://github.com/invisal/libsql-studio) by [invisal](https://github.com/invisal). This is now more an SPA, with tables, queries and results showing up on the same page.
## Install
Install the latest stable version (v86) by forking this val:
[)](https://www.val.town/v/nbbaier/sqlite_explorer/fork)
/** @jsxImportSource https://esm.sh/hono@latest/jsx **/
EditorSection,
MockTable,
Separator,
linkInBioTemplate
@n8lenahan
@jsxImportSource https://esm.sh/react
HTTP (deprecated)
/** @jsxImportSource https://esm.sh/react */
export default async function(req: Request) {
return new Response(
renderToString(
<html>
<head>
<meta charSet="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Nathan Lenahan</title>
</head>
similarSites
@peterzakin
An interactive, runnable TypeScript val by peterzakin
Script
const exaSecret = Deno.env.get("EXA_API_KEY");
const exa = new Exa(exaSecret);
const similarSites = async function(url: string) {
const results = await exa.findSimilar(url);
if (results.results) {
let elements = results.results.map((el) => {
return {
"score": el.score,
"url": el.url,
elements.sort((a, b) => b.score - a.score);
helloMe
@andytl
An interactive, runnable TypeScript val by andytl
Script
import { hello } from "https://esm.town/v/andytl/hello";
export let helloMe = hello + ", Andy";
greenAnglerfish
@tmcw
An interactive, runnable TypeScript val by tmcw
HTTP (deprecated)
throw new Error("hi")
const x = 18
console.log(x)
export { x }
neverthrow
@nbbaier
Usage import { Failure, Success } from "https://esm.town/v/pomdtr/neverthrow?v=5";
const demoFunction = () => {
const result = Math.random();
if (result > 0.5) {
return Failure(
"Math. random produced too high a number",
);
}
return Success(result);
};
const res = demoFunction();
if (res.ok) {
console.log(res.value);
} else {
console.error(res.error);
}
Script
# Usage
```ts
const demoFunction = () => {
const result = Math.random();
if (result > 0.5) {
return Failure(
interface Success<T> {
ok: true;
value: T;
interface Failure<E> {
aqi
@cfab
An interactive, runnable TypeScript val by cfab
Cron
export let aqi = async () => {
let pm25 = (
await fetchJSON(
"https://api.openaq.org/v2/latest?" +
new URLSearchParams({
limit: "10",
page: "1",
location: "Geneva",
offset: "0",
sort: "desc",
reactClientDemo
@wilhelm
Idiomatic SSR and hydration of a React app
HTTP (deprecated)
Idiomatic SSR and hydration of a React app
/** @jsxImportSource https://esm.sh/react */
const Counter = () => {
const [count, setCount] = React.useState(0);
return (
<button onClick={() => setCount(count + 1)}>
I've been clicked {count} times
</button>
const App = () => (
<html>
sayHello
@parthraghav
An interactive, runnable TypeScript val by parthraghav
Script
export const sayHello = () => {
return "Hello, World!";
myName
@rodrigotello
An interactive, runnable TypeScript val by rodrigotello
Script
export let myName = "Rodrigo";
emojiByCodepoints
@jdan
An interactive, runnable TypeScript val by jdan
Script
import { allEmoji } from "https://esm.town/v/jdan/allEmoji";
export const emojiByCodepoints = (async () => {
const _ = await import("npm:lodash-es");
return _.keyBy(allEmoji, (emoji) => {
return codepoints(emoji.emoji).join("-");
sdk
@breadchris
An interactive, runnable TypeScript val by breadchris
Script
import { setup } from "https://esm.town/v/webscale/setup";
export const sdk = setup;
PriestGPTClient
@mjweaver01
PriestGPT Client Client for https://www.val.town/v/mjweaver01/PriestGPT Ask him about books or verses in the bible, and he will be sure to give you a short sermon about it!
HTTP (deprecated)
# PriestGPT Client
Client for https://www.val.town/v/mjweaver01/PriestGPT
Ask him about books or verses in the bible, and he will be sure to give you a short sermon about it!
/** @jsxImportSource https://esm.sh/hono/jsx */
const app = new Hono();
app.get("/", (c) => {
return c.render(
`<html>
<head>
<title>PriestGPT</title>
sqliteExplorerApp
@willthereader
SQLite Explorer View and interact with your Val Town SQLite data. It's based off Steve's excellent SQLite Admin val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by LibSQL Studio by invisal . This is now more an SPA, with tables, queries and results showing up on the same page. Install Install the latest stable version (v86) by forking this val: Authentication Login to your SQLite Explorer with password authentication with your Val Town API Token as the password. Todos / Plans [ ] improve error handling [ ] improve table formatting [ ] sticky table headers [x] add codemirror [ ] add loading indication to the run button (initial version shipped) [ ] add ability to favorite queries [ ] add saving of last query run for a table (started) [ ] add visible output for non-query statements [ ] add schema viewing [ ] add refresh to table list sidebar after CREATE/DROP/ALTER statements [ ] add automatic execution of initial select query on double click [x] add views to the sidebar [ ] add triggers to sidebar [ ] add upload from SQL, CSV and JSON [ ] add ability to connect to a non-val town Turso database [x] fix wonky sidebar separator height problem (thanks to @stevekrouse) [x] make result tables scrollable [x] add export to CSV, and JSON (CSV and JSON helper functions written in this val . Thanks to @pomdtr for merging the initial version!) [x] add listener for cmd+enter to submit query
HTTP (deprecated)
# SQLite Explorer
View and interact with your Val Town SQLite data. It's based off Steve's excellent [SQLite Admin](https://www.val.town/v/stevekrouse/sqlite_admin?v=46) val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by [LibSQL Studio](https://github.com/invisal/libsql-studio) by [invisal](https://github.com/invisal). This is now more an SPA, with tables, queries and results showing up on the same page.
## Install
Install the latest stable version (v86) by forking this val:
[)](https://www.val.town/v/nbbaier/sqlite_explorer/fork)
/** @jsxImportSource https://esm.sh/hono@latest/jsx **/
EditorSection,
MockTable,
Separator,