Skip to content

Instantly share code, notes, and snippets.

@odan
odan / composer-branch.md
Created September 20, 2024 18:25
Require dev branch in PHP with composer

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"
@odan
odan / php-wsl2-windows.md
Last active August 24, 2024 17:42
Local PHP dev environment setup

PHP development environment with WSL2

To install WSL2 in Windows run:

wsl --install

Enter a username and password.

@odan
odan / mssql-schema-dump.md
Last active June 29, 2024 15:13
Automate Your Database Schema Scripting with C# and SMO

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.

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);

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:

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);

PHP FFI - Using a C++ DLL with C bindings with MinGW-64

Requirements

  • MinGW-64

Setup

On Windows:

@odan
odan / unbloat.bat
Last active May 12, 2024 12:25
Remove Windows Bloatware
@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"