hyunbinseo

import { getTableColumns, type Table } from 'drizzle-orm';
import { integer, sqliteTable } from 'drizzle-orm/sqlite-core';
import { db } from './client.js';

export const pickTableColumns = <
  T extends Table, //
  const ColumnName extends keyof T['_']['columns']
>(
  table: T,
  columnNames: ColumnName[]

hyunbinseo

• Single-line item
• Multi-line item
  Multi-line item
  Multi-line item
• This item is still clickable

hyunbinseo

Demo available on the SvelteLab REPL

hyunbinseo

PowerShell must be used. Windows Terminal is advised.

winget install Schniz.fnm

Create a PowerShell profile if it does not exist. Reference

if (!(Test-Path -Path $PROFILE)) {

hyunbinseo

<!-- https://d3js.org/getting-started#d3-in-vanilla-html -->

<script lang="ts">
  import * as d3 from 'd3';
  import type { Action } from 'svelte/action';

  const width = 640;
  const height = 400;
  const marginTop = 20;
  const marginRight = 20;

hyunbinseo

cd /etc/ssh

sudo nano sshd_config
# PasswordAuthentication no
# Remove the leading pound sign

cd sshd_config.d
ls # 50-cloud-init.conf

sudo nano 50-cloud-init.conf

hyunbinseo

hyunbinseo

<script>
  $: if (browser && data) {
    chart.ref?.updateSeries(data.series);
  }
</script>

<p>Hello, World</p>

hyunbinseo

// Create .env file and add secret values.
// Run with node --env-file=.env index.mjs
// Requires Node.js 20+ (LTS as of 2023-10-24)

const {
	NHN_SMS_APP_KEY,
	NHN_SMS_SECRET,
	NHN_SMS_SEND_NO,
	SEND_TO,
	TWILIO_ACCOUNT_SID,

hyunbinseo

import { asc, eq, gte, lte } from 'drizzle-orm';
import { drizzle } from 'drizzle-orm/mysql2';
import { createPool } from 'mysql2';
import * as schema from './schema';
import { comments, users } from './schema';

const connection = createPool({
	host: '...',
	user: '...',
	password: '...',