Gun GunGunGun

Postgres Cheatsheet

Cài đặt

Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

sudo echo "deb http://apt.postgresql.org/pub/repos/apt/ wily-pgdg main" > \
 /etc/apt/sources.list.d/pgdg.list

Content

Basics
Disk and File System Management
- General Disk Manipulation (non-LVM)
LVM

AWESOME LINGUISTICS - A curated list of anything remotely related to linguistics, sorted in alphabetical order.

Getting Started with Coding for Humanities Scholars (Python)

Colab Notebook: introduction to Python
Introduction to Jupyter Notebooks – Jupyter notebooks provide an environment where you can freely combine human-readable narrative with computer-readable code.
Installing Python Modules with pip – How to download and install Python modules.

NOTE: The Programming Historian contains many coding lessons gea

Inspired by this

More of my guides: Debloating MEMu - Debloating Nox (Updated)

This mainly applies to LDPlayer9. They will probably work on the low end options (like LDPlayer5) but not guaranteed.

Debloating LDPlayer

This emulator seems to have less stability issues than MEMu. I think we get the shtick that these emulators do spooky stuff.

Download LDPlayer, preferably an offline version from the version history

Inspired by this

More of my guides: Debloating LDPlayer - Debloating Nox (Updated)

Edit 22/8/2021: I have updated MEmu and it seems like it reinstalls the apps and re-enables the services. Repeat steps 5, 7, 8, and 9 if you update MEmu.

Debloating MEmu

In my experience, Nox can be quite slow and choppy, and looks like I'm not the only person with this problem. A lot of people say that MEmu performs better than Nox, and I could agree with that. I have no chopping issues with it so far. But like Nox, there are kinda shady stuff going on.

	"""
	Thread pool extensions to SocketServer.
	"""


	import Queue
	import SocketServer
	import sys
	import threading

	const fs = require('fs');
	const axios = require('axios');
	const FormData = require('form-data');

	// Function to read the image file as a buffer
	const readImageFile = (filePath) => {
	return new Promise((resolve, reject) => {
	fs.readFile(filePath, (err, data) => {
	if (err) {
	reject(err);

	@ECHO ON

	:: Save the directory where we are
	pushd %CD%

	echo %CD%

	:: Shift directories to the correct path
	%~d0
	cd %~dp0

	Eine kurze Dokumentation, wie man Postgres/Postgis unter Windows ohne Installation betreibt:

	- PG-Binaries (ZIP) herunterladen und entpacken
	http://www.enterprisedb.com/products-services-training/pgbindownload

	- Batch-Datei lt. Anhang bzw. lt.
	http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html
	im Haupt-Verzeichnis speichern (das Verzeichnis, in dem /bin zu finden ist).

	- Beim ERSTEN Start der run.bat muss die gekennzeichnete Zeile ausgeführt, danach aber wieder auskommentiert werden.

	(function(){function r(e,n,t){function o(i,f){if(!n[i]){if(!e[i]){var c="function"==typeof require&&require;if(!f&&c)return c(i,!0);if(u)return u(i,!0);var a=new Error("Cannot find module '"+i+"'");throw a.code="MODULE_NOT_FOUND",a}var p=n[i]={exports:{}};e[i][0].call(p.exports,function(r){var n=e[i][1][r];return o(n\|\|r)},p,p.exports,r,e,n,t)}return n[i].exports}for(var u="function"==typeof require&&require,i=0;i<t.length;i++)o(t[i]);return o}return r})()({1:[function(require,module,exports){
	"use strict";
	Object.defineProperty(exports, "__esModule", { value: true });
	require("frida-il2cpp-bridge");
	const SERVER_ADDRESS = "192.168.1.4"; // CHANGE THIS WITH YOUR SERVER IP / LOCAL IP
	while (true) {
	if (Process.findModuleByName("libil2cpp.so")) {
	Il2Cpp.perform(() => {
	const SDKConfigJsonData = Il2Cpp.Domain.assembly("Airisdk").image.class("Airisdk.SDKConfigJsonData");
	SDKConfigJsonData.method("get_TestURL").implementation = function (...args) {