wint Wintus

Converting Range in Google Spreadsheet as Image using Google Apps Script

This is a sample script for converting a range in Google Spreadsheet as an image data using Google Apps Script. Unfortunately, there are no methods for directly converting the range in Google Spreadsheet as an image data in the built-in functions. So in this case, as a workaround, Charts Service is used.

Sample script

const range = "B5:D10";
const [header, ...values] = SpreadsheetApp.getActiveSheet()
 .getRange(range)

Elmロードマップ

(なんでロードマップが必要なのか書く)

Elm Guideをさらっと一周

Elm Guideをさらっと一周しましょう。

Elm Syntaxを読む

明日の下書き

これはなに

高円寺.dev #3 用の資料 https://koenji.connpass.com/event/160886/
フロントエンド専門じゃない人向けの、フロントエンドの最先端〜やや未来の話です
このレイヤーでは Node.js を使うべき/使うと強いという部分がありますが、他言語を否定しているわけではありません。むしろ他言語でこのアーキテクチャを模倣してほしいという話です。

Permanent WSL DNS Fix (WSL 2.2.1+)

If you're encountering ping github.com failing inside WSL with a Temporary failure in name resolution, you're not alone — this has been a long-standing issue, especially when using VPNs or corporate networks.

This issue is now fixed robustly with DNS tunneling, which preserves dynamic DNS behavior and avoids limitations like WSL’s former hard cap of 3 DNS servers in /etc/resolv.conf.

DNS tunneling is enabled by default in WSL version 2.2.1 and later, meaning that if you're still seeing DNS resolution issues, the first and most effective fix is simply to upgrade WSL. Upgrading WSL updates the WSL platform itself, but does not affect your installed Linux distributions, apps, or files.

To upgrade WSL, follow these steps,

Twitter Undocumented Bookmark API (DEPRECATED)

Update: 2022-03-25

Twitter has released the official API v2 endpoint for the bookmark feature. https://twittercommunity.com/t/build-with-bookmarks-on-the-twitter-api-v2/168804/

The following descriptions are or will soon be no longer useful; I suggest using the new official API.

58 bytes of CSS to look great nearly everywhere

When making this website, i wanted a simple, reasonable way to make it look good on most displays. Not counting any minimization techniques, the following 58 bytes worked well for me:

main {
  max-width: 38rem;
  padding: 2rem;
  margin: auto;
}

	# frozen_string_literal: true

	require "mysql2"

	def client
	Mysql2::Client.new(
	host: "localhost",
	username: "root",
	database: "test",
	)

	module.exports = {
	env: {
	browser: true,
	es2021: true,
	},
	extends: "eslint:recommended",
	overrides: [
	{
	globals: {
	module: true,

	/**
	* Convert between Uint8Array and Base64 strings
	* Allows for any encoded JS string to be converted (as opposed to atob()/btoa() which only supports latin1)
	*
	* Original implementation by madmurphy on MDN
	* @see https://developer.mozilla.org/en-US/docs/Web/API/WindowBase64/Base64_encoding_and_decoding#Solution_1_–_JavaScript%27s_UTF-16_%3E_base64
	*/

	function b64ToUint6(nChr) {
	return nChr > 64 && nChr < 91

	@startuml
	UA -> App: /login
	UA <-- App: Redirect
	UA -> 認可サーバー: /auhorize
	UA <- 認可サーバー: ログインページ表示
	UA -> 認可サーバー: ログイン
	UA <- 認可サーバー: 認可（AppにXXXを許可しますか？
	UA -> 認可サーバー: OK
	UA <-- 認可サーバー: Redierct
	UA -> App: /callback?code=xxx&state=xxx