Georgy Ivanov givanov2

pedrosancao / inotify_add_watch_recursive.php

Created July 25, 2020 18:11

PHP inotify_add_watch recursive

	<?php

	/**
	* @param resource $inotify_instance
	* @param string $pathname
	* @param int $mask
	* @return int[] watcher descriptors
	*/
	function inotify_add_watch_recursive ($inotify, $path, $mask)
	{

sanchezzzhak / clickhouse-get-tables-size.sql

Created January 18, 2018 13:43

clickhouse get tables size

	SELECT table,
	formatReadableSize(sum(bytes)) as size,
	min(min_date) as min_date,
	max(max_date) as max_date
	FROM system.parts
	WHERE active
	GROUP BY table

bladeSk / SQLite-PHP-quickstart.php

Last active March 6, 2026 08:04

SQLite3 PHP Quickstart Tutorial

	<?php
	// This file walks you through the most common features of PHP's SQLite3 API.
	// The code is runnable in its entirety and results in an `analytics.sqlite` file.


	// Create a new database, if the file doesn't exist and open it for reading/writing.
	// The extension of the file is arbitrary.
	$db = new SQLite3('analytics.sqlite', SQLITE3_OPEN_CREATE \| SQLITE3_OPEN_READWRITE);

	// Errors are emitted as warnings by default, enable proper error handling.

cdjhlee / zeromq_install.sh

Last active August 24, 2021 19:37

install zeromq in ubuntu 14.04

	#!/usr/bin/bash

	##############################################
	#from http://zeromq.org/intro:get-the-software
	##############################################

	#get zeromq
	wget http://download.zeromq.org/zeromq-4.0.5.tar.gz

	#unpack tarball package

cjthompson / RobustPDO.php

Created February 3, 2014 19:52

Extended PDO class that detects dropped connections and reconnects

	<?php

	class RobustPDO extends PDO
	{
	/** Call setAttribute to set the session wait_timeout value */
	const ATTR_MYSQL_TIMEOUT = 100;

	/** @var array */
	protected $config = [];
	/** @var bool For lazy connection tracking */

krcourville / gist:7309218

Created November 4, 2013 21:06

Navigate table with arrow keys using jQuery

	$('table.arrow-nav').keydown(function(e){
	var $table = $(this);
	var $active = $('input:focus,select:focus',$table);
	var $next = null;
	var focusableQuery = 'input:visible,select:visible,textarea:visible';
	var position = parseInt( $active.closest('td').index()) + 1;
	console.log('position :',position);
	switch(e.keyCode){
	case 37: // <Left>
	$next = $active.parent('td').prev().find(focusableQuery);