Alex Vishnya Sp1tF1r3

Before starting, make sure you have a backup, and make sure to have a linux live boot ready to rescue your system. It's easy to mess this up!

Use gdisk to convert the partition table to GPT.

gdisk /dev/sda
Create the "BIOS boot" partition that GRUB needs.

n to create a new partition. Needs to be about 1MB. You can probably squeeze this in from sectors 34-2047. Use L or l to look up the code for "BIOS boot" (ef02).
Write the new partition table.

w
Reload the partition table. > partprobe /dev/sda

Installing Postgres via Brew

In your command-line run the following commands:

To identify hung transactions:

show engine innodb status

	How to Use PlainTasks:

	Projects:
	☐ Anything with colon at the end of the line is a project title
	☐ You can nest projects inside each other
	☐ You can fold projects (a built-in editor feature)

	Tasks:
	You can write plain text as notes or descriptions wherever you want;
	it's totally fine!

	# -- coding:utf8 --
	import re

	from flask import Flask

	from flask_sqlalchemy import SQLAlchemy as BaseSQLAlchemy
	from flask_sqlalchemy import _SignallingSession as BaseSignallingSession
	from flask_sqlalchemy import orm, partial, get_state

	from datetime import datetime

	#!/usr/bin/env python
	#
	# ----------------------------------------------------------------------------
	# "THE BEER-WARE LICENSE" (Revision 42):
	# <[email protected]> wrote this file. As long as you retain this notice you
	# can do whatever you want with this stuff. If we meet some day, and you think
	# this stuff is worth it, you can buy me a beer in return.
	# ----------------------------------------------------------------------------
	#

	BEGIN;
	LOCK table_name;
	ALTER TABLE table_name ADD COLUMN column_new column_type;
	UPDATE table_name SET column_new = column_name;
	ALTER TABLE table_name DROP column_name;
	ALTER TABLE table_name RENAME column_new TO column_name;
	END;

	-- varchar -> integer
	-- UPDATE cpvbeacon_dev SET column_new = CAST (nullif(column_name, '') AS INTEGER);