Shahab Movahhedi movahhedi

How to upgrade MySQL to MariaDB in XAMPP in 5 minutes on Windows

Here are the steps I used to to upgrad MySQL to MariaDB in XAMPP on Windows in about 5 minutes. After completing this process, MariaDB will look and work just like MySQL. You may even notice a performance increase in your website. No need to panic fellow developer, increased performance is perfectly normal and just one of the great benefits of MariaDB over MySQL.

IMPORTANT: Before you begin, always be sure to make a good backup. Do not do move instead of copy files in the instructions below as the original files may be required in order to back out and restore the original MySQL environment if it doesn't work out for you.

Open a command prompt.
Go to your xampp folder.
Enter the following command: mysql/bin/mysql --version
Take note of the version of MySQL you have installed. This is the version of MariaDB that you will need. You can now exit the command prompt as the rest of the instructions can be done through Windows Explorer

https://coshacks.blogspot.com/2021/05/matrix-tips-they-dont-tell-you.html

This is a random combination of FAQ and guides about Matrix. Mostly for my own notes but these might be useful for others.

FAQ

1. Why is this in blogger.com? This is ugly

Yes. Going to move it somewhere on fediverse soon.

It's 2024. You should use tsup instead of this.

Features

🔥 Blazing fast builds
😇 CommonJS bundle
🌲 .mjs bundle
✨ .d.ts bundle + type-checking

Micro Editor

https://github.com/zyedidia/micro/blob/master/runtime/help/defaultkeys.md https://github.com/zyedidia/micro/blob/master/runtime/help/commands.md https://github.com/zyedidia/micro/blob/master/runtime/help/keybindings.md

Commands

Ctrl+E to open command panel

Handy Trick To Get Rid Of node_modules

This one is a simple and handy trick when you want to copy your directories without node_modules folder.

Enter this command in your terminal.

robocopy SOURCE DEST /mir /xd node_modules

	// Types for the result object with discriminated union
	type Success<T> = {
	data: T;
	error: null;
	};

	type Failure<E> = {
	data: null;
	error: E;
	};

	#!/bin/bash
	sudo certbot \
	certonly \
	--server https://acme-v02.api.letsencrypt.org/directory \
	--manual \
	--agree-tos \
	--preferred-challenges dns \
	--register-unsafely-without-email \
	-d *.domain. # Wildcard - could be regular and one can also specify multiple -d options to include in the certificate

	<?php

	/**
	* @author Shahab Movahhedi <[email protected]>
	* @copyright © 2022 Shahab Movahhedi. All rights reserved.
	* @link http://sms.ir/ Documentation of sms.ir RESTful API PHP sample.
	* @version 1.2
	*/

	class SmsIr {

	/**
	* Resizes an Image File and converts it to a dataurl string.
	* @param imageFile the image file (probably from a file input)
	* @param resize_width The width you want the image to be
	* @param quality quality of the resize image 0 - 1
	*/
	const resizeImage = ({
	resizeWidth = 400,
	imageFile,
	quality = 1,

	#!/usr/bin/env bash
	# used to install offical chrome and selenium on Ubuntu 16.04.1 LTS, 18.04, 20.04.1 LTS desktop, Jan 2021
	# also tested and works on Elem OS 5.1 :)
	#
	# make sure script is run as root or sudo
	if [[ $(whoami) != "root" ]] ; then
	echo ; echo "This script, $0, SHOULD be run as ROOT. " ; echo
	exit 1
	fi
	#