Adding script name on SQL queries

Have you ever done SHOW FULL PROCESSLIST on MySQL and found that there are some queries that has been running for a long time? Then you tried to find out from where the query was initiated so that you can debug those script only to find out that there are many similar queries from different […]

Posted on February 10th, 2009 under General SQL, PHP • 1 Comment

Banning Attributor Bot from your WordPress.

I’m not sure if it bugs you or not. If you’re reading this, chances are that you probably gets bugged by their activities. Attributor.com basically is a service to monitor your content and can notify you if someone uses parts of your article, images, or video without your consent. The idea is good. I even […]

Posted on February 9th, 2009 under Administration • No Comments

Keep replication in mind when writing SQL code.

This is something I got "bitten" once, especially if you have a development server with its own database not replicated and production database is replicated. That slight difference is enough to cause production problems that may not be noticeable days after production release. As a wise man say: When programming SQL statements, be mindful of […]

Posted on February 8th, 2009 under General SQL, Quick Tips • No Comments

Emulating nextval() function to get sequence in MySQL

There are times when auto increment is not sufficient. And there are times when what you need is actually a sequence. Unfortunately MySQL doesn’t have support for sequence. Having been working on PostgreSQL database as well, I found that it’s nextval() function is pretty nice. So in this article, I’d like to emulate (or implement) […]

Posted on February 8th, 2009 under MySQL • 22 Comments

Layman’s understanding of Networking & UDP/TCP/IP

In this article, I’d like to explain, in layman terms, how computer networking works, in particular TCP/IP — the protocol that’s used on the internet. It will cover internet addressing, domain names, and ports. Hopefully by the end of reading this article, you’ll be able to understand better about how information transfers among computers. On […]

Posted on February 4th, 2009 under Networking • 9 Comments

Page 6 of 11« First...45678...Last »