bmaupin

See also:

• Free database hosting
• https://free-for.dev/#/?id=iaas
• https://free-for.dev/#/?id=paas

Service	Type	RAM	Storage	Limitations
👉 Adaptable	PaaS	256 MB	Non-persistent? (1 GB database storage available)
AWS EC2	IaaS	1 GB		⚠️ Only free for 1 year

towfiqpiash

#!/bin/bash

folders='Compressed Documents Images Music Programs Videos'
ext_comp="*.zip *.tar.gz *.tgz *.rar *.7z"
ext_doc="*.htm* *.php *.txt *.css *.doc* *.pdf *.PDF *.ppt* *.js *.csv"
ext_font="*.ttf"
ext_img="*.jp*g *.JPG *.png *.gif"
ext_music="*.mp3 *.aac *.wma"
ext_progrm="*.deb *.exe *.run *.sh"
ext_vid="*.mp4 *.mkv *.flv *.avi *.webm *.wmv"

oinopion

-- 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;