rusllonrails

```
PostgreSQL SQL Tricks I
```
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks_I

```PostgreSQL SQL Tricks II
```
http://postgres.cz/wiki/PostgreSQL_SQL_Tricks_II

```PostgreSQL SQL Tricks III

rusllonrails

https://github.com/ministryofjustice/prison-visits/search?utf8=%E2%9C%93&q=SendgridHelper

rusllonrails

http://docs.aws.amazon.com/ses/latest/DeveloperGuide/remove-from-suppression-list.html

rusllonrails

Need to add data-force-encoding="✓" for body in custom layout

Like:
body  data-force-encoding="✓"

rusllonrails

1) URL length - 2000 characters.
2) EMail content 550 Maximum line length
RFC 821 states the maximum line lengths for SMTP transmissions:

        command line

           The maximum total length of a command line including the
           command word and the <CRLF> is 512 characters.

        reply line

rusllonrails

1)
git reset --hard origin/your_branch

2) 
git branch -D your_branch
git fetch origin
git checkout -b your_branch origin/your_branch
git pull origin your_branch

rusllonrails

1) Check if array 'risk_phrases' in 'doc' jsonb column is not empty
(doc -> 'risk_phrases')::text <> '[]'::text

2) Check if key 'name' in 'doc' jsonb column is not blank
(doc ->> 'name')::text <> '{}'::text

3) Check if array 'supplier_ids' in 'doc' jsonb column contain at least of one element from array ['bar', 'goo', 'foo']
(doc -> 'supplier_ids')::jsonb ?| array['bar', 'goo', 'foo']

4) Check if key 'type' in 'doc' jsonb column  has defined "Vasa" value:

rusllonrails

sudo ufw enable
sudo ufw allow 22/tcp
sudo ufw status

rusllonrails

1)
You can edit the cron init script (/etc/init/cron.conf) as follow:
```
# cron - regular background program processing daemon
#
# cron is a standard UNIX program that runs user-specified programs at
# periodic scheduled times

description "regular background program processing daemon"

rusllonrails

mv ~/.local/share/Steam/ubuntu12_32/steam-runtime/i386/lib/i386-linux-gnu/libgcc_s.so.1{,.disable}
mv ~/.local/share/Steam/ubuntu12_32/steam-runtime/i386/usr/lib/i386-linux-gnu/libstdc++.so.6{,.disable}