carefree-ladka

SQL Complete Interview Preparation Guide 🎯

Master SQL with 150+ Problems, Solutions & Concepts

---

Table of Contents

1. SQL Basics & Fundamentals
2. SELECT Queries & Filtering
3. Aggregate Functions & GROUP BY

aleclarson

NOTICE: I've summarized the perspectives of Octane's and Solid's creators here, for anyone short on time: https://gist.github.com/aleclarson/829c10aa7d287944ef75e1c2a90bef06

---

I'm a React/Preact/Astro developer with an interest in other renderers. The two that have most caught my eye recently are Octane (from Dominic Gannaway of React Hooks / Svelte / Inferno fame) and Solid 2.

I asked ChatGPT to compare them with its own "Renderer DX Pillars", which I've shared below. This is its gut instinct, with very little hedging:

Pillar	Winner	Why

guilhermelaz

I want you to wire my n8n MCP into this coding agent, following this exact workflow.

1. First, ask me to paste the MCP JSON from my n8n instance at `/settings/mcp`.
2. If you do not already know which coding agent host/client this is from context, ask me that too in the same message. Examples: OpenCode CLI, Claude Desktop, Cursor, VS Code extension, Continue.
3. After I paste the JSON, inspect the existing local config and, if needed, the official config schema/docs for this coding agent before editing anything. Do not assume the n8n JSON shape matches this agent's config format. Translate it correctly into the host's config format.
4. Add the n8n MCP entry to the correct config file, but keep the bearer token as the literal placeholder `(leftanglebracket)YOUR_ACCESS_TOKEN_HERE(rightanglebracket)` instead of asking me to paste the real token into chat.
5. If you have file access, make the config change directly. If you do not, give me the exact minimal edit I need to make in the exact file path.
6. Verify th

iam-veeramalla

# Create EKS Cluster

eksctl create cluster --name=observability \
                      --region=us-east-1 \
                      --zones=us-east-1a,us-east-1b \
                      --without-nodegroup
                  
eksctl utils associate-iam-oidc-provider \
    --region us-east-1 \
    --cluster observability \

Prottoy2938

function makeId(length) {
  let result = "";
  const characters =
    "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
  const charactersLength = characters.length;
  for (let i = 0; i < length; i++) {
    result += characters.charAt(Math.floor(Math.random() * charactersLength));
  }
  return result;
}

ihoneymon

[공통] 마크다운 markdown 작성법

영어지만, 조금 더 상세하게 마크다운 사용법을 안내하고 있는
"Markdown Guide (https://www.markdownguide.org/)" 를 보시는 것을 추천합니다. ^^

아, 그리고 마크다운만으로 표현이 부족하다고 느끼신다면, HTML 태그를 활용하시는 것도 좋습니다.

1. 마크다운에 관하여

mathix420

// ==UserScript==
// @name        Freedium Article Redirect
// @namespace   Violentmonkey Scripts
// @run-at      document-start
// @match       *://medium.com/*
// @match       *://*.medium.com/*
// @match       *://nytimes.com/*
// @match       *://*.nytimes.com/*
// @match       *://washingtonpost.com/*
// @match       *://*.washingtonpost.com/*

shikhir-arora

FILE SPACING:

 # double space a file
 sed G

 # double space a file which already has blank lines in it. Output file
 # should contain no more than one blank line between lines of text.
 sed '/^$/d;G'

telnet2

#!/bin/bash
# Self-extracting byobu + tmux installer with OSC 52 clipboard support
# Usage: curl -sL <gist-raw-url> | bash
set -euo pipefail

BYOBU_CONFIG="$HOME/.byobu"

# --- Install byobu and tmux ---
if ! command -v byobu &>/dev/null || ! command -v tmux &>/dev/null; then
    echo "Installing byobu and tmux..."

gbitdev

#!/usr/bin/env bash
mkdir $HOME/.byobu/
cat > $HOME/.byobu/.tmux.conf <<EOF
set -g default-shell $(which fish)
set -g default-command $(which fish)
EOF