Skip to content

Instantly share code, notes, and snippets.

@kaznak
kaznak / proof.md
Created March 11, 2025 18:00
proof for keyoxide

aspe:keyoxide.org:ZLCJ7BY6TD35GMP5SGWDYYTHVY

@kaznak
kaznak / agent loop
Created March 10, 2025 05:39 — forked from jlia0/agent loop
Manus tools and prompts
You are Manus, an AI agent created by the Manus team.
You excel at the following tasks:
1. Information gathering, fact-checking, and documentation
2. Data processing, analysis, and visualization
3. Writing multi-chapter articles and in-depth research reports
4. Creating websites, applications, and tools
5. Using programming to solve various problems beyond development
6. Various tasks that can be accomplished using computers and the internet
@kaznak
kaznak / install-home-manager.sh
Last active March 10, 2025 02:06
Install home-manager into userland
#!/usr/bin/env bash
set -vxe
source /etc/os-release
nix-channel --remove home-manager
nix-channel --add https://github.com/nix-community/home-manager/archive/release-${VERSION_ID}.tar.gz home-manager
nix-channel --update
@kaznak
kaznak / dump_context_values.yaml
Last active July 4, 2024 01:30
A reusable workflow that dumps context values
name: Dump Context Values
on:
workflow_dispatch:
workflow_call:
jobs:
dump_contexts:
name: Dump Context Values
runs-on: ubuntu-22.04
@kaznak
kaznak / envVars.tsx
Last active June 27, 2024 05:38
Remix で GA4 の Tracking ID をセットする時に使うコンポーネントの案
/**
* Loaders does not work, if some errors occurred.
* Thus the critical values are passed by in script element.
*/
export type Env = Partial<typeof process.env>;
declare global {
interface Window {
env: Env;
@kaznak
kaznak / 0_prepare.sql
Last active May 30, 2024 04:40
PostgreSQL 16 上での履歴テーブルの実装(not null バージョン)
-- Extension: btree_gist
-- DROP EXTENSION btree_gist;
CREATE EXTENSION IF NOT EXISTS btree_gist
SCHEMA public
VERSION "1.7";
-----------------------------------------------------------------------------------
@kaznak
kaznak / 0_install_extensions.sql
Last active July 21, 2024 06:48
PostgreSQL 16 上での履歴テーブルの実装
-- Extension: btree_gist
-- DROP EXTENSION btree_gist;
CREATE EXTENSION IF NOT EXISTS btree_gist
SCHEMA public
VERSION "1.7";
@kaznak
kaznak / postgres-cheatsheet.md
Created May 23, 2024 23:26 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
title: OpenAPI Document tools
tools:
- name: OpenAPI-Specification
official: https://www.openapis.org/
source: https://github.com/OAI/OpenAPI-Specification
tag:
- document
openapi-versions:
stable:
@kaznak
kaznak / distributed_service_catalog.md
Created October 1, 2023 23:36 — forked from nagiept/distributed_service_catalog.md
Distributed Service Catalog 2018

Distributed Service Catalog 2018

分散SNS Advent Calendar 2018 Fediverseとその他の分散サービスの歴史とプロジェクトを適当に書いておくだけの記事

Progects list

Laconica

ジャンル マイクロブログ
読み ラコニカ(?)
開発者 Evan Prodromou(Control Yourself社)
言語 PHP