rosswd

How to run Lego Star Wars: The Complete Saga in Windowed Borderless mode

Download DxWnd and unpack the folder. 7zip can unpack .rar files
Open dxwnd.exe
Go to Edit > Add and browse to the game executable
Select Run in Window and Fullscreen to run the game in borderless windowed
Under Position make the following changes:
- X: 0, Y: 0, W: 1920, H: 1080 (for HD Resolution)
- Select Desktop
On the Video tab, for Screen Resolution ensure 'Native' is selected
Press OK to exit

How to stop Steam Big Picture opening when you press the guide button on your XBox Controller

Scenario: You have an XBOX One Controller, or similar, and to turn off the controller you press and hold the guide button. Unfortunately, even though you have turned off guide button focuses steam in Steam's Controller Settings, the button press still opens Big Picture Mode.

Guide

With your controller on, open Controller Settings: Steam > Settings > Controller > General Controller Settings
Using the controller, highlight Xbox One Controller or similar, navigate to Define Layout and press A on the controller

The next step involves remapping the Guide Button to another button and then reassigning that button back to the original. This will leave the guide button unassigned so that the controller can be turned off without Steam getting involved.

Gmail Search

is:unread
is:starred
from:apple subject:invoice
from:youtube is:unread
has:youtube
has:attachment
subject:order details
subject:(order statement refund)

Learning Relational Database Design and SQL

Learn SQL (interactive)

Drawing Tablet Software

Software for drawing using graphics tablets like wacom or using a tablet like an iPad.

Software List

Title	Platforms	Pricing
Medibang Paint / Paint Pro	Windows, Mac OS, iOS, Android	Adware, no paid version
Paint Tool SAI	Windows	$51
ArtRage	Windows, Mac OS, Android, iOS	$79 + tax

	# Raspberry Pi OS Information

	# show raspian information
	cat /etc/os-release

	# show architecture information
	uname -m
	arch
	getconf LONG_BIT

	MSI MAG274QRF-QD Color Settings

	Firmware version: FW.019
	It should be noted, at time of this gist, MSI have moved to naming their firmware by date. FW.020 bricked some monitors and no firmware was available for a time.

	Game Mode: User
	Night Vision: Off
	Response Time: Fast
	MPRT: Off
	Refresh Rate: Off

	# raspberry pi locales

	#
	# dynamically set locales
	#

	# check current locale settings
	locale

	# reconfigure locale settings (option 1)

	# ssh on raspberry pi

	# in these examples I use 192.168.1.10 as an example ip address for the raspberry pi

	# enable ssh either using raspi-config or by placing a file named 'ssh' in the boot partition

	# connect from a client
	ssh [email protected]

	# set up passwordless access

	'''
	Uses the pandas and wikipedia libraries to create a json file from a wikipedia table

	table: https://en.wikipedia.org/wiki/List_of_first-person_shooters
	'''
	import pandas as pd
	import wikipedia as wp

	html = wp.page('List_of_first-person_shooters').html().encode("UTF-8")
	df = pd.read_html(html)[1]