andreoss

andreoss / rename_database.sql

Created January 23, 2025 15:52

MySQL. Rename the database, i.e. create a new database and move all tables and views to it.

	DELIMITER $

	DROP PROCEDURE IF EXISTS sys.rename_database;

	CREATE PROCEDURE sys.rename_database(IN old_schema VARCHAR(255), IN new_schema VARCHAR(255))
	BEGIN DECLARE done INT DEFAULT FALSE;

	DECLARE t VARCHAR(255);
	DECLARE v VARCHAR(255);
	DECLARE d TEXT;

andreoss / chromium.sh

Created May 20, 2025 14:40

	#!/usr/bin/env bash
	set -x

	PROFILES_ROOT="$HOME/.chromium-profile/"
	PROFILES_CACHE="$HOME/.chromium-cache/"

	PROFILE_NAME="${1:-}"
	shift