Val Town Code SearchReturn to Val Town

3View 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. 
4
5![image.webp](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c8e102fd-39ca-4bfb-372a-8d36daf43900/public)
6
7## Install 

3View 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. 
4
5![image.webp](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c8e102fd-39ca-4bfb-372a-8d36daf43900/public)
6
7## Install 

16
17  // Get the data we want and send
18  let imgUrl = getImageUrl(frag, url);
19  let imgData = await getImageDataFromUrl(imgUrl);
20  let title = getTitle(frag);
21  let description = getDescription(frag);
23}
24
25function getImageUrl(frag, url) {
26  let imgUrl = "";
27  let selectors = [
28    "meta[property=\"og:image:secure_url\"]",
29    "meta[property=\"og:image:url\"]",
30    "meta[property=\"og:image\"]",
31    "meta[name=\"twitter:image:src\"]",
32    "meta[property=\"twitter:image:src\"]",
33    "meta[name=\"twitter:image\"]",
34    "meta[property=\"twitter:image\"]",
35    "meta[itemprop=\"image\"]",
36  ];
37  // Get image from the HTML fragment
38  let element;
39  for (let i = 0; i < selectors.length; i++) {
44  }
45
46  // Still not present? Try to get the image of the author and use it instead
47  element = frag.querySelector("img[alt*=\"author\" i]");
48  if (!imgUrl && element && element.src) {
50  }
51
52  // Still not present? Well let's take ANY visible image from the page.
53  // You leave me no choice, my friend.
54  element = frag.querySelector("img[src]:not([aria-hidden=\"true\"])");
65}
66
67async function getImageDataFromUrl(url) {
68  const response = await fetch(url);
69  const base64data = Buffer.from(await response.arrayBuffer()).toString("base64");
70  return "data:image/png;base64," + base64data;
71}
72
80  ];
81
82  // Get image from the HTML fragment
83  for (let i = 0; i < selectors.length; i++) {
84    element = frag.querySelector(selectors[i]);

3View 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. 
4
5![image.webp](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c8e102fd-39ca-4bfb-372a-8d36daf43900/public)
6
7## Install 

1# Code on Val Town
2
3![Screenshot 2024-02-27 at 1.25.46 PM.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/6b67bb0a-d80f-4f3d-5b17-57b5378b3e00/public)
4
5Adds a "Code on Val Town" ribbon to your page. This lets your website visitors navigate to the code behind it.

10  const table = stripAnsi(renderTable(zip(res)));
11
12  const resp = await fetch("https://sourcecodeshots.com/api/image", {
13    method: "POST",
14    headers: {
24  return new Response(resp.body, {
25    headers: {
26      "Content-Type": "image/png",
27      "Cache-Control": "fsjkdfdsjkj"
28    },

12    content: body.data.email_addresses[0].email_address
13      + " "
14      + body.data.profile_image_url,
15  });
16  return new Response("Success");

6
7Here's an example email from this Val:
8![Screenshot 2024-04-04 at 15.41.34.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c1377e35-446d-4c41-86e2-8b2447cf5100/public)
9
10Every time you run it, you'll get a different feature. By default, this uses the `lg-v6` model, which I think is a good one to start with, but this may change in the future as I train better feature dictionaries!

1# Favicons
2
3![light.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/e8532b85-8de0-40f5-47a1-d4b9580ff200/public)
4
5```html
6        <link
7          rel="icon"
8          href="https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/e8532b85-8de0-40f5-47a1-d4b9580ff200/public"
9          media="(prefers-color-scheme: light)"
10        />
13----
14
15![dark.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/f774eb95-7207-43bf-3a6b-a9a423d9bb00/public)
16
17```html
18        <link
19          rel="icon"
20          href="https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/f774eb95-7207-43bf-3a6b-a9a423d9bb00/public"
21          media="(prefers-color-scheme: dark)"
22        />

5/**
6 * Provides functions for interacting with your account's blob storage.
7 * Blobs can store any data type (text, JSON, images, etc.) and allow
8 * retrieval across different vals using the same key.
9 * ([Docs ↗](https://docs.val.town/std/blob))