Movatterモバイル変換


[0]ホーム

URL:


Skip to content
Search Gists
Sign in Sign up

Instantly share code, notes, and snippets.

Discover gists

@janikvonrotz
janikvonrotz /SQL Cheat Sheet.md
Last activeJuly 18, 2025 21:00
SQL Cheat Sheet#SQL#Markdown

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

Datatypes

Text types

@aamiaa
aamiaa /CompleteDiscordQuest.md
Last activeJuly 18, 2025 20:59
Complete Recent Discord Quest

Note

This does not works in browser for non-video, non-activity quests! For stream/play quests use the desktop app!

Note

When doing stream quests, you need at least 1 other account in the vc!

How to use this script:

  1. Accept a quest under Discover -> Quests
@plembo
plembo /addbr0ubunmcli.md
Last activeJuly 18, 2025 20:56
Add br0 to Ubuntu desktop using nmcli

Had to do this for some advanced networking with KVM, and couldn't figure out how to do it using the Nework Manager gui.Did find an article later that showed how to do it with nmtui, but it's so much easier to record what you did when usingthe cli.

In the examples below "eth0" is the name of my physical interface. By default on Ubuntu and most distributions that will almost certainly be different, for example: "eno1", "ens1", or "enp2s0".

To see what everything looks like before starting:

@strobelt
strobelt /install_neovim.sh
Last activeJuly 18, 2025 20:56
Install latest NeoVim in Debian
# Download latest neovim release from GitHub releases and pipe it to tar to extract it to /usr
curl -sL https://github.com/neovim/neovim/releases/latest/download/nvim-linux-x86_64.tar.gz \
| sudo tar -xzf - --strip-components=1 --overwrite -C /usr
@liuran001
liuran001 /config.yaml
Last activeJuly 18, 2025 20:56
mihomo (Clash Meta) 懒人配置
# AFF
# 如果你想支持我,可以通过我的邀请链接购买机场
# 感谢支持
# 1. 倾城极速 邀请码: 0jiB5uAA https://qcjs.ovh/#/register?code=0jiB5uAA
# 2. superbiu 邀请码: fACfjKC8 https://superbiu.com/#/register?code=fACfjKC8
# 一定要填我的邀请码,不填我哭给你看😭
# mihomo (Clash Meta) 懒人配置
# 版本 V1.22-250718
# https://gist.github.com/liuran001/5ca84f7def53c70b554d3f765ff86a33
@sergeyk
sergeyk /explore-plan-code-test.md
Last activeJuly 18, 2025 20:54
Explore - Plan - Code - Test Workflow

At the end of this message, I will ask you to do something.Please follow the "Explore, Plan, Code, Test" workflow when you start.

First, use parallel subagents to find and read all files that may be useful for implementing the ticket, either as examples or as edit targets. The subagents should return relevant file paths, and any other info that may be useful.

Plan

Next, think hard and write up a detailed implementation plan. Don't forget to include tests, lookbook components, and documentation. Use your judgement as to what is necessary, given the standards of this repo.

If there are things you are not sure about, use parallel subagents to do some web research. They should only return useful information, no noise.


[8]ページ先頭

©2009-2025 Movatter.jp