Sheerpower Logo

P.3  Introduction to SheerPower Internet Services (SPINS)

Overview of SPINS

Integrated with Sheerpower is SheerPower Internet Services (SPINS). It is designed for extreme speed, reduced server costs, and built-in anti-hacking security.

Main Components of SPINS

  • SPINS_Webserver: Extremely fast webserver integrated with SheerPower 4GL.
  • SheerPower Handlers: Fast execution, easy debugging, immune to SQL injection.
  • SheerPower Virtual Machine: Optimized for speed and low memory footprint.
  • ARS Database Engine: Designed for high speed, large datasets, and efficient concurrency.

SQL Injection Immunity

  • SPINS separates static SQL functions and user data, preventing injection attacks.
  • User-supplied data is treated strictly as text, never as executable code.

Denial of Service (DOS) Mitigation

  • SPINS webserver detects repeated requests from the same IP address and port.
  • Only processes the first and last of multiple identical requests, ignoring redundant ones.

LAMP Stack vs. SPINS

LAMP Stack SPINS
Apache starts on boot. PHP processes each request independently (allocates memory, initializes, connects to database, executes, terminates). SPINS webserver and handlers start on boot, allocate resources once, and reuse them for subsequent requests.
Frequent memory allocation and cleanup overhead per request. Efficient reuse of allocated memory, significantly reducing overhead.

Built-in ARS Database Engine Features

  • Highly optimized concurrency, using spinlocks with millions of checks per second per core.
  • Virtually unlimited support for number of columns, key sizes, and tables.
  • High-speed access—typical speed of over a million records per second with full record-level concurrncy.
  • Dynamic caching of data, providing extremely rapid repeated lookups.
  • Real-time backup without disrupting ongoing operations.
  • Supports specialized key types such as reverse text keys.
Summary: SPINS offers significant advantages in performance, security, scalability, and efficiency compared to traditional web server stacks. It is specifically optimized for business-critical, high-performance web applications.
Hide Description

    

        


      

      
Enter or modify the code below, and then click on RUN

     

    		

  

  
  

    
    

    
  
  

  
  

  
 

  



    

    Looking for the full power of Sheerpower? 
    

    Check out the 
   
   Sheerpower website.
   
   Free to download.  Free to use.