This batch script starts the MSSQLLocalDB instance (if not already running), retrieves its named pipe connection string, updates the Windows Registry to point HeidiSQL to it, and finally launches HeidiSQL.
@echo off
REM Start LocalDB instance (if not already running)
sqllocaldb start MSSQLLocalDB
REM Get the named pipe connection string
| # Set the path to the folder containing the video files | |
| $folderPath = "C:\Users\me\Downloads\Movies" | |
| $cacheDir = "C:\Users\me\Downloads\Cache" | |
| $minSize = 3GB # minimal size to trigger a x265 conversion | |
| # Get a list of video files with "264" in the filename and .mkv or .mp4 extension, including subdirectories | |
| $videoFiles = Get-ChildItem -Path $folderPath -Filter "*264*.m*" -Recurse | Where-Object { $_.Extension -eq '.mkv' -or $_.Extension -eq '.mp4' } | |
| # Display the list of files, including their sizes | |
| Write-Host "List of video files to be converted:" |
| # THANKS TO: | |
| # https://www.casler.org/wordpress/synology-ssd-cache-on-external-devices/ | |
| # https://www.youtube.com/watch?v=KvW6LRw1RZs | |
| # THESE ARE THE synoinfo.conf CHANGES I MADE: | |
| # DEFAULT: | |
| maxdisks="2" | |
| internalportcfg="0x3" # 0000 0011 | |
| esataportcfg="0x4" # 0000 0100 |
| blueprint: | |
| name: Motion-activated Light with sun condition | |
| description: Turn on a light when motion is detected and sunset. | |
| domain: automation | |
| input: | |
| motion_entity: | |
| name: Motion Sensor | |
| selector: | |
| entity: | |
| domain: binary_sensor |
| @echo off | |
| echo Make sure you have the following installed correctly in your PATH: | |
| echo - Git | |
| echo - PHP (Or place the php directory in right here so php is in php/php.exe) | |
| pause | |
| set PHP_PEAR_PHP_BIN=php/php | |
| IF EXIST PHP_CodeSniffer ( | |
| cd PHP_CodeSniffer | |
| git pull | |
| cd .. |
| bin/bash | |
| bin/dd | |
| bin/ln | |
| bin/sed | |
| bin/vdir | |
| bin/bunzip2 | |
| bin/dir | |
| bin/ls | |
| bin/sh | |
| bin/zcat |