dumbbond / XmlLinqConversionExtensions.cs

Created May 25, 2023 20:13 — forked from ChuckSavage/XmlLinqConversionExtensions.cs

Convert To/From XmlDocument and XDocument/XElements

	using System.Xml;
	using System.Xml.Linq;

	namespace XmlLib
	{
	/// <summary>
	/// Provides extension methods for simple conversion between System.Xml and System.Xml.Linq classes.
	/// </summary>
	/// <remarks>From: http://brianary.blogspot.com/2010/02/converting-between-xdocument-and.html</remarks>
	public static class XmlLinqConversionExtensions

dumbbond / install virtualenv ubuntu 16.04.md

Created May 25, 2019 20:58 — forked from Geoyi/install virtualenv ubuntu 16.04.md

How to install virtual environment on ubuntu 16.04

How to install virtualenv:

sudo apt-get install python3-pip

sudo pip3 install virtualenv

dumbbond / postgresql-set-id-seq.sql

Created December 23, 2018 01:13 — forked from henriquemenezes/postgresql-set-id-seq.sql

PostgreSQL set Next ID Sequence Value to MAX(id) from Table

	-- Get Max ID from table
	SELECT MAX(id) FROM table;

	-- Get Next ID from table
	SELECT nextval('table_id_seq');

	-- Set Next ID Value to MAX ID
	SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));

dumbbond / gist:9670355f65202feb3753e55556db1ac7

Created December 21, 2018 12:42 — forked from peymano/gist:2047968

Restore from a binary Postgres dump file

pg_restore --clean --no-acl --no-owner -d <database> -U <user> <filename.dump>

dumbbond / gist:ee66998800a8857ab32f3ed24276ccd3

Created December 21, 2018 12:40 — forked from jdeoliveira/gist:4080656

Dump/restore a postgres database in binary format for distribution

	/Library/PostgreSQL/9.1/bin/pg_dump --host localhost --port 5432 --username <USERNAME> -b -c -E UTF-8 --no-owner --no-privileges --no-tablespaces --clean --schema public -F c -Z 9 -f <BACKUPFILENAME> <DATABASENAME>
	/Library/PostgreSQL/9.1/bin/pg_restore --host localhost --port 5432 --username <USERNAME> --dbname <DATABASENAME> --no-owner --no-privileges --no-tablespaces --clean --schema public "<BACKUPFILENAME>"

dumbbond / dokku_on_digital_ocean.md

Created November 25, 2018 18:10 — forked from henrik/dokku_on_digital_ocean.md

Notes from running Dokku on Digital Ocean.

My notes for Dokku on Digital Ocean.

These may be a bit outdated: Since I originally wrote them, I've reinstalled on a newer Dokku and may not have updated every section below.

Commands

Install dokku-cli (gem install dokku-cli) for a more Heroku-like CLI experience (dokku config:set FOO=bar).

# List/run commands when not on Dokku server (assuming a "henroku" ~/.ssh/config alias)

ssh henroku dokku

dumbbond / dokku_postgres_backups.sh

Created November 25, 2018 18:09 — forked from henrik/dokku_postgres_backups.sh

For `Flink/dokku-psql-single-container`. See https://gist.github.com/henrik/26bb73091712aa42abf2#db-backups

	#! /bin/bash
	# For use with Flink/dokku-psql-single-container.
	# Based on http://donpottinger.net/blog/2014/11/25/postgres-backups-with-dokku.html

	set -e

	BASE_DIR="/var/backups/postgres"
	mkdir -p $BASE_DIR

	YMD=$(date "+%Y-%m-%d")

dumbbond / dokku-pg-backup.sh

Created November 25, 2018 18:08 — forked from strukturedkaos/dokku-pg-backup.sh

	#! /bin/bash

	# directory to save backups in, must be rwx by postgres user
	BASE_DIR="/var/backups/postgres"
	YMD=$(date "+%Y-%m-%d")
	DIR="$BASE_DIR/$YMD"
	mkdir -p $DIR
	cd $DIR

	# make database backup