Júlio Filho juliolvfilho

## curl-with-sftp-https.md

      
              1 file
            
          
              2 forks
            
          
              1 comment
            
          
              4 stars
            
          
                tr4nk
                / curl-with-sftp-https.md
            
            
              Created
              January 6, 2018 05:58
            
              
                Install curl with sftp and https support on Ubuntu
              
          
Download latest curl
Manual install curl:

sudo apt install libssh2-1-dev libssl-dev
cd curl/
./configure --with-ssl --with-libssh2
make
sudo make install


Test installation:


## read-access.sql
-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

## web-servers.md

      
              1 file
            
          
              954 forks
            
          
              249 comments
            
          
              6050 stars
            
          
                willurd
                / web-servers.md
            
            
              Last active
              December 2, 2024 09:55
            
              
                Big list of http static server one-liners
              
          
    Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.
Discussion on reddit.
Python 2.x

$ python -m SimpleHTTPServer 8000
	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;