Skip to content

Instantly share code, notes, and snippets.

@odan
odan / nginx-php-windows-setup.md
Last active January 31, 2023 17:05
Nginx and PHP Setup on Windows
View nginx-php-windows-setup.md

Nginx and PHP Setup on Windows

For local development you could also use Nginx with PHP as an replacement for XAMPP.

Install Nginx

@odan
odan / mysq_uuid_v4.md
Last active January 25, 2023 04:13
Generating UUID v4 in MySQL
View mysq_uuid_v4.md

Generating UUID v4 in MySQL

SELECT
  LOWER(
    CONCAT(
      # 1th and 2nd block are made of 6 random bytes
      HEX(RANDOM_BYTES(4)),
      '-',
 HEX(RANDOM_BYTES(2)),
@odan
odan / Program.md
Last active January 10, 2023 15:07
MySqlMigrationSqlGenerator Example
View Program.md

MySqlMigrationSqlGenerator Example

dotnet add package MySql.Data.EntityFramework
using System.Configuration;
using System.Data;
using System.Data.Common;
View aspnet-core-api.md

Creating a ASP.NET Core Web API from scratch

Requires .NET 7 SDK

dotnet new sln -o MyApi
cd MyApi

dotnet new webapi -o MyApi
View nes-cpu-cheats.md

NES RAM map

CPU Memory

NES Mega Man 5

  • $00B0: M. Buster - 00 to 9C (max)
  • $00BD: Number of E energy tanks - 80 to 89
  • $00BE: Number of M - 80 to 89
  • $00BF: Number of lives - 00 to 09
View removing-a-commit-from-github.md

Removing a Commit From Github

If you accidentally committed something you shouldn’t have, and pushed it to Github, there are still ways to delete or modify it.

You can do an interactive rebase, which is useful if the commit isn’t the most recent one. If the commit was, for example, 12 commits ago, you can rebase from then, remove the offending commit, and save.

git rebase -i HEAD~12
View slim4-oauth2-jwt.md
@odan
odan / xmapp-replacing-mariadb-with-mysql.md
Last active February 19, 2022 17:29
XAMPP - Replacing MariaDB with MySQL
View xmapp-replacing-mariadb-with-mysql.md

XAMPP - Replacing MariaDB with MySQL

This post has been deleted.