CTEs, Recursion, and DFS in postgreSQL

While searching for the best way to write some backend methods I stumbled on an amazing, yet not so new feature of PostgreSQL . Since version 8.4 postgreSQL has supported Common Table Expressions (CTE) and recursion, which is useful for creating complex yet readable queries of hierarchical data. Straight from the postgreSQL docs: “Common Table Expressions or CTEs,…


Rule 41: The latest threat to online privacy

What is Rule 41? On December 1st 2016 the amendments to Rule 41 of the Federal Rules of Criminal Procedure by the United States Department of Justice became law.  The amendments give the FBI greater power and authority in cybercrime investigations.  The most significant changes to rule 41 allow the government to hack and monitor…


Generating Custom CSV Reports With Tshark

Tshark is a network protocol analyzer. Tshark is the command line version of the popular networking tool Wireshark. I will be going over some useful commands to filter pcap files and generate custom CSV reports with any fields of the packet data. Useful filtering options -r <infile> read data from input file -Y <display filter> Filter…


Pacman God Mode

This post is about how I used Flasm to achieve Pacman god mode. “Flasm disassembles your entire SWF including all the timelines and events” — http://flasm.sourceforge.net/.  It is available for Windows, Mac and Linux. You can find the flash file I used at: www.ondasdealegria.com/pacman.swf. Step 1: disassemble the swf file and direct the output to a…