Client Driven Automation of Schema Evolution

The idea behind my final year project came from the tedium of having to write trivial SQL change scripts during my placement after editing an entity within the system.

Three solution we’re developed, initially a Scala implementation that I struggled to get working, then a C# prototype build in LINQPad, and finally a C# framework that is available on the NuGet package manager.

Source Code

C# Framework: GitHub Repository, NuGet Page

Prototype Repositories: C# PrototypeScala Prototype

 

Have I been pwned?

There’s a great new web application to check if any of your online accounts have been compromised in any of the major data breaches:

Have I been pwned?

Better yet the developer has extensively published about how he made the site on the Azure platform: http://www.troyhunt.com/2013/12/working-with-154-million-records-on.html.

Using PGP/GPG on Windows (and Chrome)

I’ve been looking for the ideal solution for using PGP on Windows that works with both local files and on the internet (for things like Gmail).

As a Chrome user there are no perfect solutions for using PGP within the browser using an extension. I finally came across a tool called WinPT which has solved this problem using the clipboard.

The Tools

Gpg4win

This provides the core software for encrypting and decrypting PGP messages and verifying signatures.

I’d actually recommend just download the Gpg4win-Light install as WinPT comes with its own key manager that works very well.

gpg4win

Gpg4win setup.

 

WinPT

WinPT is a taskbar front-end for GnuPG which includes key management, encryption via the clipboard, direct file encryption and support for OpenPGP smartcards. It is designed to make life easier for people who want encryption, and to make security less daunting for people who are new to securing data.

winpt

The taskbar menu for WinPT.

This is the tool that really allows you to integrate PGP with windows.

winpt-keymanager

The WinPT key manager.

The combinations of these two tools allows for hassle free use of PGP on a Windows system regardless of where the message is stored, be it on the web or in a file.