Ilya Tsyganov ilya2049

Golang developer

aprossi / jupyterlab-docker.md

Last active September 26, 2021 07:16

Run Jupyterlab on docker

Build starting from a Jupyter 2.x image.

docker build -t jupyterlab .

jim3ma / makecert.sh

Last active August 22, 2025 09:42 — forked from spikebike/client.go

Golang TLS server and client

	#!/bin/bash
	# call this script with an email address (valid or not).
	# like:
	# ./makecert.sh [email protected]
	mkdir certs
	rm certs/*
	echo "make server cert"
	openssl req -new -nodes -x509 -out certs/server.pem -keyout certs/server.key -days 3650 -subj "/C=DE/ST=NRW/L=Earth/O=Random Company/OU=IT/CN=www.random.com/emailAddress=$1"
	echo "make client cert"
	openssl req -new -nodes -x509 -out certs/client.pem -keyout certs/client.key -days 3650 -subj "/C=DE/ST=NRW/L=Earth/O=Random Company/OU=IT/CN=www.random.com/emailAddress=$1"

itsrifat / extract_frames.cpp

Last active July 13, 2023 18:48

simple c++ functions to extract frames of a video file into a vector of Mat and saving the vector as jpg images using OpenCV 2.4.9

	/*
	This functions opens a video file and extracts the frames and put them into a vector of Mat(its the class for representing an img)
	*/
	void extract_frames(const string &videoFilePath,vector<Mat>& frames){

	try{
	//open the video file
	VideoCapture cap(videoFilePath); // open the video file
	if(!cap.isOpened()) // check if we succeeded
	CV_Error(CV_StsError, "Can not open Video file");

sergiotapia / md5-example.go

Last active August 19, 2025 09:37

Golang - How to hash a string using MD5.

	import (
	"crypto/md5"
	"encoding/hex"
	)

	func GetMD5Hash(text string) string {
	hasher := md5.New()
	hasher.Write([]byte(text))
	return hex.EncodeToString(hasher.Sum(nil))
	}

velosipedist / postgresql-list-foreign-keys.sql

Created October 31, 2013 13:52

List all foreign keys in PostgreSQL database, analog of MySQL SHOW CREATE TABLE mytable;

	--- Source: http://solaimurugan.blogspot.ru/2010/10/list-out-all-forien-key-constraints.html

	SELECT
	tc.constraint_name,
	tc.constraint_type,
	tc.table_name,
	kcu.column_name,
	tc.is_deferrable,
	tc.initially_deferred,
	rc.match_option AS match_type,

rgreenjr / postgres_queries_and_commands.sql

Last active October 29, 2025 19:10

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

spikebike / client.go

Created March 29, 2012 01:13

TLS server and client