Skip to content
View digitaladapt's full-sized avatar
3 followers · 7 following

Achievements

Achievement: QuickdrawAchievement: YOLOAchievement: Pull Sharkx2Achievement: Arctic Code Vault Contributor

Achievements

Achievement: QuickdrawAchievement: YOLOAchievement: Pull Sharkx2Achievement: Arctic Code Vault Contributor

Block or report digitaladapt

Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
digitaladapt/README.md

So, hi, I'm Andrew, though online I'm more commonly known as DigitalAdapt.

GitHub Stats

Most Used Languages

Pinned Loading

  1. preauth preauth Public

    Preauth: a simple way to help secure your web services.

    PHP 1

  2. shell-scripts shell-scripts Public

    Collection of shell scripts for linux servers.

    Shell 1

  3. html5up-readonly html5up-readonly Public

    Jekyll Theme based on Read Only by HTML5 UP

    JavaScript 1 1

  4. world-maps world-maps Public

    Playing around with various world map projections.

    HTML 1

  5. For the given database table, determ... For the given database table, determine a lower varchar limit that could be used for each varchar column.
    1 
    <?php
    2 
    
              
    
              
    
                3
                
    // WARNING: unsafe script, possible sql injection, it should use mysqli::real_escape_string().
    
              
    
              
    
                4
                
    // But I needed a quick simple script to find columns that I could be safely shrink. 
    
              
    
              
    
                5
                
    
              
    
          
    
    
    
  
    

    6. 

      

  6. 
  
    
    
    
      
    
        
        Monitor open tables to determine wha...  Monitor open tables to determine what tables are actively used across all databases.      
    

          
    
              
    
                1
                
    <?php
    
              
    
              
    
                2
                
    
              
    
              
    
                3
                
    // Goal: Call regularly to build a list of which tables (and database schemas) that are most frequently used.
    
              
    
              
    
                4
                
    // IE: place in crontab or similar, run every few minutes, and review after a week.
    
              
    
              
    
                5
                
    // polls "open tables", and updates "list.csv", format: "datbase,table,count".
    
              
    
          
    
    
    
  
    

    7.