mrjman’s gists

mrjman / .cursorrules

Created June 1, 2025 01:16 — forked from boxabirds/.cursorrules

Rock solid: turn Cursor into a rock-solid software engineering companion

	# Project Policy

	This policy provides a single, authoritative, and machine-readable source of truth for AI coding agents and humans, ensuring that all work is governed by clear, unambiguous rules and workflows. It aims to eliminate ambiguity, reduce supervision needs, and facilitate automation while maintaining accountability and compliance with best practices.

	# 1. Introduction

	> Rationale: Sets the context, actors, and compliance requirements for the policy, ensuring all participants understand their roles and responsibilities.

	## 1.1 Actors

mrjman / CONVENTIONS.md

Created February 12, 2025 05:54 — forked from peterc/CONVENTIONS.md

CONVENTIONS.md file for AI Rails 8 development

You MUST NOT try and generate a Rails app from scratch on your own by generating each file. For a NEW app you MUST use rails new first to generate all of the boilerplate files necessary.
Create an app in the current directory with rails new .
Use Tailwind CSS for styling. Use --css tailwind as an option on the rails new call to do this automatically.
Use Ruby 3.2+ and Rails 8.0+ practices.
Use the default Minitest approach for testing, do not use RSpec.
Default to using SQLite in development. rails new will do this automatically but take care if you write any custom SQL that it is SQLite compatible.
An app can be built with a devcontainer such as rails new myapp --devcontainer but only do this if requested directly.
Rails apps have a lot of directories to consider, such as app, config, db, etc.
Adhere to MVC conventions: singular model names (e.g., Product) map to plural tables (products); controllers are plural.
Guard against incapable browsers accessing controllers with `allo

mrjman / JamHub-prompts.txt

Created October 30, 2024 00:36 — forked from jamonholmgren/JamHub-prompts.txt

	You are an email prioritization assistant. Analyze the following email and determine its priority level.

	Consider these factors for priority classification:

	GENERAL FACTORS:
	- Sender importance and relationship
	- Time sensitivity of the content
	- Required actions or responses
	- Impact of delayed response
	- Complexity of the request

mrjman / statistics.sql

Last active April 1, 2020 14:50 — forked from ruckus/statistics.sql

Postgres statistics queries

	** Find commmonly accessed tables and their use of indexes:

	SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct;

	Returns output like:

	relname \| seq_tup_read \| idx_tup_fetch \| idx_tup_pct
	----------------------+--------------+---------------+------------------------
	schema_migrations \| 817 \| 0 \| 0.00000000000000000000
	user_device_photos \| 349 \| 0 \| 0.00000000000000000000

mrjman / array_validator.rb

Last active December 21, 2016 20:46

Validator for Rails array columns

	# Usage:
	#
	# validates :array_column, array: { length: { is: 20 }, allow_blank: true }
	# validates :array_column, array: { numericality: true }
	#
	# It also supports sliced validation
	#
	# validates :array_column, array: { presence: true, slice: 0..2 }

	class ArrayValidator < ActiveModel::EachValidator

mrjman / gist:22a27208b89b2ef2bc7e

Last active August 29, 2015 14:06

	SELECT motor_symptoms.description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON motor_symptoms.id=profiles_motor_symptoms.motor_symptom_id WHERE profiles_motor_symptoms.profile_id=11;

	SELECT description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON profiles_motor_symptoms.motor_symptom_id=motor_symptoms.id;

mrjman / index.html

Last active August 29, 2015 14:05

jquery.scroll-nav plugin - scrolls to anchor on page and keeps track of active nav link

mrjman / simple_form_extensions.rb

Created August 26, 2014 14:50

	module Builder
	def collection_otherable_check_boxes(method, collection, value_method, text_method, options = {}, html_options = {}, &block)
	SimpleForm::Tags::CollectionCheckBoxes.new(@object_name, method, @template, collection, value_method, text_method, objectify_options(options), @default_options.merge(html_options)).render(&block)
	end

	def collection_nested_versionable(method, collection, value_method, text_method, options = {}, html_options = {}, &block)
	SimpleForm::Tags::CollectionCheckBoxes.new(@object_name, method, @template, collection, value_method, text_method, objectify_options(options), @default_options.merge(html_options)).render(&block)
	end
	end

mrjman / gist:5abea699d143c26c0520

Last active August 29, 2015 14:05

Export database from heroku and import locally

	curl -o `date +"%Y%m%d%H%M%S"_BACKUPFILENAME.dump `heroku pgbackups:url --app APPNAME`

	pg_restore --verbose --clean --no-acl --no-owner -h localhost -U PGUSERNAME -d LOCALDBNAME BACKUPFILENAME.dump

mrjman / gist:7afaf0e20d8768782c82

Last active August 29, 2015 14:05 — forked from kalmbach/gist:4471560

Rake migration tasks for Sequel

	namespace :db do
	require "sequel"
	Sequel.extension :migration
	DB = Sequel.connect(ENV['DATABASE_URL'])

	desc "Prints current schema version"
	task :version do
	version = if DB.tables.include?(:schema_info)
	DB[:schema_info].first[:version]
	end \|\| 0

Jesse mrjman