Robert Rossmann robertrossmann

## all-indexes.sql
-- List all existing indexes and include some useful info about them (incl. the index's definition)

SELECT
    schemaname AS schemaname,
    t.relname AS tablename,
    ix.relname AS indexname,
    regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]*\((.*)\)$', '\1') AS columns,
    regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]*) \(.*', '\1') AS algorithm,
    indisunique AS UNIQUE,
    indisprimary AS PRIMARY,

## readme.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              8 stars
            
          
                robertrossmann
                / readme.md
            
            
              Last active
              November 25, 2021 15:04
            
              
                TypeScript - Intellisense support for ES modules (_.mjs_ files)
              
          
    TypeScript - Intellisense support for ES modules

This patch, based on commit https://github.com/Microsoft/TypeScript/commit/beebda3574be7f9a51f33ac24ab117f696ca9055, will add Intellisense support to projects which utilise the .mjs file extension for JavaScript modules.
⚠️ Warning


I have only used this from within tsserver. I did not attempt to use the tsc tool to do any kind of compilation of .mjs files.
This patch causes tsserver to treat all .mjs files as regular JavaScript files. This might be semantically wrong since these files have different semantics.

What works


## move_heroku_pg_to_aws_rds.md

      
              1 file
            
          
              1 fork
            
          
              2 comments
            
          
              12 stars
            
          
                halilim
                / move_heroku_pg_to_aws_rds.md
            
            
              Last active
              February 22, 2021 14:13
            
              
                Move Heroku Postgres to Amazon AWS RDS
              
          
Prepare your RDS instance and [authorize access to it][1] (basically make it public).


Put your app in maintenance mode:
heroku maintenance:on


Save the latest SQL dump of the DB:


## heroku-logs-with-bunyan.md

      
              1 file
            
          
              0 forks
            
          
              4 comments
            
          
              14 stars
            
          
                raine
                / heroku-logs-with-bunyan.md
            
            
              Last active
              August 3, 2018 19:14
            
              
                Read heroku log output with bunyan
              
          
    Read heroku logs output w/ bunyan

The stuff before the JSON in heroku logs output has to be cut off for
bunyan to work.
$ heroku logs | sed -l 's/.*app\[web\..*\]\: //' | bunyan
Flag -l makes the output buffered by line.

  
## patch-edid.rb
#!/usr/bin/ruby
# Create display override file to force Mac OS X to use RGB mode for Display
# see http://embdev.net/topic/284710

require 'base64'

data=`ioreg -l -d0 -w 0 -r -c AppleDisplay`

edids=data.scan(/IODisplayEDID.*?<([a-z0-9]+)>/i).flatten
vendorids=data.scan(/DisplayVendorID.*?([0-9]+)/i).flatten
	-- List all existing indexes and include some useful info about them (incl. the index's definition)

	SELECT
	schemaname AS schemaname,
	t.relname AS tablename,
	ix.relname AS indexname,
	regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]\((.)\)$', '\1') AS columns,
	regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]) \(.', '\1') AS algorithm,
	indisunique AS UNIQUE,
	indisprimary AS PRIMARY,
	#!/usr/bin/ruby
	# Create display override file to force Mac OS X to use RGB mode for Display
	# see http://embdev.net/topic/284710

	require 'base64'

	data=`ioreg -l -d0 -w 0 -r -c AppleDisplay`

	edids=data.scan(/IODisplayEDID.*?<([a-z0-9]+)>/i).flatten
	vendorids=data.scan(/DisplayVendorID.*?([0-9]+)/i).flatten