Vladislav Ktoxa

Best practices написание REST-API

Имена полей в ответе задавать в snake_case (prr_page, created_at, system_name,...)
Для времени использовать ISO 8601 (формат: YYYY-MM-DDTHH:MM:SSZ)
Отдавать данные (сам контент, поля сущностей, массивы сущностей), помещая их в data

Использование REST методов и примеры url'ов

GET: /api/users — получить список пользователей;
GET: /api/users/123 — получить указанного пользователя;
POST: /api/users — создать нового пользователя;

/*
Made by [egyJs.com](https://www.instagram.com/egyjs/);
*/

see it on :

install it on your localhost and try it :

http://youlink.epizy.com/?url=https://www.youtube.com/watch?v=YGCLs9Bt_KY

http://youlink.epizy.com/?url=https://www.youtube.com/watch?v=[ID]

Configure postfix as relay for macOS Sierra – Sonoma

1. Edit postfix configuration file

sudo vi /etc/postfix/main.cf
Ensure that the following values are set:

This is my take on how to get up and running with NGINX, PHP-FPM, MySQL and phpMyAdmin on OSX Yosemite.

This article is adapted from the original by Jonas Friedmann. Who I just discovered is from Würzburg in Germany. A stonesthrow from where I was born ;)

Xcode

Make sure you have the latest version of XCode installed. Available from the Mac App Store.

Install the Xcode Command Line Tools:

xcode-select --install

Эта версия статьи устарела. Новая версия статьи перенесена по адресу: https://github.com/codedokode/pasta/blob/master/db/trees.md

Как хранить в БД древовидные структуры

Те, кто знают английский, могут сразу перейти сюда: http://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database

Древовидные структуры - это такие структуры, где есть родители и дети, например, каталог товаров:

	server {
	listen 80;
	server_name localhost;
	root /Users/YOUR_USERNAME/Sites;

	access_log /Library/Logs/default.access.log main;

	location / {
	include /usr/local/etc/nginx/conf.d/php-fpm;
	}

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	if ! type "brew" > /dev/null; then
	ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)";
	fi
	brew cask install vagrant;
	brew cask install virtualbox;

	source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

	`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

	What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file. This is the password that you used to protect your keypair when you created your .pfx file. If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!. Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

	Now let’s extract the certificate:

	`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`