Danar Widi widiu7omo

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

JPG:
$ brew install jpegoptim
$ find . -name "*.jpg" -exec jpegoptim -m80 -o -p --strip-all {} \;

- PNG:
$ brew install optipng
$ find . -name "*.png" -exec optipng -o7 {} \;

	package
	{
	/**
	* ActionScript 3.0 Code Snippet
	* Convert Number to Rupiah & vice versa
	* https://gist.github.com/845309
	*
	* Copyright 2011-2012, Faisalman
	* Licensed under The MIT License
	* http://www.opensource.org/licenses/mit-license

	/* If you've ever had the need to link directly to an open modal window with Bootstrap, here's a quick and easy way to do it:

	Make sure your modal has an id:

	<div class="modal" id="myModal" ... >

	Then stick this bit of Javascript at at the end of your document:
	*/

	$(document).ready(function() {

	{
	"name": "my_vendor_name/my_package",
	"description": "My Package Description",
	"license": "GPL-3.0",
	"autoload": {
	"classmap": [ // search these directories for classes
	"lib/"
	]
	},
	"repositories": {

	@Override
	protected void onCreate(Bundle savedInstanceState) {
	super.onCreate(savedInstanceState);
	setContentView(R.layout.activity_main);
	Button button = (Button) findViewById(R.id.button);
	button.setOnClickListener(new View.OnClickListener() {
	@Override
	public void onClick(View v) {
	openDialog();
	}

	//http://stackoverflow.com/questions/105034/how-to-create-a-guid-uuid-in-javascript
	Math.random().toString(36).substring(2, 15) + Math.random().toString(36).substring(2, 15);

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>Bootstrap Table Checkbox Select All and Cancel</title>
	<link href="//cdn.bootcss.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
	</head>
	<body>
	<h2>Bootstrap Table Checkbox Select All and Cancel</h2>
	<table class="table table-striped">

	Backup:
	docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

	Restore:
	cat your_dump.sql \| docker exec -i your-db-container psql -Upostgres