thiamteck’s gists

thiamteck / centos-stream-8-vault-repos.sh

Created July 9, 2024 09:36 — forked from AlexBaranowski/centos-stream-8-vault-repos.sh

Replace CentOS Stream 8 repos with CentOS Stream 8 VAULT repos

	cat > /etc/yum.repos.d/CentOS-Stream-AppStream.repo << EOF
	# CentOS-Stream-AppStream.repo
	#
	# The mirrorlist system uses the connecting IP address of the client and the
	# update status of each mirror to pick current mirrors that are geographically
	# close to the client. You should use this for CentOS updates unless you are
	# manually picking other mirrors.
	#
	# If the mirrorlist does not work for you, you can try the commented out
	# baseurl line instead.

thiamteck / sliding-windows-label-by-hour.sql

Created May 23, 2024 04:28

	SELECT
	tm AS transaction_timestamp,
	-- Calculate the window label
	DATE_FORMAT(
	DATE_ADD(tm, INTERVAL ((60 - MINUTE(NOW()))*60)-1 SECOND),
	CONCAT('%Y-%m-%d %H:', MINUTE(NOW()))
	) AS window_label
	FROM
	subscriber_history_tracking
	WHERE

thiamteck / DML_partition.sql

Created August 9, 2021 13:32

Create MySQL table partition by month

	-- a table to be partition by column 'created_at'
	-- make sure all primary key and unique key of table contains column used for partition
	CREATE TABLE `table_to_be_partitioned` (
	`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
	`col_a` VARCHAR(255) DEFAULT NULL,
	`cal_b` VARCHAR(255) DEFAULT NULL,
	`created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP(),
	`updated_at` DATETIME DEFAULT NULL,
	PRIMARY KEY (`created_at`,`id`),
	KEY `id` (`id`)

thiamteck / AesStringEncryptor.java

Last active October 14, 2024 13:27

OpenSSL equivalent for AES encryption with and without PBKDF2 and key-obtention iteration (-iter)

	import java.nio.charset.StandardCharsets;
	import java.security.InvalidAlgorithmParameterException;
	import java.security.InvalidKeyException;
	import java.security.MessageDigest;
	import java.security.NoSuchAlgorithmException;
	import java.security.SecureRandom;
	import java.security.spec.InvalidKeySpecException;
	import java.util.Arrays;
	import java.util.Base64;

thiamteck / SciTEUser.properties

Created August 11, 2020 05:58

	#
	# Based on custom settings by Bruce Dodson, http://gisdeveloper.tripod.com/scite.html
	# Does not support `start.in.monospaced.mode`, but invert the font setting among monospace and non-monospace font in order to start SciTE with monospace font
	#

	tabbar.hide.one=1
	tabbar.multiline=1
	toolbar.visible=1
	statusbar.visible=1

thiamteck / mysql_old_school_user_creation.sql

Created November 16, 2019 15:49

	CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
	CREATE USER 'username'@'%' IDENTIFIED BY 'password';

	GRANT ALL PRIVILEGES ON . TO 'username'@'localhost';
	GRANT ALL PRIVILEGES ON . TO 'username'@'%';

	FLUSH PRIVILEGES;

thiamteck / range_overlap_check.html

Last active November 22, 2018 02:04

Check if number range is overlapping. JS Bin// source https://jsbin.com/poyacef

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width">
	<title>JS Bin</title>
	</head>
	<body>

	<script id="jsbin-javascript">

thiamteck / random_datetime_between.sql

Created November 19, 2018 11:50

MySQL function for get random datetime in between 2 given datetime. Copy from : https://stackoverflow.com/a/49727273

	DELIMITER $$

	DROP FUNCTION IF EXISTS `random_datetime_between`$$

	CREATE FUNCTION `random_datetime_between`(date_from DATETIME, date_to DATETIME) RETURNS DATETIME
	BEGIN
	/**
	* reference: https://stackoverflow.com/a/49727273
	*/
	DECLARE result DATETIME;

thiamteck / server.py

Created June 26, 2018 17:04

server.py from deoplete-jedi

	"""Jedi mini server for deoplete-jedi

	This script allows Jedi to run using the Python interpreter that is found in
	the user's environment instead of the one Neovim is using.

	Jedi seems to accumulate latency with each completion. To deal with this, the
	server is restarted after 50 completions. This threshold is relatively high
	considering that deoplete-jedi caches completion results. These combined
	should make deoplete-jedi's completions pretty fast and responsive.
	"""

thiamteck / svn_gitignore.sh

Created December 18, 2017 02:16

read .gitignore file and ignore the entries via svn:ignore

svn propset svn:ignore -RF .gitignore .

Thiam Teck thiamteck