Akshay Birajdar the-spectator

the-spectator / read-access.sql

Last active May 17, 2019 07:29 — forked from oinopion/read-access.sql

How to create read only user in PostgreSQL

	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables #sidenote: please switch to DB for which you want to give access
	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;

the-spectator / 0. nginx_setup.sh

Created November 17, 2020 20:34 — forked from mikhailov/0. nginx_setup.sh

Nginx + secure pseudo-streaming

	# Nginx can serve FLV/MP4 files by pseudo-streaming way without any specific media-server software.
	# To do the custom build we use 2 modules: --with-http_secure_link_module --with-http_flv_module
	# This module "secure-link" helps you to protect links from stealing away.
	#
	# NOTE: see more details at coderwall: http://coderwall.com/p/3hksyg

	cd /usr/src
	wget http://nginx.org/download/nginx-1.5.13.tar.gz
	tar xzvf ./nginx-1.5.13.tar.gz && rm -f ./nginx-1.5.13.tar.gz

the-spectator / unroutable_routes.rake

Created May 31, 2022 19:41 — forked from natematykiewicz/unroutable_routes.rake

Find routes that will raise a routing error when requested

	desc 'Find routes that will raise a routing error when requested'
	task unroutable_routes: :environment do
	# A lot of this code was taken from how `rake routes` works
	# https://github.com/rails/rails/blob/f95c0b7e96eb36bc3efc0c5beffbb9e84ea664e4/railties/lib/rails/commands/routes/routes_command.rb

	require 'action_dispatch/routing/inspector'

	unroutables = Rails.application.routes.routes.
	map { \|r\| ActionDispatch::Routing::RouteWrapper.new(r) }.
	reject { \|r\| r.internal? \|\| r.engine? \|\| r.path.starts_with?('/rails/') \|\| !r.controller }.

the-spectator / requirements.txt

Last active March 29, 2024 10:50 — forked from nikhilweee/statement-to-excel.py

Convert HDFC Bank Credit Card statements from PDF to Excel