Evan Cloutier evancloutier

## big-o.md

      
              1 file
            
          
              21 forks
            
          
              5 comments
            
          
              148 stars
            
          
                PJUllrich
                / big-o.md
            
            
              Last active
              June 28, 2024 20:25
            
              
                Big-O Time Complexities for Elixir Data Structures
              
          
    Big-O Time Complexities for Elixir data structures

Map [1]


Operation
Time Complexity


Access
O(log n)


Search
O(log n)


Insertion
O(n) for <= 32 elements, O(log n) for > 32 elements [2]


Deletion
O(n) for <= 32 elements, O(log n) for > 32 elements


## google_play_receipt_verification.md

      
              1 file
            
          
              5 forks
            
          
              3 comments
            
          
              19 stars
            
          
                derrek
                / google_play_receipt_verification.md
            
            
              Last active
              August 17, 2022 19:34
            
              
                Google Play/Android Receipt Validation/Verification/Lookup with Ruby
              
          
    This document outlines setting up google's ruby gem, google-api-client, to verify payloads(receipts) sent to a server from google play in app purchases made via an android app.

This document was written using version 0.9.13.
First you'll need 'owner' access to the google play developer's console that contains the mobile app you wish to verify receipts from.

Go to https://play.google.com/apps/publish
Click on the mobile app you'd like to set up
Click "Settings" on the left click "API access"
Below "LINKED PROJECT" link the google play account

Next setup an api account

  
## The Technical Interview Cheat Sheet.md

      
              1 file
            
          
              3399 forks
            
          
              904 comments
            
          
              8428 stars
            
          
                tsiege
                / The Technical Interview Cheat Sheet.md
            
            
              Last active
              June 28, 2024 10:38
            
              
                This is my technical interview cheat sheet. Feel free to fork it or do whatever you want with it. PLEASE let me know if there are any errors or if anything crucial is missing. I will add more links soon.
              
          
    ANNOUNCEMENT

I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!


\

  
## postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
Operation	Time Complexity
Access	`O(log n)`
Search	`O(log n)`
Insertion	`O(n)` for <= 32 elements, `O(log n)` for > 32 elements [2]
Deletion	`O(n)` for <= 32 elements, `O(log n)` for > 32 elements
	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'