Authenticate with an email and password to receive a session_token.
The Session Token will be a top level key called token.
The Session Token token is used for all requests after authentication.
You also receive a user_id which is used in your apps and keys lookup.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ----------------------- SimpleAggregateFunction + groupArrayArray ---------------------------- | |
| drop table if exists states_raw; | |
| drop table if exists final_states_by_month; | |
| drop table if exists final_states_by_month_mv; | |
| CREATE TABLE states_raw(d date, uid UInt64, s String) ENGINE = Null; | |
| CREATE TABLE final_states_by_month(d date, uid UInt64, a_state SimpleAggregateFunction(groupArrayArray, Array(String))) | |
| ENGINE = AggregatingMergeTree PARTITION BY toYYYYMM(d) ORDER BY (uid); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // | |
| // ** ** | |
| // ** Add your API Key to MY SECRETS (Left Panel) ** | |
| // ** ** | |
| // ** HUGGINGFACE_API_KEY as the Secret Name ** | |
| // ** ** | |
| // | |
| let HUGGINGFACE_API_KEY = null; | |
| function getAPIKey() { | |
| // Use cached key |
Run OpenCode as a persistent background service, accessible from any device via Tailscale.
- Access from anywhere — Start a task from your phone, check results from your laptop
- Sessions persist — Close the browser, come back later, your session is still there
- Multiple clients — Terminal TUI and browser can connect to the same session simultaneously
- Survives crashes — systemd restarts the server automatically
| name | Logging Best Practices |
|---|---|
| description | Use before implementing logs in a medium to large scale production system. |
This skill is adpated from "Logging sucks. And here's how to make it better. by Boris Tane.
When helping with logging, observability, or debugging strategies, follow these principles:
OlderNewer