Andrew Duberstein ajduberstein

## setup.cfg
# https://gist.github.com/althonos/6914b896789d3f2078d1e6237642c35c

[metadata]
name = {name}
version = file: {name}/_version.txt
author = Martin Larralde
author_email = martin.larralde@embl.de
url = https://github.com/althonos/{name}
description = {description}
long_description = file: README.md

## main.md

      
              1 file
            
          
              2 forks
            
          
              5 comments
            
          
              29 stars
            
          
                4rzael
                / main.md
            
            
              Last active
              April 25, 2024 04:41
            
              
                GIS with pySpark.
              
          
    NOTE : Take a look at the comments below !

GIS with pySpark : A not-so-easy journey

Why would you do that ?

Today, many datas are geolocalised (meaning that they have a position in space). They're named GIS datas.
It's not rare that we need to do operations on those, such as aggregations, and there are many optimisations existing to do that.

  
## Update-branch.md

      
              1 file
            
          
              64 forks
            
          
              29 comments
            
          
              283 stars
            
          
                santisbon
                / Update-branch.md
            
            
              Last active
              March 21, 2024 15:50
            
              
                Deploying from #Git branches adds flexibility. Bring your feature branch up to date with master and deploy it to make sure everything works. If everything looks good the branch can be merged. Otherwise, you can deploy your master branch to return production to its stable state.
              
          
    Updating a feature branch

First we'll update your local master branch. Go to your local project and check out the branch you want to merge into (your local master branch)
$ git checkout master
Fetch the remote, bringing the branches and their commits from the remote repository.
You can use the -p, --prune option to delete any remote-tracking references that no longer exist in the remote. Commits to master will be stored in a local branch, remotes/origin/master.


## postgres_queries_and_commands.sql
-- 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%'

## array.insert.js
Array.prototype.bisect = function (val) {
    var idx;
    if (this.length === 0) {
        return 0;
    }
    for (idx=0; idx < this.length; idx++) {
        if (val < this[idx]) {
            return idx;
        }
    }

## us_state_abbrev.py
# United States of America Python Dictionary to translate States,
# Districts & Territories to Two-Letter codes and vice versa.
#
# Canonical URL: https://gist.github.com/rogerallen/1583593
#
# Dedicated to the public domain.  To the extent possible under law,
# Roger Allen has waived all copyright and related or neighboring
# rights to this code.  Data originally from Wikipedia at the url:
# https://en.wikipedia.org/wiki/ISO_3166-2:US
#
	# https://gist.github.com/althonos/6914b896789d3f2078d1e6237642c35c

	[metadata]
	name = {name}
	version = file: {name}/_version.txt
	author = Martin Larralde
	author_email = martin.larralde@embl.de
	url = https://github.com/althonos/{name}
	description = {description}
	long_description = file: README.md
	-- 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%'
	# United States of America Python Dictionary to translate States,
	# Districts & Territories to Two-Letter codes and vice versa.
	#
	# Canonical URL: https://gist.github.com/rogerallen/1583593
	#
	# Dedicated to the public domain. To the extent possible under law,
	# Roger Allen has waived all copyright and related or neighboring
	# rights to this code. Data originally from Wikipedia at the url:
	# https://en.wikipedia.org/wiki/ISO_3166-2:US
	#