Skip to content

Instantly share code, notes, and snippets.

View igorpronin's full-sized avatar

Igor Pronin igorpronin

View GitHub Profile
@igorpronin
igorpronin / sql, postgres, psql
Last active March 14, 2025 01:00
PostgreSQL - шпаргалка
Перенес в my-mans
-- подключиться к postgres (утилита psql)
psql -U postgres
-- команды помощи
help
\h -- помощь по командам SQL
\? -- помощь по командам psql
@igorpronin
igorpronin / postgresql
Last active May 30, 2017 08:57
Подсчет количества элементов таблицы postgeSQL
SELECT count(*) FROM my_table;
-- больше способов
-- https://habrahabr.ru/post/30046/
@igorpronin
igorpronin / postgresql
Last active May 30, 2017 08:57
Вывести имена колонок и тип данных для определенной таблицы
-- 1
select column_name, data_type
from information_schema.columns
where table_name = 'users';
-- 2
SELECT
column_name, data_type, character_maximum_length
FROM
@igorpronin
igorpronin / css
Last active October 17, 2016 13:16
Убрать автоматическое изменение размера текста на мобильных устройствах (CSS)
1.
-webkit-text-size-adjust: none;
-ms-text-size-adjust: none;
2. Hack
max-height: 99999px;
@igorpronin
igorpronin / js
Created May 8, 2016 16:39
Методика анализа производительности // JS Ninja Secrets
start = new Date().getTime();
for ( n = 0; n < maxCount; n++ ) {
/* measuringFunction(); */
};
elapsed = new Date().getTime() - start;
alert("Measured time: " + elapsed);
@igorpronin
igorpronin / gist:4951939fd891a5c19c084ca8e7371127
Last active May 8, 2016 16:39
Методика тестирования // JS Ninja Secrets
assert(условие, сообщение);
assert(a == 1, 'Err, a not 1');
@igorpronin
igorpronin / gist:95eb611421c416f505f6990ce814de21
Created April 26, 2016 16:10
Gulpfile example, from LS Angular Course (lesson 1)
'use strict';
var gulp = require('gulp'),
concat = require('gulp-concat'),
scss = require('gulp-sass'),
uglify = require('gulp-uglify'),
plumber = require('gulp-plumber'),
ngAnnotate = require('gulp-ng-annotate'),
sourcemaps = require('gulp-sourcemaps'),
webserver = require('gulp-webserver');
@igorpronin
igorpronin / gist:1cbb1a81ce4b014b7e3fe8aca85b1331
Created April 19, 2016 18:53
google map styles from ask-new
;
google.maps.event.addDomListener(window, 'load', init);
function init() {
// Basic options for a simple Google Map
// For more options see: https://developers.google.com/maps/documentation/javascript/reference#MapOptions
var mapOptions = {
// How zoomed in you want the map to start at (always required)
zoom: 15,
@igorpronin
igorpronin / gist:733085b7573bcbb367c0b01498ec2b0f
Created April 17, 2016 17:46
Magnific Popup sass styles for Dialog with CSS animation
/* Styles for dialog window */
#small-dialog
background: white
padding: 20px 30px
text-align: left
max-width: 400px
margin: 40px auto
position: relative
@igorpronin
igorpronin / gist:ce5bd2ecc09264ceb7ce02d434a6db0b
Last active May 30, 2017 08:57
cmd commands, delete node_modules
npm install rimraf -g
rimraf node_modules
// Delete folder with all includes
rd /s/q path_to_folder
rmdir /s/q path_to_folder