A New, Simple Way to Salt your Hashes
Instead of using a single string to season a whole site or saving each new salt with the salted hash, try using this method for simplicity.
2 commentsSave Tags: how-to, methodology, security
Secure Your OpenID
There are a lot of phishing vulnerabilities with OpenID, here is a solution.
0 commentsSave Tags: how-to, open source, usability, web services
Careful with Numeric Data Types in MySQL
TINYINT can be set to length of 4, but that doesn’t mean the max value is 9999.
0 commentsSave Tags: database, how-to
Conditions on Count or Sum in MySQL
When selecting count, sum, or some other aggregate function, the value isn’t determined until after the WHERE clause so a condition can’t be placed... more »
0 commentsSave Tags: database, how-to
Implementing HaloScan Powered Comments
The test page shows what the free service has to offer (rating, comments, trackbacks).
0 commentsSave Tags: javascript, tools, web services
Tips for MySQL to PostgreSQL Switch
If you’ve decided to move a few tables from MySQL to PostgreSQL, these few tips might help
0 commentsSave Tags: database, how-to, open source
Keep Friends Posted While on the Road
Going on an amazing road trip used to mean that you couldn’t update your stay-at-home friends about the stupid things you’ve done on your adventures... more »
1 commentsSave Tags: mobile
Swap Insert for Update When Key Exists
When synchronizing tables or databases, sometimes it is useful to have a way to update a row if there is already an entry for a key. Using the MySQL... more »
0 commentsSave Tags: database, how-to
How to Break a MySQL Left Join
Care must be taken when placing conditions on the results of the right-hand table of a LEFT JOIN because it could easily become a normal JOIN since... more »
0 commentsSave Tags: database, how-to
