Inom Turdikulov iturdikulov

Adding the account

If you understand all of this and still wish to use it, see HowtoPurple and add the account like this in &bitlbee:

account add irc nickname@irc.example.net

Joining channels

Do this in &bitlbee:

chat add irc #channel Then /join #channel

Doom Emacs Workflow

Here I collect, various EMACS/evil/org… tips, shortcuts, keybindings, etc. Also, here some information how I handle daily usage of text editing.

This not absolute beginner cheat sheet, just some short basic commands/tips.

Recommendation - just use it & check it every day (training mode).

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the 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.

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

DQL is short name of Data Query Language which used for performing queries on the data within schema objects. The purpose of the DQL Command is to get some schema relation based on the query passed to it. SELECT statement is used to retrieve data from the database.

PureRef nixpkg

This is a hacky appimage wrapper nixpkg for PureRef to integrate it into NixOS better. As you may know, it's donationware, so the author encourages a donation and this means there's no way around manually downloading the program. So as a prerequisite, you need to download PureRef separately and slap it in the same folder as the Nix file, or alternatively, change the path to an absolute one, e.g.

src = /home/you/Downloads/PureRef-1.11.1_x64.Appimage;

Ideally this would use the actual Nixpkg appimage build tooling... but that's effort, and I just want to get shit done right now and this works fine.

	from functools import partial
	from urllib.parse import (
	quote,
	urlencode,
	)

	from PyQt5.QtNetwork import QNetworkRequest

	from picard import config, log
	from picard.metadata import register_track_metadata_processor

	{ pkgs, lib, ... }:

	{
	# https://devenv.sh/packages/
	packages = [
	pkgs.glib
	pkgs.glibc
	];

	languages.python.enable = true;

	--[[
	blogpost:
	https://vonheikemen.github.io/devlog/tools/setup-nvim-lspconfig-plus-nvim-cmp/

	Dependencies:
	LSP:
	https://github.com/neovim/nvim-lspconfig
	https://github.com/williamboman/mason.nvim (optional)
	https://github.com/williamboman/mason-lspconfig.nvim (optional)

	#!/usr/bin/env -S bash -c 'nix-shell --pure $0 -A env'

	# Usage:
	# 1. run directly to enter bash (inside venv): `./venv-py37.nix`
	# 2. build a standalone executable: `nix bundle -f ./venv-py37.nix` #this not works yet since it cause nested `unshare -U` call
	# 3. run bash with extra arguments: `nix run -f ./venv-py37.nix '' -- -c 'python --version'`
	# More:
	# 1. commit id of nixpkgs can be found here: https://lazamar.co.uk/nix-versions/?channel=nixpkgs-unstable&package=python3

	let

	#!/usr/bin/env ipython -i
	import datetime
	import json
	from typing import Optional

	import sqlalchemy as sa
	from sqlalchemy.orm import declarative_base, sessionmaker
	from sqlalchemy.dialects.postgresql import JSONB

	from pydantic import BaseModel, Field, parse_obj_as