| # Move typo3temp into RAM-Disk. Do not sync vendor and TYPO3-Directory. | |
| # For MAC: 'nocopy' will only work correct, if nfs_mount_enabled is true | |
| version: '3.6' | |
| services: | |
| web: | |
| volumes: | |
| - type: tmpfs | |
| tmpfs: | |
| size: 268435456 | |
| # TYPO3 8 |
| # Delete all duplicate sys_file_records, where one and the same sys_file UID | |
| # is related to the same tt_content record | |
| DELETE t_orig | |
| FROM sys_file_reference t_orig | |
| INNER JOIN sys_file_reference t_copy | |
| WHERE t_orig.tablenames='tt_content' | |
| AND t_orig.fieldname='image' | |
| AND t_orig.deleted=0 | |
| AND t_copy.tablenames='tt_content' | |
| AND t_copy.fieldname='image' |
This littel script fetches all packages, listed on packagist with type typo3-cms-extension, and iterates over them and collect download data for every single packages.
It will echo it as csv, so it can easily be parsed into a .csv file for better sorting etc.
$ php fetchExtensionDownloadDataFromPackagist.php > downloadData.csv
| # 1 | |
| # --------------------------------------------- | |
| # | |
| # Add tsconfig to load the custom RTE config: | |
| `RTE.default.preset = Custom` | |
| # 2 |
| SELECT table_name AS "Table", ROUND((data_length / 1024 / 1024), 2) AS "Data size (MB)", ROUND((index_length / 1024 / 1024), 2) AS "Index size (MB)" | |
| FROM information_schema.TABLES | |
| WHERE table_schema = "[database_name]" | |
| ORDER BY data_length DESC |
Since I need a TYPO3 test environment from time to time, I use these bash scripts for the automatic installation and removal of TYPO3. The installation script currently supports TYPO3 versions 10, 11, 12, 13 and dev.
I have stored the scripts under:
~/.shellscripts/typo3/
I use the following aliases:
| #!/usr/bin/env bash | |
| # shellcheck disable=SC2155 | |
| set -e | |
| RED="\033[0;31m" | |
| GREEN="\033[0;32m" | |
| YELLOW="\033[0;33m" | |
| CYAN="\033[1;36m" | |
| GRAY="\033[0;90m" | |
| NC="\033[0m" |