Viktor Ghorbali Gictorbit

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE <table_name> DROP CONSTRAINT <table_name>_pkey;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE <table_name> RENAME COLUMN <primary_key_candidate> TO id;

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`

Image source

https://gyazo.com/eb5c5741b6a9a16c692170a41a49c858.png

Try resize it!

![](https://gyazo.com/eb5c5741b6a9a16c692170a41a49c858.png | width=100)

Install Ubuntu containers on Archlinux using LXC

Install the lxc and the debootstrap packages:

# pacman -Sy lxc debootstrap

Install an Ubuntu container

I will install Ubuntu 16. Therfore, I will use the xenial release.

Code is clean if it can be understood easily – by everyone on the team. Clean code can be read and enhanced by a developer other than its original author. With understandability comes readability, changeability, extensibility and maintainability.

General rules

Follow standard conventions.
Keep it simple stupid. Simpler is always better. Reduce complexity as much as possible.
Boy scout rule. Leave the campground cleaner than you found it.
Always find root cause. Always look for the root cause of a problem.

Design rules

How to flash MIUI Fastboot ROM from Linux

Download the fastboot ROM suitable for your device from the MIUI site and extract the downloaded archive [edit: MIUI page is dead. Use Xiaomi Firmware Updater]
Download and extract the Android SDK Platform Tools
Make sure adb and fastboot (components of platform-tools) are in your

Arch Linux GPU-Passthrough

A quick guide on how to setup a GPU-Passthorugh. Below are some of my Resources

The Arch Wiki is the goto place for additional information and performance tweaks like CPU-Pinning.

Requirements

IGPU or second dedicated GPU for Host system (unless you want to go the hard way and use one GPU for HOST and GUEST)

	package main

	import (
	"container/ring"
	"fmt"
	"time"
	)

	func main() {
	coffee := []string{"kenya", "guatemala", "ethiopia"}

	#!/usr/bin/env python
	#
	# AccessDump.py
	# A simple script to dump the contents of a Microsoft Access Database.
	# It depends upon the mdbtools suite:
	# http://sourceforge.net/projects/mdbtools/

	import sys, subprocess, os

	DATABASE = sys.argv[1]

	[Desktop Entry]
	Version=1.0
	Name=Telegram Desktop
	Comment=Official desktop version of Telegram messaging app
	TryExec=/opt/Telegram/Telegram
	Exec=/opt/Telegram/Telegram -- %u
	Icon=telegram
	Terminal=false
	StartupWMClass=TelegramDesktop
	Type=Application