John Kenn johnnncodes

johnnncodes / setup-postgresql-vagrant.md

Created July 11, 2019 06:03 — forked from carymrobbins/setup-postgresql-vagrant.md

Configure PostgreSQL in a Vagrant guest to allow connections from the host.

Configure Postgres

Update pg_hba.conf (most likely in /etc/postgresql/9.4/main) with -
- host all all 0.0.0.0/0 trust
Update postgresql.conf to use listen_addresses = '*'
Be sure to sudo service postgresql restart

Configure Vagrant

johnnncodes / rails_asset_pipeline_compiled_files.rb

Created September 15, 2019 15:57 — forked from mitio/rails_asset_pipeline_compiled_files.rb

Where the Rails' asset pipeline searches for asset files and how the config.assets.precompile directive works

	# Test the result of config.assets.precompile
	#
	# Check which files will be regarded as "manifests" and thus precompiled and be
	# available for standalone use via the /assets/<asset> URL when in production.
	# Execute this code in your Rails console.

	# First, you'll probably be in development mode, so add here your
	# additional production precompile patterns you want to test against.
	precompile = Rails.configuration.assets.precompile + [/^.+\.css$/, 'active_admin.js']

johnnncodes / nginx.conf

Created September 20, 2019 17:43 — forked from tompave/nginx.conf

commented nginx.conf for Ruby on Rails

	# A commented nginx configuration file for Ruby on Rails
	#
	# Author: Tommaso Pavese
	# [email protected]
	# http://tommaso.pavese.me
	#
	# License: http://www.wtfpl.net/
	#
	#
	# Tested with:

johnnncodes / nginx.conf

Created September 20, 2019 17:43 — forked from tompave/nginx.conf

commented nginx.conf for Ruby on Rails

	# A commented nginx configuration file for Ruby on Rails
	#
	# Author: Tommaso Pavese
	# [email protected]
	# http://tommaso.pavese.me
	#
	# License: http://www.wtfpl.net/
	#
	#
	# Tested with:

johnnncodes / postgres_queries_and_commands.sql

Created August 20, 2021 13:40 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- 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%'

johnnncodes / Kamal-Rails-Postgres-One-Server-Installation.md

Created June 26, 2024 01:47 — forked from code-206/Kamal-Rails-Postgres-One-Server-Installation.md

I think you have looked at the tutorial from Mr. Heinemeier Hansson at least once or twice and have a similar setup.

rails new kamal_pg --css tailwind --skip-test --database=postgresql

cd kamal_pg