Skip to content

Instantly share code, notes, and snippets.

@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
@odan
odan / soap-xmldsig.md
Created June 1, 2021 14:23
Sign SOAP messages with xmlseclibs
View soap-xmldsig.md

Sign SOAP messages with xmlseclibs

Requirements

  • PHP 7.4+
  • OpenSSL

Generating Public and Private Keys

First we have to create a private key for signature creation, and a public key for verification.

@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)),
View User Authentication System.md

User authentication system

Your task is now to create a user authentication system.

This document will guide you through all the features and implication of such system, so that you don't have to search them yourself.

We will focus on web/browser-technologies, however similar concept can be widely applied. This guide, is a work in progress, feel free to comment and provide feedbacks.

Expected Workflows

View slim4-oauth2-jwt.md