Justin Zobel Justinzobel

Level	Action	MySQL	PostgreSQL	SQLite
General	Exit	quit	\quit	.quit
Database	List Databases	show databases;	\l	.databases
Database	Create Database		CREATE DATABASE db_name;
Database	Connect to a Database	use db_name;	\c db_name
Table	List Tables	show tables;	\dt	.table
Table	Describe Table Columns	describe table_name;	\d table_name	.schema table_name
Processses	Show Process List	show processlist;
Read Data	Show All Data	select * from table_name;		select * from table_name;

Thunderbird 115 introduced a new look. I hate it. Not only does it no longer fit in with KDE Plasma, it lost functionality due to it's new integrated search bar in the title bar.

So I went on a mission to fix it.

To restore the regular title bar:

Go into Settings > General > Language & Appereance and uncheck the Hide system window titlebar

To remove search bar:

Discourse Maintenance Page with Apache2

As root

cd /var/discourse
nano containers/app.yml

Comment out these lines:

Matrix Synapse server error: Found users in database not native to my.domain!

Backup instance/database
Connect to your PostgreSQL database and remove users in the user_directory table that don't match your domain e.g: delete FROM user_directory WHERE user_id NOT LIKE '%chat.my.domain%';

token=123456789etc
curl -X POST "https://pagure.io/api/0/-/whoami" \
     -H "Authorization: token $TOKEN" \
     -H "Content-Type: application/x-www-form-urlencoded"

	window {
	background-color: #31363b;
	}

	#input {
	margin: 5px;
	border-radius: 0px;
	border: none;
	border-bottom: 3px;
	background-color: #31363b;

	alsa-lib-devel
	attr-devel
	audiofile-devel
	black-hole-solver-devel
	check-devel
	cmark-devel
	cups-devel
	cyrus-sasl-devel
	dbus-glib-devel
	dialog

	App: https://github.com/aristocratos/bashtop

	#Bashtop theme with nord palette (https://www.nordtheme.com)
	#by Justin Zobel <[email protected]>

	# Colors should be in 6 or 2 character hexadecimal or single spaced rgb decimal: "#RRGGBB", "#BW" or "0-255 0-255 0-255"
	# example for white: "#ffffff", "#ff" or "255 255 255".

	# All graphs and meters can be gradients
	# For single color graphs leave "mid" and "end" variable empty.

	MySQL command to get a list of all pages (decoded from binary) and show the date they were last modified (in YYYYMMDD etc)

	select cast(page_title as CHAR),cast(page_touched as CHAR) from page ORDER BY page_touched ASC;

	To get mediawiki page names from MySQL use:

	use db_name;
	select page_id,cast(page_title as CHAR) from page;