Skip to content

Instantly share code, notes, and snippets.

View doggy8088's full-sized avatar
🙂
Giving is a reward in itself

Will 保哥 doggy8088

🙂
Giving is a reward in itself
4k followers · 52 following
View GitHub Profile
@doggy8088
doggy8088 / 0-README.md
Last active November 28, 2025 15:52 — forked from yigitkonur/llm-mermaid.md
A prompt for forcing AI to use mermaid more effectively
@doggy8088
doggy8088 / SQL 大師模式 (Read-Only).chatmode.md
Created October 21, 2025 06:49
description tools
Guidelines for generating SQL statements and stored procedures
changes
codebase
fetch
problems
runCommands
runTasks
search
searchResults
terminalLastCommand
terminalSelection

SQL Development

Database schema design

  • all tables should have a primary key constraint
  • all foreign key constraints should have a name
  • all foreign key constraints should be defined inline
@doggy8088
doggy8088 / Claude Code Release Notes.md
Last active October 20, 2025 14:43

Claude Code Release Notes [正體中文版]

版本 0.2.21

  • 模糊匹配 /commands

版本 0.2.26

@doggy8088
doggy8088 / ghcs.ps1
Created September 6, 2024 04:43
支援預設使用 PowerShell 執行環境的 GitHub Copilot Suggest Cmdlets，從 gh copilot alias 產生範本並加入預設 Prompt，請在下載後加入檔案到 $HOME\Documents\PowerShell\Scripts 目錄即可。
# Debug support provided by common PowerShell function parameters, which is natively aliased as -d or -db
# https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7.4#-debug
param(
[ValidateSet('gh', 'git', 'shell')]
[Alias('t')]
[String]$Target = 'shell',
[Parameter(Position=0, ValueFromRemainingArguments)]
[string]$Prompt
)
@doggy8088
doggy8088 / 2024 NTU GenAI MTK研究人員專題演講 (上半場) 總結.md
Last active May 28, 2024 00:58
2024 NTU GenAI MTK研究人員專題演講總結與 WebVTT 字幕 (License: Public Domain)
@doggy8088
doggy8088 / README.md
Last active July 19, 2025 12:45 — forked from Trenly/README.md
Install Winget to the Windows Sandbox Base Image

This powershell script modifies the Base Image, or the Virtual Hard Disk, which the Windows Sandbox launches upon startup. It will copy the required files to the sandbox and add a registry key which will install them upon startup. By default the script will install the latest stable release of Winget. You can specify to use the latest pre-release with the -PreRelease switch.

When a new version of Winget is released, run this script again to update the installation in the sandbox to the latest version

@doggy8088
doggy8088 / IE_README.md
Last active July 24, 2022 13:23

  1. 開啟 Windows PowerShell

  2. 將 IE 函式加入到 $PROFILE 之中

    [System.IO.Directory]::CreateDirectory([System.IO.Path]::GetDirectoryName($PROFILE))
notepad $PROFILE



  


  




    


          
    

      

        
        

          

              @doggy8088
          

          

            
                doggy8088
                / TimeOnlyConverter.cs
            
            

              Created
              June 11, 2022 09:20
            

          

        

      

        

  

    
    


        



  


  

        

          
          public class TimeOnlyConverter : JsonConverter<TimeOnly>
        

        

          
          {
        

        

          
          	private readonly string serializationFormat;
        

        

          
          

        

        

          
          	public TimeOnlyConverter() : this(null) { }
        

        

          
          

        

        

          
          	public TimeOnlyConverter(string? serializationFormat)
        

        

          
          	{
        

        

          
          		this.serializationFormat = serializationFormat ?? "HH:mm:ss.fff";
        

        

          
          	}
        

  





    


  




    


          
    

      

        
        

          

              @doggy8088
          

          

            
                doggy8088
                / DynamicJsonConverter.cs
            
            

              Last active
              March 7, 2025 09:45
            

          

        

      

        

  

    
    


        



  


  

        

          
          public class DynamicJsonConverter : JsonConverter<dynamic>
        

        

          
          {
        

        

          
          	public override dynamic Read(ref Utf8JsonReader reader, Type typeToConvert, JsonSerializerOptions options)
        

        

          
          	{
        

        

          
          

        

        

          
          		if (reader.TokenType == JsonTokenType.True)
        

        

          
          		{
        

        

          
          			return true;
        

        

          
          		}
        

  





    


  




    


          
    

      

        
        

          

              @doggy8088
          

          

            
                doggy8088
                / DateOnlyConverter.cs
            
            

              Created
              June 10, 2022 17:03
            

          

        

      

        

  

    
    


        



  


  

        

          
          public class DateOnlyConverter : JsonConverter<DateOnly>
        

        

          
          {
        

        

          
              private readonly string serializationFormat;
        

        

          
              public DateOnlyConverter() : this(null) { }
        

        

          
          

        

        

          
              public DateOnlyConverter(string? serializationFormat)
        

        

          
              {
        

        

          
                  this.serializationFormat = serializationFormat ?? "yyyy-MM-dd";
        

        

          
              }