PostgreSQL provides us two very powerful features which are helpful with unit testing: transactional DDL and transaction savepoints. In this article I will show you how to use those with Flask-SQLAlchemy unit tests.

Transactional DDL means you can create tables inside a transaction, run tests against them, and roll back …

In a post a couple of years ago I gave an example on how to configure an Ubuntu 12.04 server to authenticate to Active Directory. Things used to be hard back then. Now we have the realmd realm enrollment manager to do the hard work of joining the host …

Alex's Tech Rants: Unit testing SQLAlchemy apps

An interesting approach to autocommit/explicit commit with SQLAlchemy/PostgreSQL

PostgreSQL transactions and SQLAlchemy | OddBird

git-new-workdir

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.

SQL Dump for MS Access databases (.mdb files) on Linux | Guy Rutenberg

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.