odan

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.

odan

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

odan

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:

odan

Free PHP Webhosting

• https://www.infinityfree.com/
• https://x10hosting.com/

Inexpensive Webhosting

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

odan

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

odan

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

Requirements

• MinGW-64

Setup

On Windows:

odan

@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"

odan

PHPStan rule to to disallow accidental assignments in conditionals

The url has changed:

https://odan.github.io/2023/01/12/phpstan-disallow-assign-in-conditional-rule.html

odan

MySqlMigrationSqlGenerator Example

dotnet add package MySql.Data.EntityFramework

using System.Configuration;
using System.Data;
using System.Data.Common;

odan

Creating a ASP.NET Core Web API from scratch

Requires .NET 8 SDK

dotnet new sln -o MyApi
cd MyApi

dotnet new webapi -o MyApi