This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
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
| ## The following example demonstrates | |
| ## how a serach and replace string task | |
| ## can be peformed with R across several files | |
| ## Create two text files with content | |
| filenames <- c( tempfile(), tempfile() ) | |
| for( f in filenames ){ | |
| cat("We wish you a Merry Christmas!\n\nBest regards\n", file=f) | |
| } |
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
| ### PowerShell template profile | |
| ### Version 1.03 - Tim Sneath <tim@sneath.org> | |
| ### From https://gist.github.com/timsneath/19867b12eee7fd5af2ba | |
| ### | |
| ### This file should be stored in $PROFILE.CurrentUserAllHosts | |
| ### If $PROFILE.CurrentUserAllHosts doesn't exist, you can make one with the following: | |
| ### PS> New-Item $PROFILE.CurrentUserAllHosts -ItemType File -Force | |
| ### This will create the file and the containing subdirectory if it doesn't already | |
| ### | |
| ### As a reminder, to enable unsigned script execution of local scripts on client Windows, |
This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.
http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL
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
| # This is a GitLab CI configuration to build the project as a docker image | |
| # The file is generic enough to be dropped in a project containing a working Dockerfile | |
| # Author: Florent CHAUVEAU <florent.chauveau@gmail.com> | |
| # Mentioned here: https://blog.callr.tech/building-docker-images-with-gitlab-ci-best-practices/ | |
| # do not use "latest" here, if you want this to work in the future | |
| image: docker:20 | |
| stages: | |
| - build |
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
| SUBSYSTEMS=="usb", ATTRS{idVendor}=="", ATTRS{idProduct}=="", GROUP="cdrom", MODE="0666" |