• Blog
  • Docs
  • Pricing
  • We’re hiring!
Log inSign up
sitnik

sitnik

trmnl-lastfm

Spotify public plugin for TRMNL
Public
Like
trmnl-lastfm
Home
Code
6
docs
1
frontend
9
routes
7
templates
4
utils
3
H
main.ts
Branches
1
Pull requests
Remixes
History
Environment variables
4
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
/
docs
/
dbqueries.md
Code
/
docs
/
dbqueries.md
Search
11/28/2025
dbqueries.md

Database Queries

Create Installations Database

Create val
app.get("/db/create", async (c) => { await sqlite.execute(`create table if not exists lastfm_installations ( uuid varchar(255) PRIMARY KEY not null, active boolean not null default 0, lastfm_connected boolean not null default 0, name varchar(255) null, first_name varchar(255) null, last_name varchar(255) null, email varchar(255) null, locale varchar(255) null, time_zone_iana varchar(255) null, plugin_setting_id INTEGER null, trmnl_access_token varchar(255) null, lastfm_session varchar(255) null, preferences text not null, uninstalled_at datetime null, created_at datetime not null default CURRENT_TIMESTAMP, updated_at datetime not null default CURRENT_TIMESTAMP )`); return c.text("ok"); });
FeaturesVersion controlCode intelligenceCLIMCP
Use cases
TeamsAI agentsSlackGTM
DocsShowcaseTemplatesNewestTrendingAPI examplesNPM packages
PricingNewsletterBlogAboutCareers
We’re hiring!
Brandhi@val.townStatus
X (Twitter)
Discord community
GitHub discussions
YouTube channel
Bluesky
Open Source Pledge
Terms of usePrivacy policyAbuse contact
© 2025 Val Town, Inc.