Magic words:
psql -U postgresIf run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*
| // npm i -g gulp | |
| // npm i gulp gulp-uglify gulp-rename gulp-concat gulp-header gulp-minify-css gulp-watch | |
| var gulp = require('gulp'), | |
| uglify = require('gulp-uglify'), | |
| rename = require('gulp-rename'), | |
| concat = require('gulp-concat'), | |
| header = require('gulp-header'), | |
| pkg = require('./package.json'), | |
| minifyCSS = require('gulp-minify-css'), | |
| watch = require('gulp-watch'); |
| " sudo add-apt-repository ppa:jonathonf/vim && sudo apt-get update && apt upgrade -y | |
| " Install Vundle | |
| " Install this .vimrc | |
| " :PluginInstall | |
| set nocompatible " be iMproved, required | |
| filetype off " required | |
| " set the runtime path to include Vundle and initialize | |
| set rtp+=~/.vim/bundle/Vundle.vim |
| # Enable this for template generation | |
| Alias /munin /var/www/munin | |
| # Enable this for cgi-based templates | |
| #Alias /munin-cgi/static /var/cache/munin/www/static | |
| #ScriptAlias /munin-cgi /usr/lib/munin/cgi/munin-cgi-html | |
| #<Location /munin-cgi> | |
| # Order allow,deny | |
| # Allow from localhost 127.0.0.0/8 ::1 | |
| # AuthUserFile /etc/munin/munin-htpasswd |
| PS1="\e[2m[\t]\e[0m \u@\h \e[93m\w\e[0m \$ " |
| # Stop all containers | |
| docker stop $(docker ps -a -q) | |
| # Delete all containers | |
| docker rm $(docker ps -a -q) | |
| # Delete all images |
| # Memory, CPU, etc | |
| # example: | |
| # CONTAINER CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS | |
| # gitlab_web_1 0.77% 1.046 GiB / 1.955 GiB 53.50% 196.4 kB / 1.907 MB 23.02 MB / 2.769 MB 0 | |
| # command: | |
| docker stats $(docker ps|grep -v "NAMES"|awk '{ print $NF }'|tr "\n" " ") |
| <?php | |
| function getPrice($productId) { | |
| $result = ''; | |
| $PRICE_TYPE_ID = 1; # just example, see in admin panel | |
| $rsPrices = CPrice::GetList(array(), array('PRODUCT_ID' => $productId, 'CATALOG_GROUP_ID' => $PRICE_TYPE_ID)); | |
| if ($arPrice = $rsPrices->Fetch()) | |
| { | |
| $result = CurrencyFormat($arPrice["PRICE"], $arPrice["CURRENCY"]); | |
| } | |
| return $result; |
| # This file is zentralized to be a Turorial. | |
| # I'm not sure about the full selfish-work. | |
| # We will isntall OpenSSL,NginX,PostgreSQL. | |
| # Than we will isntall Ajenti. | |
| # Than you must configurate Ajenti to not use SSL (we will changethis later back) | |
| # Followed we install Wordpress and you will have to install some plugins for PSQL and Nginx. | |
| # Ready to press words! | |
| # ---------- | |
| #remove instalaltion hardware ofthe sources.list | |
| nano /etc/apt/sources.list |
| install PostgreSQL 9 in Mac OSX via Homebrew | |
| Mac OS X Snow Leopard | |
| System Version: Mac OS X 10.6.5 | |
| Kernel Version: Darwin 10.5.0 | |
| Install notes for PostgreSQL 9.0.1 install using Homebrew: | |
| sh-3.2# brew install postgresql |