brew install redis
Set up launchctl to auto start redis
$ ln -sfv /usr/local/opt/redis/*.plist ~/Library/LaunchAgents
/usr/local/opt/redis/
is a symlink to /usr/local/Cellar/redis/x.y.z
(e.g., 2.8.7
)
ssh-keygen -t rsa -b 4096 -m PEM -f jwtRS256.key | |
# Don't add passphrase | |
openssl rsa -in jwtRS256.key -pubout -outform PEM -out jwtRS256.key.pub | |
cat jwtRS256.key | |
cat jwtRS256.key.pub |
Устанавливаем gitlab-runner: https://docs.gitlab.com/runner/install/linux-manually.html
Регистрируем runner: https://docs.gitlab.com/runner/register/
Добавляем ssh ключ в deploy keys (для доступа к репозиториям): https://docs.gitlab.com/ee/ci/ssh_keys/
Добавляем своего пользователя и пользоватея gitlab-runner в группу, которая будет иметь доступ к /var/www
:
/**
* Превращает массив PHP, в массив Postgres
* @param array $pgArray
* @return Expression
*/
static function createPgArray(array $pgArray): Expression
{
$pgArray = json_encode($pgArray, JSON_UNESCAPED_UNICODE);
$pgArray = "'".preg_replace("#^\[(.*)\]$#", '{\1}', $pgArray)."'";
# See your sequence name inside psql console with \ds command. | |
ALTER SEQUENCE seq RESTART WITH 1; | |
# Update sequence | |
UPDATE table_name SET id=nextval('seq'); |
Go to File -> Settings -> Tools -> Terminal and change Shell path based on the the installed git version.
for 64bit:
"C:\Program Files\Git\bin\sh.exe" --login -i
for 32bit:
"C:\Program Files (x86)\Git\bin\sh.exe" --login -i
Установка PHP:
sudo add-apt-repository -y ppa:ondrej/php
sudo apt update
sudo apt install php7.3
Установка важных расширений необходимых для пакетов Composer:
version: '3.7' | |
services: | |
postgres: | |
build: ./postgres | |
restart: always | |
environment: | |
POSTGRES_PASSWORD: 12345 | |
volumes: | |
- ./postgres/data:/var/lib/postgresql/data |