Tutorials by ONLamp.com
Conventional wisdom claims that it's difficult to model hierarchical relationships in relationally minded SQL. Actually, it's easier than you think. Joe Celko explains one method of representing trees in SQL.
September 1,
2009
Today Views:
2 Total Views:
750
PHP 5 added several new features to the language, yet laundry lists and high-level overviews don't really show what they are or why you might use them.
August 27,
2009
Today Views:
1 Total Views:
677
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over.
August 24,
2009
Today Views:
1 Total Views:
803
PHP 5 has greatly improved object-oriented programming support. It also has new hooks to overload methods and properties. How can you do this? Why would you want to?
August 19,
2009
Today Views:
1 Total Views:
621
There's plenty of near-repetition in software development; writing very similar code over and over again. Stop copying, pasting, and modifying, and start automating the process!
June 23,
2009
Today Views:
1 Total Views:
659
A new MySQL storage engine allows you to use tables in remote servers as if they were local. Unfortunately, the documentation doesn't explain much more than that.
June 17,
2009
Today Views:
1 Total Views:
1,169
George Reese, coauthor of Managing & Using MySQL, 2nd Edition, offers a set of best practices for MySQL administrators that will help with the security, maintenance, and performance of a MySQL installation.
June 11,
2009
Today Views:
2 Total Views:
723
On the internet, how can you tell a person from a program written to act just like a person? One approach is to ask a question that (usually) only a human could answer.
June 8,
2009
Today Views:
1 Total Views:
729
The most popular "proper" way to build a web application seems to be to use the Model-View-Controller design pattern. While it sounds complex, the concepts are sound and the ease of development it provides are compelling.
May 26,
2009
Today Views:
1 Total Views:
1,117
The GROUP BY clause is the next step after mastering ORDER BY. John Paul Ashenfelter shows you how to combine database records into a single record to calculate an aggregate function.
May 18,
2009
Today Views:
1 Total Views:
602
