PostgreSQL transactions and SQLAlchemy
An interesting approach to autocommit/explicit commit with SQLAlchemy/PostgreSQL
git-new-workdir
VPN between StrongSwan and SonicWall
Here's how to create a site-to-site VPN between StrongSwan and SonicWall. This has been tested with Ubuntu 14.04 and StrongSwan 5.1.2, and SonicWall with SonicOS 5.9 at the other end.
Table of Contents
SQL Dump for MS Access databases (.mdb files) on Linux
OpenStreetMap Nominatim Server for Geocoding
Thu 19-03-2015 18:04
｜
｜ tags: Apache Geoinformatics Nominatim OpenStreetMap PostGIS PostgreSQL Ubuntu ｜
11 minute read
Here's how to install the OpenStreetMap Nominatim service on your own server. It can be used to geocode and reverse geocode addresses and map coordinates. You will also get a web interface which loads map tiles from openstreetmap.org while doing geocoding requests using your own server.
I was faced …
Migrating from LocationClient to FusedLocationProviderApi
How To Clear Connections On A Sonicwall Without Restarting
Remove Unwanted Files From Git History
Here's an example of how to remove every *.pyc file from every commit in Git history. It is adapted from this Git help page.
Rewrite history
Run git filter-branch, forcing (--force) Git to process—but not check out (--index-filter)—the entire history of every branch and tag (--tag-name-filter cat -- --all …