Image by Randall Munroe, xkcd.com
- Upgrading PHP packages only using composer
- Packages following semantic versioning only
Image by Randall Munroe, xkcd.com
stages: | |
- update-dependencies | |
- code-style | |
- build | |
- test | |
- deploy | |
composer-update: | |
stage: update-dependencies | |
only: |
SELECT | |
TABLE_NAME AS `Table`, | |
ROUND((DATA_LENGTH ) / 1024 / 1024) AS `Data (MB)`, | |
ROUND((INDEX_LENGTH) / 1024 / 1024) AS `Index (MB)`, | |
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Total (MB)` | |
FROM | |
information_schema.TABLES | |
WHERE | |
TABLE_SCHEMA = "my_db_name" | |
ORDER BY |
# rsync-homedir-excludes | |
# | |
# A list of files to exclude when backing up *nix home directories using rsync. | |
# | |
# Author: Ruben Barkow-Kuder <https://github.com/rubo77/rsync-homedir-excludes> | |
# Version: 2019-11-30 | |
# | |
# #Usage: | |
# USER=<homedir username here> | |
# rsync -aP --exclude-from=rsync-homedir-excludes.txt /home/$USER/ /media/$USER/linuxbackup/home/$USER/ |
alias gco='git checkout' | |
alias glg='git log' | |
alias gst='git status' | |
alias gbr='git branch' | |
alias grm='git rebase master' | |
alias gcom='git checkout master' | |
alias glo="git log --graph --pretty=format:'%Cred%h%Creset -%C(yellow)%d%Creset %s %Cgreen(%cr) %C(bold blue)<%an>%Creset' --abbrev-commit" | |
alias dco='docker-compose' | |
alias dphp='docker-compose exec -u www-data app php' |
-- source: https://blogs.sap.com/2016/10/27/create-tenant-database-sap-hana-express-sap-hana-academy/ | |
-- create a tenant | |
CREATE DATABASE TESTDB SYSTEM USER PASSWORD Initial1; | |
-- add the script server service | |
ALTER DATABASE TESTDB ADD 'scriptserver' | |
-- or hit two birds with one stone | |
CREATE DATABASE TESTDB ADD 'scriptserver' SYSTEM USER PASSWORD Initial1; | |
-- Tenants by default start automatically, but can be started and stopped manually as well |
#!/bin/sh | |
sudo chmod -x /usr/bin/gnome-keyring-daemon |
CREATE DATABAESE MYNEWDB; | |
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; | |
GRANT ALL PRIVILEGES ON MYNEWDB.* TO 'newuser'@'localhost'; | |
FLUSH PRIVILEGES; |