Title: PostGIS 2.0 Cheatsheet CSS : css/cheaters.css
Permalink to PostGIS 2.0 Cheatsheet
| PostgreSQL PostGIS Geometry/Geography/Box Types |
|---|
gruberdev
rgreenjr
/ postgres_queries_and_commands.sql
Last active
April 15, 2026 17:04
Useful PostgreSQL Queries and Commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- 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%' |
alirobe
/ reclaimWindows10.ps1
Last active
April 15, 2026 11:59
This Windows 10 Setup Script turns off a bunch of unnecessary Windows 10 telemetery, bloatware, & privacy things. Not guaranteed to catch everything. Review and tweak before running. Reboot after running. Scripts for reversing are included and commented. Fork of https://github.com/Disassembler0/Win10-Initial-Setup-Script (different defaults). N.…
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### | |
| ### | |
| ### UPDATE: For Win 11, I recommend using this tool in place of this script: | |
| ### https://christitus.com/windows-tool/ | |
| ### https://github.com/ChrisTitusTech/winutil | |
| ### https://www.youtube.com/watch?v=6UQZ5oQg8XA | |
| ### iwr -useb https://christitus.com/win | iex | |
| ### | |
| ### OR take a look at | |
| ### https://github.com/HotCakeX/Harden-Windows-Security |
curl -Ls http://bit.ly/go_installer | bash
If you want to install golang, normally you are following the description on the official dowload page
DavidWells
/ aligning-images.md
Last active
April 29, 2026 00:22
Guide to aligning images in github readme.md files. https://davidwells.io/snippets/how-to-align-images-in-markdown
This is a guide for aligning images.
See the full Advanced Markdown doc for more tips and tricks
svaksha
/ pythontojulia.md
Created
May 12, 2017 12:27
— forked from cuckookernel/pythontojulia.md
Python to Julia Quick translation / conversion reference Guide
A quick and dirty syntax translation / conversion reference guide to ease the transition between Python and Julia. This is not meant as a reference to the language. For that you should read the manual.
- Arrays in Julia are indexed starting from 1.
- In Julia classes (i.e. types) don't own methods. Methods are implementations of generic functions and are invoked in a "static style", i.e. instead of Python's str1.rstrip(), we will have rstrip( str1 ), instead of file1.close(), close( file1 ).
tomfanning
/ iscsi-target.txt
Created
November 15, 2017 15:12
Create an iSCSI target on ZFS on CentOS 7
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| zfs create -o volblocksize=32k -V 10G tslpool/iscsi1 | |
| zfs set sync=disabled tslpool/iscsi1 | |
| targetcli | |
| block/ create name=block_backend dev=/dev/zvol/tslpool/iscsi1 | |
| cd /iscsi | |
| create iqn.2017-11.com.mydomain.ad.zfstest:iscsidisk1 | |
| cd /iscsi/iqn.2017-11.com.mydomain.ad.zfstest:iscsidisk1/tpg1/acls | |
| # create acl with the initiator (client) name here, not the one you just created | |
| create iqn.1991-05.com.microsoft:dc1.ad.mydomain.com | |
| cd iqn.1991-05.com.microsoft:dc1.ad.mydomain.com |
troyharvey
/ .gitlab-ci.yml
Last active
March 6, 2026 08:33
Deploy Google Cloud Functions: GitLab CI/CD Pipeline Config File
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Update Jan 2024 | |
| # Deploying Cloud Functions is much simpler than it was 6 years ago. | |
| # I'm leaving the gist in it's original 2018 state for now, | |
| # but skip the the recent comments below for a simpler solution. | |
| variables: | |
| GCP_ZONE: us-central1-a | |
| stages: | |
| - npm-install |
cecilemuller
/ 2019-https-localhost.md
Last active
January 26, 2026 09:00
How to create an HTTPS certificate for localhost domains
This focuses on generating the certificates for loading local virtual hosts hosted on your computer, for development only.
Do not use self-signed certificates in production ! For online certificates, use Let's Encrypt instead (tutorial).
sillasgonzaga
/ api_quotas_fundos.R
Last active
September 15, 2025 05:36
API para baixar quotas de fundos
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(httr) | |
| library(magrittr) | |
| library(xml2) | |
| library(rvest) | |
| url_raw <- "http://dados.cvm.gov.br/dados/FI/DOC/INF_DIARIO/DADOS/" | |
| output_file <- "fundos/api/informe_diario.csv" | |
| csv_links <- httr::GET(url_raw) %>% | |
| httr::content("text") %>% |
OlderNewer