etoulas

## postgres-pivot.md

      
              1 file
            
          
              5 forks
            
          
              0 comments
            
          
              11 stars
            
          
                ryanguill
                / postgres-pivot.md
            
            
              Last active
              June 29, 2022 14:08
            
              
                Example of postgres pivot using jsonb_object_agg for variable columns in output. To play with this yourself in an online repl, click here: https://dbfiddle.uk/?rdbms=postgres_14&fiddle=39e115cb8afd6e62c0101286ecd08a3f
              
          
/*
================================================================================
Pivot example with variable number of columns in the output.
================================================================================

example data is straight forward, imagine a table with a customer identifier, 
an invoice date and an amount.
*/


## sync-rest-rpc.md

      
              1 file
            
          
              2 forks
            
          
              0 comments
            
          
              13 stars
            
          
                benjchristensen
                / sync-rest-rpc.md
            
            
              Last active
              January 15, 2018 07:24
            
              
                Regarding synchronous RESTful communication ...
              
          
    Response to https://twitter.com/jeffreymaxwell/status/705760483391963136 requiring more than the 77 characters left on Twitter.
DISCLAIMER: The quality of writing and thinking here is aligned with a Twitter conversation, not a blog post, presentation, or book ;-)

Synchronous RESTful communication between Microservices is an anti-pattern
...
you seem to being saying that the Netflix architecture (hystrix, eureka, ribbon, ..) is broken
...
hmm what would @benjchristensen say?


## gist:3425484ac5cce5298932

      
              1 file
            
          
              107 forks
            
          
              33 comments
            
          
              655 stars
            
          
                atcuno
                / gist:3425484ac5cce5298932
            
            
              Last active
              March 25, 2024 13:55
            
              
                HowTo: Privacy & Security Conscious Browsing
              
          
    The purpose of this document is to make recommendations on how to browse in a privacy and security conscious manner. This information is compiled from a number of sources, which are referenced throughout the document, as well as my own experiences with the described technologies.
I welcome contributions and comments on the information contained. Please see the How to Contribute section for information on contributing your own knowledge.
Table of Contents


Motivation
Audience
TL;DR?
Updates
Technologies that Affect Security and Privacy


## gist:d75101d9bdf764c890ef
# first:
lsbom -f -l -s -pf /var/db/receipts/org.nodejs.pkg.bom | while read f; do  sudo rm /usr/local/${f}; done
sudo rm -rf /usr/local/lib/node /usr/local/lib/node_modules /var/db/receipts/org.nodejs.*

# To recap, the best way (I've found) to completely uninstall node + npm is to do the following:

# go to /usr/local/lib and delete any node and node_modules
cd /usr/local/lib
sudo rm -rf node*

## folderize.rb
#!/usr/bin/env ruby
require 'yaml'
require 'fileutils'

class Folderize

  def initialize(config_file=false)
    config_file = File.expand_path("~/.folderize") unless config_file
    # Set up config
    unless File.exists?(config_file)

## gist:9509148
<html>
  <head>
    <style type="text/css">
    table table {
      width: 600px !important;
    }
    table div + div { /* main content */
      width: 65%;
      float: left;
    }

## gist:7803969
' http://support.microsoft.com/kb/291296/en-us
' http://superuser.com/questions/130592/how-do-you-force-excel-to-quote-all-columns-of-a-csv-file
' - change integer to long indexing
' http://stackoverflow.com/questions/2524703/save-text-file-utf-8-encoded-with-vba
' - output utf8 content

Sub QuoteCommaExport()
    ' Dimension all variables.
    Dim DestFile As String
    Dim FileNum As Integer

## django.cgi.py
#!/usr/bin/env python
# encoding: utf-8
"""
django.cgi

A simple cgi script which uses the django WSGI to serve requests.

Code copy/pasted from PEP-0333 and then tweaked to serve django.
http://www.python.org/dev/peps/pep-0333/#the-server-gateway-side
	# first:
	lsbom -f -l -s -pf /var/db/receipts/org.nodejs.pkg.bom \| while read f; do sudo rm /usr/local/${f}; done
	sudo rm -rf /usr/local/lib/node /usr/local/lib/node_modules /var/db/receipts/org.nodejs.*

	# To recap, the best way (I've found) to completely uninstall node + npm is to do the following:

	# go to /usr/local/lib and delete any node and node_modules
	cd /usr/local/lib
	sudo rm -rf node*
	#!/usr/bin/env ruby
	require 'yaml'
	require 'fileutils'

	class Folderize

	def initialize(config_file=false)
	config_file = File.expand_path("~/.folderize") unless config_file
	# Set up config
	unless File.exists?(config_file)
	<html>
	<head>
	<style type="text/css">
	table table {
	width: 600px !important;
	}
	table div + div { /* main content */
	width: 65%;
	float: left;
	}
	' http://support.microsoft.com/kb/291296/en-us
	' http://superuser.com/questions/130592/how-do-you-force-excel-to-quote-all-columns-of-a-csv-file
	' - change integer to long indexing
	' http://stackoverflow.com/questions/2524703/save-text-file-utf-8-encoded-with-vba
	' - output utf8 content

	Sub QuoteCommaExport()
	' Dimension all variables.
	Dim DestFile As String
	Dim FileNum As Integer
	#!/usr/bin/env python
	# encoding: utf-8
	"""
	django.cgi

	A simple cgi script which uses the django WSGI to serve requests.

	Code copy/pasted from PEP-0333 and then tweaked to serve django.
	http://www.python.org/dev/peps/pep-0333/#the-server-gateway-side