When writiing database migrations (or reviewing them) look out for/add/avoid the following things:

1. Unique constraints on one column or composite c...

This post makes no effort to be the final word on normalization, nor does it aim to be exhaustive. It is, rather, a synthesis of existing resources wr...

Get all column names of a database table

SELECT COLUMN_NAME 
	FROM INFORMATION_SCHEMA.COLUMNS 
		WHERE 
    TABLE_SCHEMA = 'schema_name'
		A...

DB::statement('ALTER TABLE provisions ADD CHECK (IF(is_default, (SELECT COUNT(*) FROM provisions WHERE is_default = true) = 1, 1))');
```...

• Schemata table has default column already

• Ensure only ever one 'True' in the default column of the table

• Every time a mode Schema model is...

To pull in changes from just one file on another branch:

git checkout [branch_name] -- [file_path]

The -- relates to the UNIX shell, no...

1. LDAP servers
2. Apache Tomcat
3. POEDIT SOFTWARE https://poedit.net/
4. PO Files [link here](https://www.gnu.org/software/gettext/manual/html_node/...