258 headers: {
259 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',
260 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
261 'Accept-Language': 'en-US,en;q=0.5'
262 }
314 headers: {
315 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',
316 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
317 'Accept-Language': 'en-US,en;q=0.5',
318 'Referer': googleSearchUrl,
359 headers: {
360 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',
361 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8',
362 'Accept-Language': 'en-US,en;q=0.5',
363 'Referer': 'https://www.google.com/',
33 success: true,
34 faviconUrl: googleFaviconUrl,
35 contentType: "image/png", // Google Favicon API returns PNG
36 source: "google_api",
37 };
50 if (faviconResponse.ok) {
51 // Get the content type
52 const contentType = faviconResponse.headers.get("content-type") || "image/x-icon";
53 console.log(`Found favicon directly at ${faviconUrl} with content type: ${contentType}`);
54
88 }
89
90 // 3. Any image with "favicon" in the name or path
91 if (!match) {
92 const anyFaviconRegex = /href=[\"']([^\"']*favicon[^\"']*)[\"']/i;
112
113 if (faviconResponse.ok) {
114 const contentType = faviconResponse.headers.get("content-type") || "image/x-icon";
115 console.log(`Successfully fetched favicon from ${extractedFaviconUrl} with content type: ${contentType}`);
116
140 success: true,
141 faviconUrl: googleFaviconUrl,
142 contentType: "image/png",
143 source: "google_api_fallback",
144 };
14 <meta property="og:title" content="ANDP Property Data Analysis Dashboard" />
15 <meta property="og:description" content="Interactive dashboard for analyzing the ANDP property portfolio with data from Zillow and Google Sheets" />
16 <meta property="og:image" content="https://andp.surge.sh/og.jpg" />
17 <meta property="og:url" content="https://andp.surge.sh" />
18 <meta property="og:type" content="website" />
19 <meta name="twitter:card" content="summary_large_image" />
20 <meta name="twitter:title" content="ANDP Property Data Analysis Dashboard" />
21 <meta name="twitter:description" content="Interactive dashboard for analyzing the ANDP property portfolio with data from Zillow and Google Sheets" />
22 <meta name="twitter:image" content="https://andp.surge.sh/og.jpg" />
23 <meta name="description" content="Interactive dashboard for analyzing the ANDP property portfolio with data from Zillow and Google Sheets" />
24 <meta name="keywords" content="ANDP, property data, real estate, analytics, dashboard" />
6 <title>React Hono Val Town Starter</title>
7 <link rel="stylesheet" href="/frontend/style.css">
8 <link rel="icon" href="/frontend/favicon.svg" type="image/svg+xml">
9 </head>
10 <body>
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
6
7## Install
220 <div className="result-header">
221 <div className="result-header-content">
222 {result.image_url && (
223 <div className="project-image">
224 <img src={result.image_url} alt={result.project_name} />
225 </div>
226 )}
298 <div className="result-header">
299 <div className="result-header-content">
300 {result.image_url && (
301 <div className="project-image">
302 <img src={result.image_url} alt={result.name} />
303 </div>
304 )}
371 <div className="result-header">
372 <div className="user-header">
373 {result.profile_image_url && (
374 <div className="user-avatar">
375 <img src={result.profile_image_url} alt={result.username || "User"} />
376 </div>
377 )}
1243 <a href="?q=api" className="example-link">api</a>
1244 <a href="?q=database" className="example-link">database</a>
1245 <a href="?q=image" className="example-link">image</a>
1246 <a href="?q=function" className="example-link">function</a>
1247 <a href="?q=discord" className="example-link">discord</a>
1308 <div className="contributor-header">
1309 <div className="contributor-avatar">
1310 {contributor.profile_image_url
1311 ? <img src={contributor.profile_image_url} alt={contributor.username} />
1312 : (
1313 <div
1356 rel="noopener noreferrer"
1357 >
1358 <div className="project-image">
1359 {project.image_url
1360 ? <img src={project.image_url} alt={project.name} />
1361 : (
1362 <div
1397 <a href="?q=api" className="example-link">api</a>
1398 <a href="?q=database" className="example-link">database</a>
1399 <a href="?q=image" className="example-link">image</a>
1400 <a href="?q=function" className="example-link">function</a>
1401 <a href="?q=discord" className="example-link">discord</a>
3This is a lightweight SQLite Admin interface to view and debug your SQLite data.
4
5
6
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.
12}) {
13 const description = post?.description ?? SITE_DESCRIPTION;
14 const ogImage = new URL("/og-image.png", BLOG_URL);
15 ogImage.searchParams.append("title", title);
16
17 return (
19 <meta charSet="UTF-8" />
20 <meta name="viewport" content="width=device-width, initial-scale=1.0" />
21 <link rel="icon" type="image/svg+xml" href="/favicon.svg" />
22
23 <title>{title === "Val Town Blog" ? title : `${title} | Val Town Blog`}</title>
33 <meta property="og:description" content={description} />
34
35 <meta property="og:image" content={ogImage} />
36
37 {/* Twitter */}
38 <meta property="twitter:card" content="summary_large_image" />
39 <meta property="twitter:url" content={BLOG_URL} />
40 <meta property="twitter:title" content={title} />
41 <meta property="twitter:description" content={description} />
42
43 <meta property="twitter:image" content={ogImage} />
44
45 {
150 title: "Kind of Blue",
151 year: 1959,
152 cover_image:
153 "https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-miles-davis-kind-of-blue",
154 artists: [{ name: "Miles Davis" }],
169 title: "Abbey Road",
170 year: 1969,
171 cover_image:
172 "https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-the-beatles-abbey-road",
173 artists: [{ name: "The Beatles" }],
188 title: "Thriller",
189 year: 1982,
190 cover_image:
191 "https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-michael-jackson-thriller",
192 artists: [{ name: "Michael Jackson" }],
523 <img
524 src={
525 record.basic_information.cover_image ||
526 "https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-placeholder"
527 }
694 <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
695 <meta name="description" content="Discover Ash's vinyl record collection at random. Powered by Collxn.">
696 <link rel="icon" type="image/svg+xml" href="/favicon.svg">
697 <link rel="canonical" href="https://www.collxn.com/" />
698 <!-- Open Graph -->
701 <meta property="og:title" content="Collxn Prototype: Ash's Random Vinyl Picker" />
702 <meta property="og:description" content="Discover Ash's vinyl record collection at random. Powered by Collxn." />
703 <meta property="og:image" content="https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-placeholder" />
704 <!-- Twitter Card -->
705 <meta name="twitter:card" content="summary_large_image" />
706 <meta property="twitter:domain" content="www.collxn.com" />
707 <meta property="twitter:url" content="https://www.collxn.com/" />
708 <meta name="twitter:title" content="Collxn Prototype: Ash's Random Vinyl Picker" />
709 <meta name="twitter:description" content="Discover Ash's vinyl record collection at random. Powered by Collxn." />
710 <meta name="twitter:image" content="https://maxm-imggenurl.web.val.run/vinyl-record-album-cover-placeholder" />
711 <!-- Structured Data -->
712 <script type="application/ld+json">
30 - **`proxy.ts`**: Proxy to the old blog for legacy content
31 - **`rss.ts`**: RSS feed generation
32 - **`favicon.ts`** & **`og-image.ts`**: Asset routes
33- **`/utils/`**: Utility functions for post processing, caching, etc.
34- **`/posts/`**: Markdown files for blog posts
69- Tables
70- Lists
71- Images
72- And other standard markdown features
73
91- Efficient proxy for legacy content
92- Minimal CSS with no external frameworks
93- Optimized image handling
94
95## Deployment
