Discover gists

Migrating a Rails project from MySQL to PostgreSQL

This brief guide is written from my own experience with migrating a large (~5GB) MySQL database to PostgreSQL for a Rails project.

No warranties, guarantees, support etc. Use at your own risk and, as always, ENSURE YOU MAKE BACKUPS FIRST!

I chose [pgloader][1] because it's extremely fast. YMMV.

Replace mysql2 gem with pg in Gemfile.
Update config/database.yml for PostgreSQL. I used [Rails' template][2] as a starting point.

Here is the best setup (I think so :D) for K-series Keychron keyboards on Linux.

Note: many newer Keychron keyboards use QMK as firmware and most tips here do not apply to them. Maybe the ones related to Bluetooth can be useful, but everything related to Apple's keyboard module (hid_apple) on Linux, won't work. As far as I know, all QMK-based boards use the hid_generic module instead. Examples of QMK-based boards are: Q, Q-Pro, V, K-Pro, etc.

Most of these commands have been tested on Ubuntu 20.04 and should also work on most Debian-based distributions. If a command happens not to work for you, take a look in the comment section.

Make Fn + F-keys work (NOT FOR QMK-BASED BOARDS)

Older Keychron keyboards (those not based on QMK) use the hid_apple driver on Linux, even in the Windows/Android mode, both in Bluetooth and Wired modes.

🤗Huggingface Model Downloader

Considering the lack of multi-threaded download support in the official huggingface-cli, and the inadequate error handling in hf_transfer, this command-line tool smartly utilizes wget or aria2 for LFS files and git clone for the rest.

Features

⏯️ Resume from breakpoint: You can re-run it or Ctrl+C anytime.
🚀 Multi-threaded Download: Utilize multiple threads to speed up the download process.
🚫 File Exclusion: Use --exclude or --include to skip or specify files, save time for models with duplicate formats (e.g., *.bin or *.safetensors).
🔐 Auth Support: For gated models that require Huggingface login, use --hf_username and --hf_token to authenticate.
🪞 Mirror Site Support: Set up with HF_ENDPOINT environment variable.

	# This script will manually rip out all VMware Tools registry entries and files for Windows 2008-2019
	# Tested for 2019, 2016, and probably works on 2012 R2 after the 2016 fixes.

	# This function pulls out the common ID used for most of the VMware registry entries along with the ID
	# associated with the MSI for VMware Tools.
	function Get-VMwareToolsInstallerID {
	foreach ($item in $(Get-ChildItem Registry::HKEY_CLASSES_ROOT\Installer\Products)) {
	If ($item.GetValue('ProductName') -eq 'VMware Tools') {
	return @{
	reg_id = $item.PSChildName;

	/**
	* A PWM example for the ATmega328P using the 8-Bit Fast PWM mode.
	*/
	#include <avr/io.h>
	#include <avr/interrupt.h>
	#include <stdbool.h>
	#include <util/delay.h>

	int main (void) {

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Delete Boxes</title>
	<style>.box { width:100px; height:100px; background-color:lightblue; margin:10px; display:inline-block; text-align:center; line-height:100px; }</style>
	</head>
	<body>
	<select id="boxSelect"></select>

	/*******************************************************************************************
	* Welcome to RLAssets!*
	* RLAssets is licensed under an unmodified zlib/libpng license (View raylib.h for details)
	*
	* Copyright (c) 2020 Jeffery Myers
	*
	********************************************************************************************/

	#include "RLAssets.h"
	#include "raylib.h"

	## Pre-requisite: You have to know your last commit message from your deleted branch.
	git reflog
	# Search for message in the list
	# a901eda HEAD@{18}: commit: <last commit message>

	# Now you have two options, either checkout revision or HEAD
	git checkout a901eda
	# Or
	git checkout HEAD@{18}