Guide

MySQL Best Practices

Database operations often tend to be the main bottleneck for most web applications today. As programmers need to do our part by structuring tables properly, writing optimized queries and better code. Table Names By convention, the “snake case” in lowercase (no PascalCase – we’re not using Microsoft SQL Server here!), plural name of the class will …

MySQL Best Practices Read More »

Connecting to Ubuntu Servers With RSA Keys

I manage a bunch of internal servers and for those that aren’t part of the wider web I like to use key pairs to speed up my sign ins and maintenance. Key-Based SSH Logins Key-based authentication is the most secure mode of authentication usable with OpenSSH. Key-based authentication has several advantages over password authentication, for example …

Connecting to Ubuntu Servers With RSA Keys Read More »

Simple Changes to Secure Apache

Keep Updated You should update your linux settings no less than once a month. This will ensure that you are not running vulnerable technology. Remove Header Details / Disable Tokens When Apache web server generates any web pages or error pages, some important information about the version and other details implemented on the system are …

Simple Changes to Secure Apache Read More »

Key PHP Developer’s Tools

Development Tools Netbeans – http://www.netbeans.org Dreamweaver for UI http://www.adobe.com Flux is good too and much cheaper (OSX Only) http://www.theescapers.com/flux/ TextWrangler for just simple text stuff (OSX Only) http://www.barebones.com/products/textwrangler/ or if you’re a PC person go with Notepad++ http://notepad-plus-plus.org/ Filezilla FTP for uploading and downloading to servers http://filezilla-project.org Google Chrome‘s built in developer tools rock http://chrome.google.com or Firefox with Web Developer …

Key PHP Developer’s Tools Read More »

Install Apache and PHP to do Secure h264 Pseudo Streaming

If you’ve ever wanted to stream MP4s securely over the internet while preventing hotlinking and stealing of your content, hopefully this helps. 1. Install Ubuntu Download and install Ubuntu from here 2. Install LAMPP settings Quick and dirty, just install MySQL Server: sudo apt-get install mysql-server Then install PHPMyAdmin – make sure to choose Apache2 …

Install Apache and PHP to do Secure h264 Pseudo Streaming Read More »