Daniel Opitz odan

Using a specific branch instead of a version with composer

Example: Branch name is 5.x

{
    "repositories": [
        {
            "type": "git",
 "url": "https://github.com/odan/Slim.git"

PHP development environment with WSL2

To install WSL2 in Windows run:

wsl --install

Enter a username and password.

Exporting SQL Server database structure into SQL script files

Scripting your SQL Server database schema is one such task that can benefit significantly from automation. Using C# and SQL Server Management Objects (SMO), you can easily generate scripts for your database schema and data.

Automating database scripting ensures that your schema and data scripts are always up-to-date and reduces the risk of human error. It is particularly useful for version control, backups, and migration tasks.

By integrating it into your workflow, you can significantly enhance your database management processes.

Convert video to a Twitter-friendly format

Simple, but with minimum modification:

ffmpeg -i "input.mp4" -pix_fmt yuv420p -vcodec libx264 "output.mp4"

Resizes the video and may better support encodings:

Free PHP Webhosting

Inexpensive Webhosting

https://www.nearlyfreespeech.net/ ($0.25)
https://www.netcup.eu/ (~ $30 / year)
https://www.manitu.de/webhosting/

File Operations in C++

Reading a file into a string variable

#include <iostream>
#include <fstream>
using namespace std;

fstream file("file.name.xml", fstream::in);

	using System;
	using System.Collections.Generic;
	using System.Globalization;

	// CultureInfo culture = new CultureInfo("en-US");

	// Full-date notation as defined by RFC 3339, section 5.6, for example, 2024-03-28
	string date1 = string.Format("{0:yyyy}-{0:MM}-{0:dd}", DateTime.Now);
	Console.WriteLine(date1);

	@echo off

	winget list

	winget uninstall "Solitaire & Casual Games"
	winget uninstall "Microsoft Kontakte"
	winget uninstall "Movies & TV"
	winget uninstall "News"
	winget uninstall "Get Help"
	winget uninstall "Microsoft People"